If this is something you have to do frequently, then check out Jim Cone's
fine commercial Add-in called XLCompanion. It has a feature for the
separation of "uniques"..........It's available at

http://www.realezsites.com/bus/primitivesoftware/

hth
Vaya con Dios,
Chuck, CABGx3




"Jac" wrote:

hi,

I have a list of data, for example like below:-
NAME PART_NO
AA 123
AA 123
AA 123
AA 345
AA 345
AA 678
AA 678
AA 890
BB 234
BB 345
BB 567
BB 567
BB 789
CC 123
CC 123
CC 123
CC 234

& I would like to sort out only those unique data from the list as below:
NAME Part_No
AA 123
AA 345
AA 678
AA 890
BB 234
BB 345
BB 567
BB 789
CC 123
CC 234

How would i have to do it? Cause the Name & Part No. may grow.
I have try out Advance Filter but I need to create a criteria table to
filter the list; so, somehow if the list is quite long, then I need to search
through the list to come out with the criteria to filter.
Therefore, I would like to look for any other more convenience way to handle
this problem. Anyone could help please.... it's urgent for me!

Thanking in advanced.