Adding Movement arrows to Excel leaderboard

[Brett.w]

Hi all
I have created an excel leader board (thanks to the people here!) that i will update each month. As you will see I have the input table on the left and the leaderboard on the right. What i am looking to achieve is that in column J appears an arrow (up, down & no movement) based on column H movement from the previous month.

Your help is appreciated

Thank you

[FDibbins]

so, in your example, you want an up arrow in the 2nd table, next to team 7 because they improved their position, and a down arrow next to team 4 because they did worse?

[Brett.w]

Apologies for the less than stella description (I am struggling with this one!)

The second table shows the leaderboard, that the relevant teams will see. The first table is just my input section.
So if I change the numbers in the first section the second table will re alocate the team based on ranking.

I would like (if possible!) an arrow up if they have improved on the leaderboard from previous position, arrow down if they have moved down etc I have attaced and example.

[npamcpp]

That can be done with conditional formatting. You would have to provide the numbers for the previous rank, though, so it can be compared.

I've added some (fictional) numbers for previous into the cells and used iconsets for conditional formatting, showing only the icons.

[Brett.w]

Thank you for this. Would there be a formula I could use in column J(Previous) so it would automaticly change with each posistion shift?

[npamcpp]

You can link the cells in column J to wherever the cells are that have the values to the previous rank. But these previous ranks must be present in the file somewhere.

[FDibbins]

Brett, I thought i uploaded this file to you, seems i didnt. see if this will help you?

[npamcpp]

Fdibbins, I think the two tables show the same data, just one is sorted by team name, the other is ranked by the YTD performance. The data for the previous month is not shown. So your formula would work, but it's only reporting on the difference between alpha sort and ranked sort in this case.

And if the data for the previous month is present, then no formula is required, as demonstrated with conditional formatting approach above.

[micope21]

Hi

Try this attachment

Cheers

[FDibbins]

npamcpp, the formulae you refer to where already there from the OP, i just added CF

[Brett.w]

Hi

Try this attachment

Cheers

This is real close apart from if the the team does not move on the leaderboard from previous month (i.e. they stay in the same position as before) they need a side arrow, were as at the moment they only way they get this arrow is if they achieve the same % as the previous month.

The arrows need to show the movement on the leaderboard if possible.

Thank you all for your help so far!

Brett

[micope21]

Ok Brett

have a look at this one

[npamcpp]

Brett, where is the data for the previous month's position? You can use the conditional formatting with the icon sets, as in my example above. It automatically enters the yellow side arrow for no movement. All these formulas and special fonts are not required.