how to calculate change of ranking position

May 16, 2019 at 09:28:29
Specs: Windows 10
Hi guys,
I am new to excel.
So I some data that have rankings for each category from 2018 May to 2019 May. For example, "keyword" ranks 5 in 2018, May and ranks 4 in 2018, June. So the ranking increase by 1. But how can I show the result by telling people it is increasing 1 ranking.


See More: how to calculate change of ranking position

Reply ↓  Report •

#1
May 16, 2019 at 11:33:49
Without a better understanding of your data layout, it is hard for us to give you a specific answer.

The simple, generic answer is to just subtract the 2 values.

Please click on the link at the bottom of this post and read the instructions for posting example data in this forum. Be sure to include Column letters and Row numbers.

Keep in mind that we can't see your worksheet from where we're sitting nor do we know your exact requirements, so the more information you provide, the easier it will be for us to help you.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •
Related Solutions


Ask Question