Jan 24 2024 10:10 AM
In Excel 2021, I want to evaluate the numbers in "TOTAL" row (cells B508-L508) and then in the "RANK" row (cells B510-L510) rank the results with a "1" in the "RANK" row under the lowest number in the "TOTAL" row.
Here is an example to illustrate what I am trying to do. Currently, I have to enter the ranking number in the "RANK" row manually.
Survey # | |||||||||||
1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |
2 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 1 |
3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 1 | 2 | 3 |
4 | 11 | 9 | 7 | 5 | 3 | 1 | 10 | 8 | 6 | 4 | 2 |
TOTAL | 18 | 19 | 20 | 21 | 22 | 23 | 35 | 36 | 26 | 27 | 17 |
RANK | 2 | 3 | 4 | 5 | 6 | 7 | 10 | 11 | 8 | 9 | 1 |
Jan 24 2024 10:18 AM
SolutionJan 24 2024 10:23 AM - edited Jan 24 2024 10:25 AM
In case you have duplicate and you want a Dense Rank:
in B2:
=XMATCH(B1:L1, SORT(UNIQUE(B1:L1,TRUE),,,TRUE))
Jan 28 2024 07:42 PM
Jan 28 2024 07:43 PM
Jan 28 2024 10:01 PM
Jan 29 2024 12:08 AM
Jan 24 2024 10:18 AM
Solution