Hi All, I am at my wits end and definitely in over my head with what should be a simple task for you. I've learned a lot about excel function in the past few hours, but I just can't seem to make it stick.
I need to compare two columns of team rankings and calculate the change in position in absolute numbers and percentages. Assume these simple values below. The reality is that there will be 10k+ rows and not all values will be present in row b compared to row a (person falls out of ranking completely).
Week 1 Rankings:
1. Joe
2. John
3. Mike
4. Bill
Week 2 Rankings:
1. Joe
2. Mike
3. Bill
4. Steve
I need:
- Percentage Change in Position
- Absolute Change in Position (number of spots)
Any help is greatly appreciated.
Shannon
Bookmarks