Hello Excelers!!

I don't believe the title best explains my problem, but I will attempt to explain it here.

In column A I have a list of the 50 US states, in B I have a list of numbers that corresponds to each state. These numbers will be updated daily some increasing a lot and some not at all. Anyways, I want to create a "top 5 list" that will update depending on which states have the highest counts. Linked to that list will be a simple pie chart that I also want to be "dynamic".

The main issue I run into is the repetition of states that have the same numbers. This all becomes more clear in the sample document. Look in column G for what I've attempted so far.

Any help and suggestions are very welcome!

Multiple Sorted Match Results.xlsx