Col A has 1200 cells, col b has 1600 cells. How do I find cells from col A that are NOT in col B?
W WPAUMAN Mar 6, 2009 #1 Col A has 1200 cells, col b has 1600 cells. How do I find cells from col A that are NOT in col B?
D Dave Peterson Mar 6, 2009 #2 Put this in C1 and drag down 1200 rows (same as column A's length): =isnumber(match(a1,b:b,0)) You'll see True if there's a match and False if there is no match.
Put this in C1 and drag down 1200 rows (same as column A's length): =isnumber(match(a1,b:b,0)) You'll see True if there's a match and False if there is no match.
