Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing name list (only add new names) ?
Good morning, I have a list of names (several thousand) that I have imported
into Excel. I will have to import an updated list around once a month. Is there a way to have my current list add only the new names that appear on the imported list versus replacing my list with the new one? On the new list there will be names added and removed, but on my main list I only want to accept names that were added. So, simply replacing my list each month won't work for my situation. Thank you for any assistance, -Kevin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing name list (only add new names) ?
Let's say we have a workbook with two tabs, my list and monthly list. FOr
example in my list: NAMES mike john jim sally mary sue bill Every month we first clear the data in monthly list and then import the new month's data starting in cell A2: Person david ivan jim john mary mike sally trevor wilber Some names are old, some are new. In cell B2, enter: =COUNTIF('my list'!A:A,'monthly list'!A2) and copy down. We see: Person Flag david 0 ivan 0 jim 1 john 1 mary 1 mike 1 sally 1 trevor 0 wilber 0 The names with zero are new names. Trun on AutoFilter for column B and select only rows with zeros. Copy the visible names and paste into the my list tab. -- Gary''s Student - gsnu200775 "Kevin" wrote: Good morning, I have a list of names (several thousand) that I have imported into Excel. I will have to import an updated list around once a month. Is there a way to have my current list add only the new names that appear on the imported list versus replacing my list with the new one? On the new list there will be names added and removed, but on my main list I only want to accept names that were added. So, simply replacing my list each month won't work for my situation. Thank you for any assistance, -Kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
Importing Names | New Users to Excel | |||
create a random list of names from a list of names in EXCEL | Excel Worksheet Functions | |||
filter 400 names from list 1 from list 2 with 4000 names | Excel Worksheet Functions | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions |