function - find first number in row > 0, return cell column number

[cate]

{=MATCH(CELL("col"),C2:H2>0,0)}


I'm trying to get the column number of the first cell in a row that
has a value > 0.

I been trying things like above, but, I have been crushed.

Please help. Thank you.

 

[cate]

{=MATCH(CELL("col"),C2:H2>0,0)}

I'm trying to get the column number of the first cell in a row that
has a value > 0.

I been trying things like above, but, I have been crushed.

Please help.  Thank you.

monkey monkey monkey... got it
Gets the column offset and I add it to find another cell.

{=INDIRECT(ADDRESS(1,MATCH(TRUE,(B3:H3)>0,0)+CELL("col")))}

Now to figure out how to ignore cell values which are not proper
numbers.

 

[cate]

monkey monkey monkey... got it  
Gets the column offset and I add it to find another cell.

{=INDIRECT(ADDRESS(1,MATCH(TRUE,(B3:H3)>0,0)+CELL("col")))}

Now to figure out how to ignore cell values which are not proper
numbers.

Nope.... doesn't wok. I get a A2 address but indirect treats it
sometimes like a ref to a ref, other times a ref to a value. !@#

 

[Charabeuh]

Hello Cate,

Perhaps something like this array formula:
=MATCH(1,ISNUMBER(B3:H3)*(B3:H3>0),0) +COLUMN(B3)-1



cate a écrit :