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.