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?
- garbo7441Lv 73 years agoFavourite 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.