Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking for an Unique Data in Data List
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Unique numbers from data validation list | Excel Worksheet Functions | |||
How can I average data from a repeating list into a unique list? | Excel Worksheet Functions | |||
Compare multiple column of data and list out common and unique component in adj columns | Excel Worksheet Functions | |||
subtotaling and manipulating a list of data | Excel Worksheet Functions |