Thread: How do I return the first non-blank value in a row?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick
 
Posts: n/a
Default 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
...



Reply With QuoteReply With Quote