Find Duplicate cells

  • Thread starter Thread starter Keith Ward
  • Start date Start date
K

Keith Ward

Hi,

I have a list in my worksheet. I would like to find duplicate fields within
the list. Just like in Access, so I can modify them so they are unique.

How do I go about this?

Thanks

Keith
 
Hi.

Have you tried highlighting the columns and then using the data autofilter
option. You can then choose the value from the filter drop-down and see if
more than one row is returned.

Ron
 
Back
Top