Randomly Generating number in multiple column which sumup to 100

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

Workflow

Macros

Batch Macro

Iterative Macro

Accepted answers

paulfound

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.

randomgenNumbers.yxmd

gnas19_random_number.yxmc

All comments

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

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.

randomgenNumbers.yxmd

gnas19_random_number.yxmc

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167