Thread
:
How do I return the first non-blank value in a row?
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Domenic
Posts: n/a
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:
Reply With Quote