How to delete duplicates based on data in 2 columns?
 

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

How to delete duplicates based on data in 2 columns?
 

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

How to delete duplicates based on data in 2 columns?
 

Thanks Dave... that did help. I also found that filtering for unique records
was helpful.

Regards
Max

"Dave Peterson" wrote:

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