Forum Discussion
Randomized Array and sum of each row has to equal 0.83
I need to make a randomized array with 75 rows and four columns, and the randomized values should be decimals. I am able to achieve that with the formula RANDARRAY(75, 4, 0, 0.83). The issue is I nee...
I'd use helper columns (which you can hide if desired).
Let's say you want the data in B2:E76.
In I2:L76, enter the formula =RAND().
In B2, enter the formula =I2/SUM($I2:$L2)*0.83
Fill to the right to E2, then down to row 76.
You can use other columns as helper columns, of course.