I recently noticed that when recording a macro the "Stop Recording" box no longer appears on the spreadsheet.
Does anyone know where it hides?
Also is there a quick method to restore excel to its "factory" settings?
After experimenting, it often takes me a while to restore everything back to what it looked like before I started messing with it.
Do you do all your stripping of bad characters in one pass or many passes?
Usually reducing the number of passes through the data will speed things up.
After many years of using excel I just didn't know that....Thanks again
I guess it's the "old ,microsoft rule" when in doubt right click!!
Actually it was High and needed to be set to Medium for the choise to be offered.
I would like to know how it got High all of a sudden and for no apparent reason.
Every excel file that contains a macro is opening without asking the enable/disable macro question.
The result is macros are disabled and I can't figure out how to enable them.
Everything has been working fine for years, this thing just started happening.
Yes PJ KARAFFA I do realize that this deviates from the original question, it was as stated just a bit of extra info.
Your formula is also very creative and very usefull, I'll add it to my goodie box.
Mine was meant to be a quick way to visit any row (of many unsorted rows) and quickly know a count of occurances.
In addition to eliminating the duplicates you may at some time wish to tally the number of duplicates, like how many times does NY or CA or 3 or 1 show up.
=COUNTIF(A:A,INDEX(A1,1,1)) in B1 produces:
Just a quick way to total up the duplicates.