leftmost number value

  • Thread starter Thread starter sandy
  • Start date Start date
S

sandy

Hi!
how can i make this formula to return the leftmost number only?

this is an array formula
=INDEX(A6:AA6,,MIN(IF(A6:AA6<>"",COLUMN(A6:AA6))))

Thanks!
 
Try this array formula** :

=INDEX(A6:AA6,MATCH(TRUE,ISNUMBER(A6:AA6),0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.
 
Back
Top