Need a function to return leftmost number in row of columns

  • Thread starter Thread starter Joe Blow
  • Start date Start date
J

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

Frank,

Thanks! works great. Exactly what I needed!

Regards,
Joe
 
Back
Top