Finding The First Column with a Value

[masouder]

I want to find the first column in a range that contains a value. I can find the last column that has a value with the following array formula, where the values are in cells T1:Z1:

{=MAX(COLUMN(T1:Z1)*(T1:Z1<>""))}

I would think that the following would work but it always returns 0:

{=MIN(COLUMN(T1:Z1)*(T1:Z1<>""))}

Why does this formula not work, and how can I find the first column with a value?

 

[Rick Rothstein]

I want to find the first column in a range that contains a value.

Give this array-entered** formula a try...

=MIN(IF(T1:Z1="","",COLUMN(T1:Z1)))

**Commit this formula using CTRL+SHIFT+ENTER and not just Enter by itself

 

[masouder]

Rick, perfect. Thank you.