Thread: Index Match Row Heading?
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default Index Match Row Heading?
"Toppers" wrote...
=INDEX(A1:D1,SUMPRODUCT(--(A2:E90)*COLUMN(A:E))/COUNTIF(A2:E9,"0"))
....

A lot of effort to avoid the array formula

=INDEX(A1:E1,MIN(IF(A2:E90,COLUMN(A1:E1))))


Reply With QuoteReply With Quote