Hi everyone, I'm relatively new to Excel and managing to learn lots by reading and watching YouTube clips etc.
I got thinking to an old Fantasy F1 league I used to be in, and the guy used to be able to compute what the most optimal team was (using previous results from races), and I was just wondering if anyone knew what function this might be so I can read into it more?
For context, it was something like you can spend a maximum of $40m, and had to choose 2 drivers, a chassis, an engine, and 1 $1m driver (only loses points).
I've seen solver, but I don't know how you would use that to pick from multiple differentcategories, but have a cap of $40m? I can't imagine it was done manually each race
Sample_Excel_Help.png
Bookmarks