Hi!
I am trying to put the highlighted array in order from largest to smallest and have the names match together. However, the part that is tripping me up is I do not want the table to have to appear twice, like it is currently, as it would clearly just be the same data just in different order.
Currently, I am adding player totals together and using HSTACK to create an array of names coinciding with the player totals. Which is what you see highlighted.
I have tried using many varieties of the INDEX, MATCH, LARGE function to get the names in order but to no avail.
Furthermore, I know you can just use the filter function in excel but I was trying to have it be dynamic and do it automatically.
Any help would be appreciated!
This is my first time posting anything anywhere so if you need more information I can try and supply it for you!
Thank you!
Bookmarks