| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
looking to delete "non-matched" data
I have two lists done in excel.
An older one, List-A, with separate columns for name, street, city, email addresses, company name, etc. and a newer one, List-B, that has just one column of current email addresses that will match some of those in List-A. I know I can copy the data from List-B into List-A and I'll end up with duplicate emails of those I want to keep. How can I delete the ones from List-A that have no match from List-B? I looking for the opposite of getting rid of the duplicates - :) Best wishes - DG |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Similar Problem as "Multiple Matched Lines" | Excel Discussion (Misc queries) | |||
| Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Threaded Mode
