| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
find names on list 1 in list 2. list 1 4000 names list 2 400 name
I need help comparing 2 lists in excel. Here is my goal; I have one list with
4500 names and one list with 400 names. I would like to find out which of the 400 names is on the 4500 name list. how do I do it? thanks for your help. |
|
#2
|
|||
|
|||
|
You can use the technique described here
http://www.cpearson.com/excel/duplicat.htm -- Regards, Peo Sjoblom (No private emails please) "Ed" wrote in message ... I need help comparing 2 lists in excel. Here is my goal; I have one list with 4500 names and one list with 400 names. I would like to find out which of the 400 names is on the 4500 name list. how do I do it? thanks for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique Names in list w/ Additional Criteria? | Excel Worksheet Functions | |||
| Setting up a random list from long list of names ? | Excel Discussion (Misc queries) | |||
| How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
| How can I find the common names in two columns of names? | Excel Discussion (Misc queries) | |||
| How do I put a list of names and e-mail addresses in excel so tha. | Excel Discussion (Misc queries) | |||
Linear Mode
