Football Predictions League

Hello,
first time poster!

I am currently creating a Football Predictions League.
I have created an IF function to capture the points as per everyone's predictions and subsequent totals.

I now want to show them in a League format. If one total is greater then they move up the table and down if theirs is lesser, exactly like a Football League works.
Hope you understand my problem

Craig

Originally Posted by keawyed

Hello,
first time poster!

I am currently creating a Football Predictions League.
I have created an IF function to capture the points as per everyone's predictions and subsequent totals.

I now want to show them in a League format. If one total is greater then they move up the table and down if theirs is lesser, exactly like a Football League works.
Hope you understand my problem

Craig

Isn't DATA SORT working?

HTH

You could have a table which would sort automatically using VBA but, personally I prefer a formula based approach.

The attached example has an input area, where your "players" are listed in alphabetical order. You may have a formula to calculate each player's score based on other inputs (I've used a Rand formula to generate a random score, press F9 to generate new random scores)

Table will sort automatically with highest score at the top, when there are ties the higher is the first one in your input table (so, alphabetical because input table is alphabetical) but you could use some other criteria to split ties.

The idea, usually, is that the input is on one sheet perhaps or hidden, while the table remains in view....