tracking movement

[Rookie3510]

Hello everyone, as the name would suggest I'm an Excel Rookie, but I've developed a spreadsheet to do a ranking system for a racing group and while the formula works great to sort results/rankings I wanted to also track the movements of people in the rankings after I hit sort.

So currently have names in column A with final results that are used for ranking in column AF, in column AG is where I'm wanting to add a formula to show a Green arrow UP and number of positions moved up or Red arrow down with number of positions moved down. Is there a way to do this and probably triggered once column AG is highlighted and sorted?

Thanks for any help

Rookie3510

 

[AlphaFrog]

To calculate the rank change, you would need a column to record the rank before sorting.

So before sorting, put the current rank in column AH (put a 1 in AH2 and a 2 in AH3 and autofill down). Then when you sort, a formula in AG can reference the previous rank and calculate the change.

AG2

=AH2 - ROW()+1