Forum Discussion
ddrap14
Oct 23, 2022Copper Contributor
Is there any way to apply random values to cells within Excel?
Hi all,
I have a spreadsheet that simulates sports leagues using an external random number generator. The sheet looks like this, but is much larger in scope.
As a result of this size, I'm wanting to remove the external generator and build in the ability to generate values within Excel. However, using in-cell formulas wouldn't work because I'd have to change every single formula every time I wish to simulate another year, completely defeating the purpose of becoming more efficient.
Is this possible in Excel?
4 Replies
Sort By