Forum Discussion
rwhaynes954
Jan 24, 2024Copper Contributor
evaluate series of numbers to rank in order
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 th...
- Jan 24, 2024
Lorenzo
Jan 24, 2024Silver Contributor
In case you have duplicate and you want a Dense Rank:
in B2:
=XMATCH(B1:L1, SORT(UNIQUE(B1:L1,TRUE),,,TRUE))
rwhaynes954
Jan 29, 2024Copper Contributor
Thank you. In this particular case, I did not need a Dense Rank, but I now have that for future reference.
- SergeiBaklanJan 29, 2024MVP
- rwhaynes954Jan 29, 2024Copper ContributorSergei,
Thank you.
- LorenzoJan 29, 2024Silver ContributorYou're welcome & Thank you for marking the solution