| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
look up names in one excel tab to find a match in another tab
I have two tabs in an excel worksheet. The first tab is an older list of
names. The last name is in column A and the first name is in Column B. The second tab is a recent list with new names added that are not on the first tab, which is an older list. How do I search the names in the 2nd more recent list to see which names are not on the original list? I need to know what names have been added on the recent list that are not on the older list. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
look up names in one excel tab to find a match in another tab
In "recent" worksheet, column C, enter:
=SUMPRODUCT((A1=Sheet1!A$1:A$999)*(B1=Sheet1!B$1:B $999))=0 This will return True if entry not found in "older" list. HTH -- AP "mike" a écrit dans le message de news: ... I have two tabs in an excel worksheet. The first tab is an older list of names. The last name is in column A and the first name is in Column B. The second tab is a recent list with new names added that are not on the first tab, which is an older list. How do I search the names in the 2nd more recent list to see which names are not on the original list? I need to know what names have been added on the recent list that are not on the older list. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help find automate way to cross reference two GAINT excel databases!! | Excel Worksheet Functions | |||
| How to import names into Excel | Excel Discussion (Misc queries) | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
| find LAST match in column | Excel Worksheet Functions | |||
Linear Mode
