How to sort scores in descending order
-
Hello,
My test gives you the scores for 8 different personality types.
I need the results to be shown in the report in descending order.
For instance:
Type 3 – 8 points
Type 7 – 7 points
Type 2 – 4 points
and so on.
(In this case, type 3 is the highest score. Second comes type 7. Third comes type 2, etc.)Also, there is a possibility that there are two or more types that are the highest scoring one.
For instance:
Type 3 – 8 points
Type 7 – 8 points
Type 2 – 3 points
(In this case, there is a “tie” between type 3 and type 7. So first are type 3 and type 7, then second comes type 2, etc.)What formula should I use to get results shown like this in the report?
Thank you
- The topic ‘How to sort scores in descending order’ is closed to new replies.