Home |
Search |
Today's Posts |
#1
|
|||
|
|||
compare two columns and remove duplicates
I have a list of phone numbers from the do not cal list and a number from
another list. I want to compare the two lists and look for dupes to I know who I can call. I would like the duplicates from the two lists to be identified and the other numbers not on the do not call list to be accessable in order to call. |
#2
|
|||
|
|||
Take a look at
http://cpearson.com/excel/duplicat.htm In article , Moni39 wrote: I have a list of phone numbers from the do not cal list and a number from another list. I want to compare the two lists and look for dupes to I know who I can call. I would like the duplicates from the two lists to be identified and the other numbers not on the do not call list to be accessable in order to call. |
#3
|
|||
|
|||
You would could use VLOOUP the check the do not call list
and place an "X" if found there. Then you can use AutoFilter to filter out "X" rows. VLOOKUP http://www.mvps.org/dmcritchie/excel/vlookup.htm AutoFilter basics (Data, Autofilter) at contextures.com http://www.contextures.com/xlautofilter01.html If this is the National Do Not Call List, it will not scale very well with Excel, you would need a database. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Moni39" wrote in message ... I have a list of phone numbers from the do not cal list and a number from another list. I want to compare the two lists and look for dupes to I know who I can call. I would like the duplicates from the two lists to be identified and the other numbers not on the do not call list to be accessable in order to call. |
#4
|
|||
|
|||
COUNTIF suggested by John via Chip Pearson's site is better
for finding duplicates than VLOOKUP, but use of AutoFilter will get you the second part -- a list of uninformed people who didn't get on the do not call list. Wonder how misspelling of VLOOKUP got through my spelling check anyway. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I modify an existing worksheet to remove columns & contents | Excel Discussion (Misc queries) | |||
print excel columns on less pages | Excel Discussion (Misc queries) | |||
remove spaces in text in excel | Excel Discussion (Misc queries) | |||
Remove dup entries in 2 columns 70,000+ | Excel Discussion (Misc queries) | |||
Removing unused or blank rows and columns | Excel Discussion (Misc queries) |