Hi Tom,

What about if you have 10 duplicates in Column 1 and then you need to
find the ones that are dplicated in column 2 as not all match, what do
you do?

i.e

1 A
1 B
1 A
2 A
2 B
2 A


would leave you with


1 B
2 B


---
Message posted from http://www.ExcelForum.com/