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
|