Forum Discussion
RANK Results Issue
My spreadsheet has a list of club members in one column on the left and calculates each member's scores for the season, in rows horizontally adding their total score to a column on the right. In a c...
My approach is to use XMATCH but first pull unique values and then sort in descending order.
=LET(sorted, SORT(UNIQUE(score), , -1), XMATCH(score, sorted))
Hi Patrick, what do you mean by Pull Unique Values?
Apologies for my lack of understanding, do I need to enter any cell info into the command line, I am guessing not as your example just seems to work based on "score".
Thank you for your help thus far.
Paul
- Thank you Patrick
When I try to extract the scores using the =UNIQUE(score) command I am getting #NAME?
I think my totals are in a table as the header has an ascending descending arrow will this make a difference?
