Forum Discussion
Sgeffert22
Oct 28, 2022Copper Contributor
RandArray
I'm trying to make the total of my RandArray set equal a pre-determined total. Is there a way that this can even be done?
10 Replies
Sort By
- payablesmedwayllccomCopper ContributorHi I am unable to find my worksheet data since yesterday I was working on that
This question has nothing to do with this discussion. Please start a new discussion and ask your question there.
Let's say you want an array of 20 elements in a column with sum 500.
=LET(a, RANDARRAY(20), s, SUM(a), a/s*500)
Of course, you can use cell references instead of the fixed values 20 and 500.
- Sgeffert22Copper Contributor
What exactly do you want to do?