Forum Discussion
Formula help return header from max value
Hi I would like to return the header from the highest value. In the example below with the right formula in sheet 1, cell b4 this would return Cherries.
As variant
=INDEX(headers, SUMPRODUCT( ( (group1=MAX(group1, group2))+(group2=MAX(group1, group2)) )*( COLUMN(group1) - COLUMN(startCell) + 1 ) ) )for