| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| for and if statement within another for/if statement | Excel Discussion (Misc queries) | |||
| If(If statement? | Excel Worksheet Functions | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Linear Mode
