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
|