In Execl select unique rows from 2 different worksheets (or workb.

mcrmcr05 · Jul 15, 2005

In Excel, is there any way to compare 2 different worksheets (or workbooks)
and select only the unique rows that are in both?

Ahmed El Hadary · Jul 15, 2005

me also i loock about if you have any info com to you please inform me if you
can
thanks

Dave Peterson · Jul 15, 2005

Chip Pearson has lots of ways to work with duplicates/uniques at:
http://www.cpearson.com/excel/duplicat.htm