promotion image of download ymail app
Lv 5
Jethro asked in Computers & InternetSoftware · 3 years ago

Complex Excel question - simulating a football season?

I'm building a spreadsheet to simulate all the fixtures in a football season, and I've successfully done it for one iteration. Is there a way I can make it run a large number of times (say 100,000) and print the results of each iteration to give me meaningful results?

Many thanks.

1 Answer

  • 3 years ago
    Favourite answer

    You would have to automate the process using VBA. Depending on the complexity of your simulation, 100,000 iterations would likely take a fair amount of time to run.

    • Commenter avatarLog in to reply to the answers
Still have questions? Get answers by asking now.