A
alidai
Hi,
I am managing a fantasy football league for my friends, i have a list
of all the football players who have been chosen by my friends, their
current teams, values, and points scored so far.
What i want to do is create a "Best Team" which will be the 11 players
with the most points so far. I want this team to automatically update
after i input the latest points for the week.
One problem i have though is that i want the team to be limited to a
certain value (£40m) as it is in the fantasy league.
Here is an example of what the list of players looks like:
GOALKEEPERS
Name Team Value Points
xxxx xxxx xx xx
yyyy yyyy yy yy
zzzz zzzz zz zz
this is then repeated for the DEFENDERS, MIDFIELDERS, and the
FORWARDS.
If anyone has any ideas or tips could they let me know? I can email
anyone a copy of the workbook if they would like to try it?
Email: (e-mail address removed)
James Ryan
I am managing a fantasy football league for my friends, i have a list
of all the football players who have been chosen by my friends, their
current teams, values, and points scored so far.
What i want to do is create a "Best Team" which will be the 11 players
with the most points so far. I want this team to automatically update
after i input the latest points for the week.
One problem i have though is that i want the team to be limited to a
certain value (£40m) as it is in the fantasy league.
Here is an example of what the list of players looks like:
GOALKEEPERS
Name Team Value Points
xxxx xxxx xx xx
yyyy yyyy yy yy
zzzz zzzz zz zz
this is then repeated for the DEFENDERS, MIDFIELDERS, and the
FORWARDS.
If anyone has any ideas or tips could they let me know? I can email
anyone a copy of the workbook if they would like to try it?
Email: (e-mail address removed)
James Ryan