Prev Previous Post   Next Post Next
  #3   Report Post  
Steven
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why is my text changing to pound signs? SleepyDawn Excel Discussion (Misc queries) 2 February 9th 05 10:52 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
how to hyperlink text to a cell steve New Users to Excel 1 December 14th 04 08:21 PM
Macro or Function to make text size to suite text Length? lbbss Excel Discussion (Misc queries) 4 December 14th 04 07:53 PM
Counting Repeated text or duplicates in a list Repeatdude Excel Discussion (Misc queries) 5 November 26th 04 07:10 PM


All times are GMT +1. The time now is 12:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"