duplicate entries

  • Thread starter Thread starter Richard Mahan
  • Start date Start date
R

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
 
Richard Mahan said:
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
Click to expand...

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
 
Back
Top