Need bottom 5 ranks with names | Bottom 5 performing players

**mukuljain99** · 11-23-2019, 07:32 AM

I have a name list with scores, I want players by acceding order i.e players that are not doing good, bottom 5-10 players.

attaching excel file for reference.

Thank you in advance

**popipipo** · 11-23-2019, 08:43 AM

With a little change in the rank formula and with index-match-small formula you get it

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**mukuljain99** · 11-24-2019, 02:53 AM

Thanks! works like a charm!

Need bottom 5 ranks with names | Bottom 5 performing players

LinkBack

Thread Tools

Rate This Thread

Display

Need bottom 5 ranks with names | Bottom 5 performing players

Re: Need bottom 5 ranks with names | Bottom 5 performing players

Re: Need bottom 5 ranks with names | Bottom 5 performing players

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Which Is Most Accurate ? Delete Dupe Rows Top to Bottom - or - Bottom to Top ?

[SOLVED] Return Row no. for Lookup from bottom of range, ignoring bottom n no. of rows

Lookup from bottom of range, ignoring bottom n no. of rows

[SOLVED] Bottom Command Button does not take the user to the bottom of the ListBox

[SOLVED] Rows copying from bottom to top. need to copy top to bottom.

Draw bottom border on every rows from top to bottom

dislike jump bottom of column by double-clicking the bottom of cel

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions