Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Net data from a comparison of 2 lists
I need to compare a master list with a smaller list and remove the matches
from the master so that I am left with a single list that reflects only the data that is not in the smaller list. For example: Master a b c d Sublist a d Net list After comparison b c |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Net data from a comparison of 2 lists
Assuming Master list in column A, and Sublist in column B
Create a helper column C C2 =COUNTIF($B$2:$B$3,A2) Adjust your range to suit Copy down as far as needed AutoFilter all the 1, then select the visible range, EditDelete "Clubber" wrote: I need to compare a master list with a smaller list and remove the matches from the master so that I am left with a single list that reflects only the data that is not in the smaller list. For example: Master a b c d Sublist a d Net list After comparison b c |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Net data from a comparison of 2 lists
Thanks, perfect!
"Teethless mama" wrote: Assuming Master list in column A, and Sublist in column B Create a helper column C C2 =COUNTIF($B$2:$B$3,A2) Adjust your range to suit Copy down as far as needed AutoFilter all the 1, then select the visible range, EditDelete "Clubber" wrote: I need to compare a master list with a smaller list and remove the matches from the master so that I am left with a single list that reflects only the data that is not in the smaller list. For example: Master a b c d Sublist a d Net list After comparison b c |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inconsistent Sorting | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |