How do I return the first non-blank value in a row?

[Bernie Deitrick]

Array enter (enter using Ctrl-Shift-Enter)

=INDEX(1:1,MIN(IF(1:1<>"",COLUMN(1:1),300)))

Change the 1:1 to the row of interest...

HTH,
Bernie
MS Excel MVP

 

[Domenic]

Here's another way...

=INDEX(A1:Z1,MATCH(TRUE,INDEX(A1:Z1<>"",0),0))

or

=INDEX(1:1,MATCH(TRUE,INDEX(1:1<>"",0),0))

Hope this helps!

BBA <[email protected]> wrote: