ExcelBanter - If Statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If Statement (https://www.excelbanter.com/excel-discussion-misc-queries/135941-if-statement.html)

Troyer

If Statement

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?

If Statement

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

your equation was only evaluating A1

"Troyer" wrote:

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?

Toppers

If Statement

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

Copy down in your helper colmn

"Troyer" wrote:

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?

All times are GMT +1. The time now is 05:40 AM.