Need a function to return leftmost number in row of columns

[Joe Blow]

Hi,

I am in need of a function to return the leftmost number in a row of X
columns. The cells either have a number or a dash "-". The numbers and
the dashes can be mixed in the row, but I want the leftmost number
returned.
example
- - - - - 1 3 - 2 - - - 1 1
in this case the function would return the 1 next to the 3

Any help would be awesome.

Thanks,
Joe

 

[Frank Kabel]

Hi Joe
you may try the following array entered formula (CTRL+SHIFT+ENTER) for
row 1:
=INDEX(A1:H1,MATCH(TRUE,ISNUMBER(A1:H1),0))

 

[Joe Blow]

Hi Joe
you may try the following array entered formula (CTRL+SHIFT+ENTER) for
row 1:
=INDEX(A1:H1,MATCH(TRUE,ISNUMBER(A1:H1),0))

Frank,

Thanks! works great. Exactly what I needed!

Regards,
Joe