Thread: cell address for first value to appear in a range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave F[_2_] Dave F[_2_] is offline
external usenet poster
  
Posts: 187
Default cell address for first value to appear in a range
Given the range H5:S5, how can I have Excel return the cell address of
the first value that appears in that range.

=MATCH(1,--(H5:S50),0) entered as an array formula returns 4; this
value is in cell K5. How can I get that cell address returned?

Thanks.

Dave
Reply With QuoteReply With Quote