I'm trying to compile a list of the top 4 names (Column A) based on the values of Column Q. The only problem is that there are same values. In Cell Z1, I want to display the top name (Name 1). In Cell Z3, I want to display the 2nd top name (Name 7). In Cell Z5, I want to display the 3rd top name (Name 10). In Cell Z7, I want to display the 4th top name (Name 2).
I thought I figured it out with the MATCH() and LARGE() functions, but because of the same values, it's returning "Name 1" for all of them. I want it to basically move to the 2nd name if the value is the same as the previous one. Can anyone help please!!!??? I've attached a picture as an example below:
worksheet.jpg
A Q
Name 1 99.00
Name 2 96.60
Name 3
Name 4 86.10
Name 5 95.80
Name 6 96.30
Name 7 99.00
Name 8 93.40
Name 9 89.20
Name 10 99.00
Name 11 96.50
Name 12
Name 13 95.50
Thank you so much in advance!!
Bookmarks