If Statement

Troyer · Mar 22, 2007

I have two columns A and C; A has 102 rows C has 88 rows. I want to find the
new values in column A that do not exist in column C. my statement is
=if(A1=C1:C88,"ok","new") It is returning a new each time?

bj · Mar 22, 2007

try instead
=if(countif(C:C,A1)>0,"OK","New)

your equation was only evaluating A1

Toppers · Mar 22, 2007

=IF(COUNTIF($C$1:$C$88,A1)=0,"new","ok")

Copy down in your helper colmn

If Statement

Troyer

bj

Toppers