1 Reply Latest reply on Jun 5, 2018 2:54 PM by Joe Oppelt

    Ranking Change from Last month's YTD

    John Chun

      Hi all,

       

      I want to know what is the best way to show changes in ranking from current YTD from last month's YTD. Please see below:


      The left is current and right column is from previous month. On the third column, I want to show the change (+/-) in rank from previous month (e.g. gained 3 spots vs lost 3 spots) Do you guys know the best way to go about this? I would think you have to index the two columns..but kind of stuck. Unfortunately, I can't attach the workbook due to private data.

       

      Thanks!