Prev: Unable to use the back/forward buttons in the OPEN menu
Next: alter column ref
From: sandy on 26 Apr 2010 21:19
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!
From: T. Valko on 26 Apr 2010 21:53
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.

--
Biff
Microsoft Excel MVP


"sandy" <sandy(a)discussions.microsoft.com> wrote in message
news:B055531C-451A-4E9C-AF2E-081869306024(a)microsoft.com...
> 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!


 | 
Pages: 1
Prev: Unable to use the back/forward buttons in the OPEN menu
Next: alter column ref