Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
list duplicates
hi,
not sure if this is possible, but i need to de-duplicate a list from another list... I have: List A - a list of all the people i have contacted List B - a list of all the people i have contacted AND several that i have not i want to know if there is an easy way to find people that are on list B, but not on list A... The advanced filters for deduplicating records only give me a complete list B as they do not remove both entries of the duplicate! Help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
list duplicates
In, say, column E:
=IF(COUNTIF(A:A,C2)0,"","Not on list A") Assuming list a is in column A and list b is in column C. "Abbie" wrote: hi, not sure if this is possible, but i need to de-duplicate a list from another list... I have: List A - a list of all the people i have contacted List B - a list of all the people i have contacted AND several that i have not i want to know if there is an easy way to find people that are on list B, but not on list A... The advanced filters for deduplicating records only give me a complete list B as they do not remove both entries of the duplicate! Help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
list duplicates
try this
list A is Col A & list B is in Col B Col C put this formula and drag it down =IF(ISNA(MATCH(B2,$A$2:$A$25,0)),"Not in List A","contacted") On Nov 18, 11:35*pm, Abbie wrote: hi, not sure if this is possible, but i need to de-duplicate a list from another list... I have: List A - a list of all the people i have contacted List B - a list of all the people i have contacted AND several that i have not i want to know if there is an easy way to find people that are on list B, but not on list A... The advanced filters for deduplicating records only give me a complete list B as they do not remove both entries of the duplicate! Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Both Duplicates from a list | Excel Discussion (Misc queries) | |||
Duplicates in a list | Excel Discussion (Misc queries) | |||
Condensing a list with duplicates to a list with non-duplicates | Excel Worksheet Functions | |||
Array Formulas - Unique List from List with Duplicates | Excel Discussion (Misc queries) | |||
How to remove duplicates from a list and copy new list to new colu | Excel Worksheet Functions |