"Richard Mahan" wrote in message
...
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