| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel. How do I remove 1,000 mailed addresses from list of 2,265?
With data in Sheet1 (2265) and Sheet2 (1000) ; apply the below formula in
Sheet1 cell B1 and copy down to row 2265..... =IF(COUNTIF(Sheet2!A:A,A1),"","Mail to be sent") -- Jacob (MVP - Excel) "Phil C." wrote: I have a mailing list of 2,265 names. Someone has randomly seleceted 1,000 names from the list and mailed them. I need to mail the other 1,265. I have two Excel workbooks with 2,265 names in one and 1,000 in the other. I need to be able to subtract the data in the smaller workbook from the larger one. Any ideas please?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to take a list of names & addresses from web site into Excel | Excel Discussion (Misc queries) | |||
| excel list of names, addresses and email to address book/contact list??? | Excel Discussion (Misc queries) | |||
| Remove bad addresses | Excel Discussion (Misc queries) | |||
| How to download my list of e-mail addresses to excel | Excel Discussion (Misc queries) | |||
| How do I put a list of names and e-mail addresses in excel so tha. | Excel Discussion (Misc queries) | |||
Threaded Mode
