Working League File - Would Like to Add Trend Arrows

T

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

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
You must log in or register to reply here.

Similar threads

M
  • Solved
Changing an array formula to a LET
Replies
4
Views
188
Fluff
Fluff
C
  • Solved
Ladder League Workbook, replace one row with another
Replies
2
Views
276
CordingBags
C
A
  • Solved
Comparing two excel files for matching / mismatching rows (long text strings - match() wont work
Replies
4
Views
618
ahaye
A
W
  • Solved
Dynamic Images in League Table
2
Replies
11
Views
586
ExceLoki
ExceLoki
Q
  • Question
Macros help on multiple files to be created from a set of large data
Replies
0
Views
357
questforexcel
Q

Forum statistics

Threads
1,215,869
Messages
6,127,414
Members
449,382
Latest member
DonnaRisso

Share this page

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