Issue Pulling Correct Data from Index Function

I am using Large and Small functions to pull a Top 5 and Bottom 5 list from my data. However, if a value from those functions matches another in my original data set (aka, tied for 2nd) my Index Function tied to the value only finds the first time the tied value occurs in the array.
Example:

Index Index Small
Name A 9 0.4%
Name B 0 0%
Name B 0 0%

But it should be
Index Index Small
Name A 9 0.4%
Name B 0 0%
Name C 0 0%

How can I get it to pull all the names with the same data, also accounting for the fact that the data will change (I update every day) and there may not be ties anymore?

Yes, I actually used those before this, but using Index immensely simplifies my reports, plus it automatically updates whenever I add new data whereas pivot tables don't do that. Where I use this for my work things are constantly changing and pivot tables are harder to keep up to date. Plus for some names, there is No Data so if I use a pivot and sort by smallest and to a Bottom 5, it puts those at the bottom instead of the true values that I want to see.