Forum Discussion

rwhaynes954's avatar
rwhaynes954
Copper Contributor
Jan 24, 2024

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...
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Jan 24, 2024

    Hi rwhaynes954 

     

     

    in B2 - making sure C2:L2 cells are empty:

    =XMATCH(B1:L1, SORT(B1:L1,,,TRUE))
Lorenzo's avatar
Lorenzo
Silver Contributor

Hi rwhaynes954 

 

 

in B2 - making sure C2:L2 cells are empty:

=XMATCH(B1:L1, SORT(B1:L1,,,TRUE))
rwhaynes954's avatar
rwhaynes954
Copper Contributor
Jan 29, 2024
Thank you! This worked perfectly.

Resources