Record duplication

[Tabitha Hammond]

Hiya
I¹ve got two lists with 10k records in each and I want to see which records
appear in both lists.
Is there a way of doing this in excel?
Tab

 

[Gord Dibben]

Tabitha

See Chip Pearson's site for working with, tagging and extracting duplicates.

Extracting from two lists is down near the bottom of the page.

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates


Gord Dibben Excel MVP