Football teams formula help

[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

 

[Bob Phillips]

James,

sounds like you need RANK with some other

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

James,

sounds like you need RANK with some other functions?

Do you only want one of certain types (e.g. goalkeeper) or what?

You could send me the s/s if you want.


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)