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

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

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