Hi there,

I'm want to use excel to get the best combination of players for my fantasy football team. so I was wondering if it would be possible with these rules:

Player Name Value Points

Goalkeeper
Vorm etc. £6.7 123

Defenders
distin etc £7.2 134

Midfielders
lampard etc. £12 178

Strikers
Rooney etc £14 234


So i will need - 1 goal keeper, 3,4 or 5 defenders, 3,4 or 5midfielders, 1,2 or 3 strikers totalling 11 players in total. I want the maximum possible number of points for a value of £100.

Any help????

Cheers