Posts by mscallisto

    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.

    Thanks Smiley


    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!!

    Thanks Blue


    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:


    A1 B1
    1 3
    2 2
    2 2
    1 3
    1 3


    Just a quick way to total up the duplicates.