View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson
 
Posts: n/a
Default Array Formula Using Max Match Logic

Hi JR573PUTT,
another formula is

=INDIRECT(ADDRESS(1,MATCH(MAX(C2:G2),C2:G2,FALSE)+ COLUMN()))

and I think Bernie's formula should be

=INDEX($C$1:$G$1,MATCH(MAX(C2:G2),C2:G2,FALSE))

Bernie's is better since it involves fewer function calls

Ken Johnson