The Shadowman
New Member
- Joined
- May 5, 2021
- Messages
- 34
- Office Version
- 2019
- Platform
- Windows
Firstly, let me explain that I am a novice when it come to Excel 2019. Can somebody please tell me if the following is possible. I have asked before, but got no response, due, I think to my poor explanation of the problem.
I have two columns CY and DG both comprising 15 rows. CY is a list of names that move up and down automatically as scores are placed in Column DG. Column DG gets its information from this formula =RANK(LARGE($BD$26:$BD$40,ROWS(CY$26:CY26)),$BD$26:$BD$40). What I want to do is, in a new column, place "up and down " arrows that show the movement of the league ie as CY names move up or down. I have tried IF formulas, they get the arrows in place, but they do not move with the corresponding name, they just stay still. If you can help me achieve this goal I would be very grateful.
Thanks in advance
Robert
I have two columns CY and DG both comprising 15 rows. CY is a list of names that move up and down automatically as scores are placed in Column DG. Column DG gets its information from this formula =RANK(LARGE($BD$26:$BD$40,ROWS(CY$26:CY26)),$BD$26:$BD$40). What I want to do is, in a new column, place "up and down " arrows that show the movement of the league ie as CY names move up or down. I have tried IF formulas, they get the arrows in place, but they do not move with the corresponding name, they just stay still. If you can help me achieve this goal I would be very grateful.
Thanks in advance
Robert