Hi All,

I very much appreciate all the help I have received with these formulae.

I would appreciate further assistance in adapting the following formulae to
Return across a Single
Row Multiple Numeric Labels that share the same Maximum value (duplicate
maximums).


Formula (1) Array Entered - Retrieve Numeric Label for Max Value by Specific
Month
Col "A" (A2:A31) = Numeric Labels
Col "C" - "N" (C1:N1) = Full Date formatted with Custom Month Format "mmm":
Jan - Dec
Col "C" - "N" (C2:N31) = Data Numeric Values

=INDEX(GrowthA'!$A$2:$A$31,MATCH(MAX(INDEX('Growth A'!$C$2:$N$31,0,MATCH(MONTH
($D2),MONTH(GrowthA'!$C$1:$N$1),0))),INDEX('Growth A'!$C$2:$N$31,0,MATCH(MONTH
($D2),MONTH(GrowthA'!$C$1:$N$1),0)),0))

Formula (2) Array Entered - Retrieve Numeric Label for Max Value by Specific
Day & Month
Col "A" (A2:A438) = Full Date formatted with Custom Day Format "dd": 1 - 31

Col "B" (B5:B438) = Full Date formatted with Custom Month Format "mmm": Jan -
Dec
Col "C" - "AO" (C4:AO4) = Numeric Labels
Col "C" - "AO" (C5:AO438) = Data Numeric Values

=INDEX('GrowthB'!$C$4:$AO$4,MATCH(MAX(INDEX('Growt hB'!$C$5:$AO$438,MATCH(1,IF
(DAY('GrowthB'!$A$5:$A$438)=DAY($D6),IF(MONTH('Gro wthB'!$B$5:$B$438)=MONTH(
$D6),1)),0),0)),INDEX('GrowthB'!$C$5:$AO$438,MATCH (1,IF(DAY('GrowthB'!$A$5:$A
$438)=DAY($D6),IF(MONTH('GrowthB'!$B$5:$B$438)=MON TH($D6),1)),0),0),0))


Thanks
Sam

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200702/1