Comparing columns for no match
 

Col A has 1200 cells, col b has 1600 cells. How do I find cells from col A
that are NOT in col B?

Comparing columns for 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.

WPAUMAN wrote:

Col A has 1200 cells, col b has 1600 cells. How do I find cells from col A
that are NOT in col B?

--

Dave Peterson