Forum Discussion
Rabinos13759
Oct 24, 2023Copper Contributor
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...
Rabinos13759
Oct 24, 2023Copper Contributor
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
Patrick2788
Oct 24, 2023Silver Contributor
- Rabinos13759Oct 24, 2023Copper ContributorThank 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?- Patrick2788Oct 24, 2023Silver ContributorMy sample uses named items such as 'score' and 'student'. You'd have to update the formula to include your ranges.
- Rabinos13759Oct 24, 2023Copper ContributorMany thanks, I am sure that I will get it to work based on your assistance.
Much appreciated