filtering unique data

[kuansheng]

Hi guys,

I have in column A part number, column B quantity and column C part
description. What i am trying to do is to filter out the unique entry
according to the part number and remove the dulpricates. Can anyone
help me out in this. Thanks

Before
part number quantity description
020-1234-14 1 upper barrel
034-1111-34 2 lower barrel
020-1234-14 1 upper barrel

After
part number quantity description
020-1234-14 1 upper barrel
034-1111-34 2 lower barrel

regards.
kuansheng

 

[Bob Phillips]

Data>Filter>Advanced Filter

That has a unique records option

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[kuansheng]

I have try that method but its seem to display some duplicate in the
result . I have check the data and they exactly similar no difference.
I am wondering why duplicate data are disp[lay. Is there any way to
make sure the the filtered data is correct with no duplicate. Thanks.

 

[Bob Phillips]

It must be a data problem. I have never seen it duplicate data.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[broro183]

Hi,
I agree with Bob, & have a few ideas/questions which may help identify
what the data problem is:

*Firstly, when you use the Data>Filter>Advanced Filter option, make
sure you are only selecting column A (ie just the part number column,
not columns A to C) as your "List Range".
*Do you know that it will always show the first appearance of a value
(ooopps, looks like you do from your original post)?

*Are any/none of the "duplicate" rows hidden?
*If you identify two of the visible "duplicates", find any empty cell &
enter (for example):
=A1=A3
Is the result "true"?
If not, it may be due to non printing characters in one of the cells.
One way of checking this is using =len(a1)=len(a3), if this is not
true, there is something in the cell that can't be seen. It may be
possilbe to fix using the trim function.

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...

I have try that method but its seem to display some duplicate in the
result . I have check the data and they exactly similar no difference.
I am wondering why duplicate data are disp[lay. Is there any way to
make sure the the filtered data is correct with no duplicate. Thanks.

 

[kuansheng]

Thanks Guy i will look at the data again to make sure nothing goes
wrong thank for your advice.