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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking for an Unique Data in Data List
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking for an Unique Data in Data List
Thanks for the reply!
"CLR" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking for an Unique Data in Data List
One possibility is to combine the cells.
in c1 type =a1&b1 copy it all the way down You will get NAME PART_NO NAMEPART_NO AA 123 AAA123 AA 123 AAA123 AA 123 AAA123 AA 345 AAA345 AA 345 AAA345 I suggest at this point copying column C and pasting it as values then using ctrl-h to replace all spaces. Then use an equation like =if(c2=c1,dup,"") This should give something like NAME PART_NO NAMEPART_NO Check AA 123 AAA123 AA 123 AAA123 dup AA 123 AAA123 dup AA 345 AAA345 AA 345 AAA345 dup this will put dup where c2 is the same value as c1. Then you can filture column c for dup and delete or hide as neccesary. It wouldn't be to hard to write a macro for this and run it when you need to. 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. |
Reply |
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 |