Comparing Lists
 

I am trying to find which items in Column B are missing from A (finding the
reverse would be helpful to; any in column A not in column b)

Column A has data in 389 rows (A2:A389)
Column B has data in 400 rows (B2:B400)

I thought the formula below in Column C will call out the differences

=IF(B2=$A$2:$A$389,"Yes", "") then drag down to 400.

Ideas. Thanks.

Comparing Lists
 

=IF(COUNTIF($A$2:$A$389,B2),"yes","")

copy down


"PAL" wrote:

I am trying to find which items in Column B are missing from A (finding the
reverse would be helpful to; any in column A not in column b)

Column A has data in 389 rows (A2:A389)
Column B has data in 400 rows (B2:B400)

I thought the formula below in Column C will call out the differences

=IF(B2=$A$2:$A$389,"Yes", "") then drag down to 400.

Ideas. Thanks.

Comparing Lists
 

=IF(COUNTIF($A$2:$A$389,B2)=0,"missing","")

--
Gary''s Student - gsnu200798


"PAL" wrote:

I am trying to find which items in Column B are missing from A (finding the
reverse would be helpful to; any in column A not in column b)

Column A has data in 389 rows (A2:A389)
Column B has data in 400 rows (B2:B400)

I thought the formula below in Column C will call out the differences

=IF(B2=$A$2:$A$389,"Yes", "") then drag down to 400.

Ideas. Thanks.