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

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

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


"BBA" wrote in message
...

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

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!

In article ,
BBA wrote: