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

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.
 
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.

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.
 
C

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. !@#
 
C

Charabeuh

Hello Cate,

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



cate a écrit :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top