How can I compare two columns for matches

Fredric · Sep 30, 2004

I have two very long lists, one with 38000 entries. How can I easily compare
them without having to create a unique identifier with a tedious copy paste
step?

Dave Peterson · Sep 30, 2004

Chip Pearson has lots of techniques at:
http://www.cpearson.com/excel/duplicat.htm

(some worksheet formulas, some macros)

How can I compare two columns for matches

Fredric

Dave Peterson