leftmost number value

[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!

 

[T. Valko]

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.