Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hello, I'm an intern and a relative new user of Excel. I've used it before,
but only for simple sorting. Here's my problem: I am using Excel '03 to sort e-mail address lists. I have two separate files, one with names, email addresses, and postal addresses, and a "cleaned" list with all non-working e-mail addresses removed. What I want to know is, is there any way to use the second list to clean the first list of all the people whose e-mail addresses no longer work, without manually searching through them one row at a time? I have nearly 10,000 names on one and over 7,000 on the other. Thank you for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to clean up data | Excel Discussion (Misc queries) | |||
Data Clean Up | Excel Discussion (Misc queries) | |||
clean up data | Excel Discussion (Misc queries) | |||
Clean Up Data | Excel Discussion (Misc queries) | |||
Get out clean XML data | Excel Discussion (Misc queries) |