If you start a blank document and go through the process of writing the
formula to find duplicates then applying it to the cell you want, you can
then use "save as" and at the bottom where it says "Save as Type" Choose
Template. Then when you want to use it in a new file just open the new file
using the template you created.

the other option is to create a macro, but this is more difficult because
you need to save it in a workbook under personal macro. It gives you this
option when you create the macro. btu then this workbook needs to be open
any time you want to use the macro. so you will have to open both the
document you want to use the macro in and the document personal where you
saved the macro.

"R. Choate" wrote:

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