Jimbo 175 Posted September 8, 2005 Share Posted September 8, 2005 I'm running a fantasy football competition and have a have a macro set up so when a button is clicked the league table updates with the latest team total points next to the team managers name. How can I get the league table to indicate if that manager has gone up or down or remained in the same league position ???? Link to comment Share on other sites More sharing options...
Craig 6700 Posted September 8, 2005 Share Posted September 8, 2005 Fingers crossed, the solution you've got works.... Link to comment Share on other sites More sharing options...
Lazarus 0 Posted September 8, 2005 Share Posted September 8, 2005 I'm running a fantasy football competition and have a have a macro set up so when a button is clicked the league table updates with the latest team total points next to the team managers name. How can I get the league table to indicate if that manager has gone up or down or remained in the same league position ???? 30571[/snapback] you mean like an up arrow, a down arrow or a sideways one ? Link to comment Share on other sites More sharing options...
Gemmill 45996 Posted September 9, 2005 Share Posted September 9, 2005 I'm running a fantasy football competition and have a have a macro set up so when a button is clicked the league table updates with the latest team total points next to the team managers name. How can I get the league table to indicate if that manager has gone up or down or remained in the same league position ???? 30571[/snapback] Fuck knows. Link to comment Share on other sites More sharing options...
Rob W 0 Posted September 9, 2005 Share Posted September 9, 2005 The easitest way would be to link the old table positions with the new one and something along the lines of =IF(New posn=Old, 0, (IF New<Old, +, -)) New would be defined as a range Link to comment Share on other sites More sharing options...
Emre 0 Posted September 9, 2005 Share Posted September 9, 2005 (edited) I think it would be something along the lines of what Rob said. Try http://www.contextures.com and click Excel Tips... may find something or try http://www.ozgrid.com/forum/ those guys know what they are talking about. These two sites got me through the spreadsheet module of my AS level IT coursework and I got an A Edited September 9, 2005 by Emre Link to comment Share on other sites More sharing options...
peasepud 59 Posted September 10, 2005 Share Posted September 10, 2005 I think it would be something along the lines of what Rob said. Try http://www.contextures.com and click Excel Tips... may find something or try http://www.ozgrid.com/forum/ those guys know what they are talking about. These two sites got me through the spreadsheet module of my AS level IT coursework and I got an A 30943[/snapback] cheating twat Link to comment Share on other sites More sharing options...
Jimbo 175 Posted September 10, 2005 Author Share Posted September 10, 2005 Cheers for the advice, Craig sorted it for me, cheers dude ! Link to comment Share on other sites More sharing options...
Craig 6700 Posted September 10, 2005 Share Posted September 10, 2005 No worries matey.... I'd just done a solution pretty similar for a project at work.... Only they got charged £256 for it! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now