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

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

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
>