I am tracking values for unique IDs across countries. A unique ID could have multiple data rows in the same country, but with different amounts. I want to have a dropdown where upon selecting the unique ID, you are given the top and second performing country based on the average of that countries amounts per that unique ID. Thank you! Link for example sheet here:

I am tracking values for unique IDs across countries. A unique ID could have multiple data rows in the same country, but with different amounts. I want to have a dropdown where upon selecting the unique ID, you are given the top and second performing country based on the average of that countries amounts per that unique ID. Thank you! Link for example sheet here:

When using the command =INDEX(A3:A8, MATCH(MAX(H3:H8),0)) It only returns the first value in the series, instead of the highest value. I’m not the most familliar with this command yet. This is just for a hypothetical buisiness for an assignment. (https://docs.google.com/spreadsheets/d/1QZe_NstvwTshY2vjiVeSNt2zBtpTnSPhv7dCDmyTYYw/edit#gid=0)