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

{=MATCH(CELL("col"),C2:H20,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.

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

On Apr 19, 12:23*pm, cate wrote:
{=MATCH(CELL("col"),C2:H20,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.

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

On Apr 19, 1:31*pm, cate wrote:
On Apr 19, 12:23*pm, cate wrote:

{=MATCH(CELL("col"),C2:H20,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.

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

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

Hello Cate,

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



cate a écrit :
On Apr 19, 1:31*pm, cate wrote:
On Apr 19, 12:23*pm, cate wrote:

{=MATCH(CELL("col"),C2:H20,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.

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