Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help comparing & flagging email lists
Problem:
column1 of worksheet1 contains a list of bad email addresses column1 of worksheet2 contains a list of all email addresses on file i need to compare the list of bad addresses (worksheet1) to the list of all email addresses (worksheet2) and if there is an email address in the bad list (worksheet1) which is also in the all emails list(worksheet2), i need to flag it by putting "bad" in the next column of the all addresses list (worksheet2). i've been looking through this forum for the past few days and can't seem to find something that can do this. it looks like it should be simple but i've had no luck. any help would be appreciated. p.s. the all email address list (worksheet2) can be quite long...around 8000 rows. Rich |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing lists | Excel Discussion (Misc queries) | |||
How to email word lists? | New Users to Excel | |||
Comparing lists with misspellings | Excel Discussion (Misc queries) | |||
Comparing two lists of financial data | Excel Discussion (Misc queries) | |||
Comparing prospect and buyers lists | Excel Worksheet Functions |