Randomly Generating number in multiple column which sumup to 100

[gauravnegi2]

I want to generate multiple columns according to my input and want the data to be filled randomly and when i sum up the columns the sum should be 100.

for example:- i want to generate 8 columns from column no 1 to column no 8  and there is data in each column and when i sum up the columns the totals comes up with 100.

1	2	3	4	5	6	7	8	Check
13	12	11	13	10	14	17	10	100
12	11	12	14	12	16	13	10	100
10	17	18	10	11	12	18	4	100

Thanks in advance

[echuong1]

Do you have a threshold for upper and lower limits of the numbers being generated?

[vizAlter]

@gauravnegi2 — You may want to follow this post (Link) which is quite similar to your ask.

[gauravnegi2]

@echuong1  thanks for the reply.

Yes the lower limit i have is 5 and the upper limit is 17

[atcodedog05]

Hi @paulfound 

Would you like to give a try at it.

Since you were able to solve the previous scenario.

Cheers and Happy Analyzing : )

[paulfound · Accepted solution]

Thanks @atcodedog05 Another distraction for a Friday afternoon! lol

Hi @gauravnegi2 

I used the answer to this question i came up with How-do-I-generate-10-unique-random-numbers-between-1-and-100 

I turned the workflow into a macro and cross tab'd the table to show as you wanted.

2 things, there is no upper and lower limit feature and the numbers that it produces are unique rather than truly random.

let me know what you think.

[atcodedog05]

Hi @paulfound ,

What can i say, you did an amazing job on the previous challenge.

It was really inspiring and a great learning.

Had to pulled you out.

[gauravnegi2]

Thank you @paulfound i saw you solution in Gnans post. You are too good with your logic's thank you again.