Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Ranking data by value (https://www.askmehelpdesk.com/showthread.php?t=847555)

  • Jul 15, 2020, 07:51 PM
    vks64
    1 Attachment(s)
    Ranking data by value
    I have a excel sheet showing sales and sales_return data. I want a excel formula to rank the data values automatically by high to low values (without sorting) as in model excel sheet enclosed.
    Thanks in advance
    vks
  • Aug 19, 2020, 08:27 AM
    colbtech
    1 Attachment(s)
    In an unused cell (I used D2) type in the following:

    =rank(C2,$c$2:$c£11,0)

    Copy the contents of D2 into D3 to D11

    • All times are GMT -7. The time now is 05:52 PM.