I'd use a helper column and concatenate the values:

=a1&"..."&b1
and drag down.

Then use the techniques at Chip Pearson's site:
http://www.cpearson.com/excel/Duplicates.aspx

Max wrote:

Hello,

I have a 2 column spreadsheet. Column A contains a part number. Column B
contains a country of origin. Column A may or may not contain duplicate part
numbers and Column B may or may not contain a duplicate country of origin's.


WS23403 USA
WS23403 USA
WS23600 MEXICO
WS23600 USA
WS23600 USA

What I want to do is to get rid of those lines that are duplicates.

In the example I'd want to get rid of the first line and the last line.
I've played with countif but it really isnt useful in this case.
Suggestions?

Regards
Max

--

Dave Peterson