Retrieving Top 8 Values while meeting a criteria (Index / Match Formula)

[Joseph Wee]

Hi All,

Good day to you.

I am currently trying to get the names of the top 8 bowlers based on total score (Column G) for a division "Civ" (Column B) with the "Index/Match" formula but am failing badly.

As you can see in cells, H27:O31, I am currently able to get some of values correctly but am facing some errors.

1) First value in I28 is returning N/A value
2) Cells K28 - M28 is returning N/A value as well
-> this is because it is showing the top values of the other divisions as well which I do not wish to see.

Seeking your kind assistance, please!

Regards,
Joseph

[azumi]

SOmething like this perhaps?

[Joseph Wee]

Hi Azumi,

Thank you so much for your prompt reply!

Not quite, as the top few should include Charles.

My apologies for not including a table to show the correct values.

The order should be as follows;

1) Charles
2) Melissa
3) Victor
4) Wendy
5) Frank
6) Anthony
7) Longkang King

The formula doesnt seem to return the entries after Wendy as well.

[Vikas_Gautam]

Hi Azumi ..
Unfortunately you solution is not providing correct result..

Hi Joseph..
I have tweaked with your sum formula to make them unique.. I don't think it would be a matter of concern..

Please Login or Register  to view this content.

Drag down... as array formula...
check the attached file...

[Vikas_Gautam]

You are always welcome..
and Thanks for reputation point..