4 Replies Latest reply on May 10, 2016 6:16 AM by Thomas Beaulieu

    Help with Rank() function

    Thomas Beaulieu

      Hello - referring to the attached workbook, I am trying to get the Rank() function to show a different value for each item depicted on the table but no matter what I try I cannot get ranks 1, 2 and 3 for item ABC, PQR and XYZ respectively.  I either get what is shown or I get a rank value for each individual line (ranks 1 through 17).  Any help would be much appreciated.

       

      I should point out that I have data for the years 2014 and 2015 hidden from view.  I would like the rank based on the sum of price in descending order for all three years combined even though I am only displaying 2016 data.

       

      Thanks,

      Tom B.