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

*Firstly, when you use the DataFilterAdvanced 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...



kuansheng Wrote:
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.


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=536736