Working League File - Would Like to Add Trend Arrows

The Shadowman

New Member
Joined
May 5, 2021
Messages
34
Office Version
  1. 2019
Platform
  1. Windows
With the help of Jasonb I have created a 14 team league that works very well and the top team moves to the top and so on. However, I would like to enhance it with trend arrows. I am not too experienced with Excel so it would need to be explained in fairly layman terms. I understand that I need current and previous data. I have tried using IF formulas, but the problem I have is, while I can create an "up and down" column I cant get the variance data to associate with the team names as they move up and down.

If anybody could point me in the right direction I would be very grateful.

Thanks in advance

Robert
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Forum statistics

Threads
1,216,573
Messages
6,131,490
Members
449,653
Latest member
aurelius33

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top