Index with multiple instance

[sumonrezadu]

I want to find top 2 performer in cell A17 & A17 in my attached sheet. Column B2:B13 changes everyday, so the name of performer changes accordingly. But today my top 2 performers achieved same but my formula is giving the same name. Is there anyway to find out the other name i.e Ahmmed Shawkat Hossain here instead of Khan Md. Abdul alim again?

[sktneer]

Try this......

In B16, Place the following Array Formula and drag down....As it is an Array Formula, so it needs to be confirmed with Ctrl+Shift+Enter

Please Login or Register  to view this content.

Then in C16, place the below formula and drag down...

Please Login or Register  to view this content.

Remember to confirm the formula in B16 with Ctrl+Shift+Enter.

Hope that helps.

[FDibbins]

Try this non-array approach.

Add a helper column (I used C) and copy this down...
=B2+(COUNTIF($B$2:B2,B2)/1000)

Then to pull the %, use this...
=INDEX($B$2:$B$13,MATCH(LARGE($C$2:$C$13,ROW(A1)),$C$2:$C$13,0))
adjust for the name

[sumonrezadu]

Wow, great, thanks a lot. thank you very much. my prob totally solved

[sktneer]

Glad to help you. Thanks for the feedback.
If you have got the solution, please mark your thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.