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