View Single Post
  #3   Report Post  
Amie G
 
Posts: n/a
Default How do I locate duplicate records in Excel?

Thanks RD!

I've already been to his site and tried multiple methods he suggests, but
haven't had any luck. The "highlighting" instructions don't apply to my
scenario because his example only looks for duplicates within one single
column.

It seems like perhaps one of the bottom options might work but I don't know
which one or even what exactly he's saying to do. I'm not familiar with
Excel terminology so I don't really understand.

It seems like I might have to combine a few of his suggestions since the
"extracting" ones at the bottom don't say anything about highlighting.

Any further suggestions? I appreciate it!




"RagDyer" wrote:

Check out Chip Pearson's web site:

http://www.cpearson.com/excel/topic.htm

Scroll down to the D's, and see all the pages on handling duplicates.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================