I know that Excel's advanced filter feature allows me to find unique items in a list, but I need to find duplicates in a list. I
know how to write a formula I can put in a blank column, which will give me duplicates within my list after I copy the formula down,
but this is a bit "too manual" for my needs. This requires me to write a new formula, or edit all the references, when I want the
information in a new file. Is there a more "built-in" way of getting this info? Why isn't Microsoft giving me this option when they
give me the ability to extract a list of unique values. It seems that if they go to the effort to provide unique items, they would
also provide duplicate items.
--
RMC,CPA