Formualu to extract period vbased on values

[Howardc]

I would like a formula to extract the month & year based on various values ranging from the highest value to the 5th highest value-see attached sample


Your assistance in this regard is most appreciated

[Admin]

Hi

In C9,

=INDEX($B$1:$M$4,MAX(IF($B$2:$M$5=B9,ROW($B$2:$B$5 )-ROW($B$2)+1,)),MAX(IF($B$2:$M$5=B9,COLUMN($B$2:$M$ 2)-COLUMN($B$2)+1,)))

Array entered.

[Howardc]

Thanks for the help, much appreciated

It would be appreciated if you can explain how this formula works

[Admin]

Hi Howardc,

Please post the link while posting the same question on differen forums.

Cross Post (http://www.mrexcel.com/forum/excel-questions/670774-determining-highest-value-andmonth.html)

[Howardc]

Will do so in future