Chart - top/bottom values

[Pojzon]

Hello,
I'm trying to make dynamic chart with top/bottom values switched with button. Here is what I have so far:
nGFIHX7.jpg
and Bottom:
42IT9OW.jpg
In column "Rank" I'm using =RANK(B2;$B$2:$B$16;IF($H$2=1;0;1)). Part with IF is for button switch. The rest is just index+match formulas. Everything would be fine and enough for the most part, unless values start repeating. So, I've got following problems:
1. When there are same values, rank formula just assign same number to it, e.g. 420 score is top, it appears twice and rank assigns number 1 to both, skipping number 2 and assigning number 3 to next biggest. This creates problem for index formula to find 2nd position.
2. In order to get a name of top/bottom values, right now my index+match formula is comparing the score with the name. When same values with different names appear, then there would be a problem to find it with this formula.
I'm attaching excel file for anyone who would like to see it.
What I need of this chart is to show top/bottom scores and names, even when values are the same. When there are let's say more than 4 values with same score, just show 3 in order of appearance or something like that. I'm not even sure if that's doable without visual basic?
Anyway, thank you for reading all of this. Any help is greatly appreciated.

[Glenn Kennedy]

Is this close to what you want? yellow shaded areas have been changed.

[Pojzon]

Thank you for help. It's almost what I need, I played a little with that and I can't make it work with string or zeroes in range. Is there any way that I could make function small to exclude zeroes in this case? I just don't want to leave blank cells and when I try to show bottom scores with 0 in range it shows as -5E-10. Also, could you explain to me how does this ROW and 10^10 works?

[Glenn Kennedy]

See formula for lows in J3-J5.

The -ROW($B$2:$B$16)/10^10 bit subtracts a very very small and UNIQUE number from each value. A value of 500 in row 2 would have 2 (the row number) divided by 10 to the power of 10 subtracted fromm it = 499.9999999998 the same value in row 3 would have 3/10^10 subtracted fom it = 499.9999999997. Now all the scores are UNIQUE so the INDEX-MATCH returns the correct value fror the name...

[Pojzon]

Nice, now I get it. Thank you for explaining and for the solution. Works great, thank you again.

[Glenn Kennedy]

You're welcome and thanks for the Rep.