Satisfy if condition on Dynamic columns

[vpranitha]

Here is my question.

I am looking for a value "Y" in Columns Y: AW and if Y then return " N " else "Y ". I got it to work in cell

AX2 using formula IF(COUNTIF($Y2:AW2,"Y"),"N","Y").

Having trouble to dynamically update columns when new columns are added after AW . I need column Y (the start column) to be constant but column AW to be dynamic, since columns would be added each month and I want the if condition to work dynamically.

Appreciate assistance with this.

Thank you

 

[Eric W]

Is there some way to identify the last column you want to include? For example a heading? Or is there anything after column AW that could affect the formula? If not, just use ZZ as your last column.

Or you could add 1 column to your formula $Y2:AX2, and whenever you add a column, just add it BEFORE the extra column. Excel with automatically adjust the current formulas to include the new column.