duplicate entries

[Richard Mahan]

I have a rather large spreadsheet of Names, addresses, etc. I have noticed
that there are many duplicate entries.

any suggestions or formulas that would allow me to highlight the duplicates
preferably in color, would be much appreciated.

Please keep in mind, that I am a beginner with excel, so I need something
simple and uncomplicated.......Thanks

 

[Steve Katz]

microsoft.public.excel

 

[Alan Brown]

I have a rather large spreadsheet of Names, addresses, etc. I have noticed
that there are many duplicate entries.

any suggestions or formulas that would allow me to highlight the
duplicates

Why not just delete them?

Data / Filter / Advanced filter / filter in place / unique records only

make sure you select the data to search through.

or you could move the uniques records to a place further down the sheet

As always don't work on your orignal data, make a copy before starting.

alan