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

  • Thread starter Thread starter cate
  • Start date Start date
C

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.
 
{=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.
Click to expand...

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.
 
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.
Click to expand...

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. !@#
 
Hello Cate,

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



cate a écrit :
 
Back
Top