Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]()
You can use VLookup on the new names against the old list and if the name is
found do not add it. Example: Cell A2 Cell B2 New Name1 =VLookup(a2,Range of main list,Column Offset,0) If it returns an #N/A then this is a new name. If the name exists then the formula will return the name. If you need to test two cells at the same time like Last Name First Name where they are not together in the same cell then you may have to concatenate the name for example: Column A has Last Name and Column B has FirstName then you can put in Column C =A2&" " &B2 and then do the same with the new data and then do the lookup. Hope this addresses your question correctly. Steven |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why is my text changing to pound signs? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
how to hyperlink text to a cell | New Users to Excel | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) |