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
|