Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare 3 lists
I need to compare 3 lists (columns) of asset numbers that come from 3
different sources. I have copied the 3 columns onto 1 sheet and sorted them. What I am looking for is to know which numbers exist in all 3 lists and which do not and which lists they do not exist in. In my example, my resultant set would need to let me know that 1231391 was in all 3 lists, but that 1231392 was only in A and C, not B, and that 1233320 was in B, but not in A or C. And as you can see, the same numbers do not always line up but do exist in all 3 lists. Example: ListA ListB ListC 1231391 1231391 1231391 1231392 1231393 1231392 1231393 1231396 1231393 1231396 1231397 1231396 1231397 1231398 1231397 1231398 1231399 1231398 1231399 1231400 1231399 1231400 1233320 1231400 Thanks, Bill Kennedy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare lists | Excel Discussion (Misc queries) | |||
compare two lists | Excel Discussion (Misc queries) | |||
Compare two lists | New Users to Excel | |||
Compare two lists? | Excel Discussion (Misc queries) | |||
Compare Lists | Excel Programming |