Excel: Generate Random Numbers That Add Up to a Fixed Sum / Value Eg. Add up to 100.

No video

Excel: Generate Random Numbers That Add Up to a Fixed Sum / Value Eg. Add up to 100.

Рет қаралды 21,904

Жыл бұрын

In this Microsoft Excel video tutorial I explain how to create a series of random numbers that sum up to a specific value. For example 10 random numbers that sum up to 100.
#exceltutorial #exceltips

Пікірлер: 17

@mahdihajiamiri6888 10 ай бұрын

You save my life I really appreciate this video.

@lanhtrungkien886 2 ай бұрын

Thank you for your work!!! It have solved my problem

@jerrymiles7804 Жыл бұрын

Outstanding dear Mr. Chester! Best regards from Limón, Costa Rica!

@davidsyes5970 Жыл бұрын

It could be useful for anyone prototyping headcount for shifts that have to cover for anticipated crowd sizes. (When I do randomizations like that, I also ad control ranges to enable rapid up/downsizing of test values.) Or, suppose you want to randomize sales based on weather, temp, a given holiday, popularity of events, and by ice cream flavor. Or, suppose you want to simulate depletion of inventory. You could randomize numbers of customer purchases, unit counts, dollar amounts, taxes, and more, all to test viability of a biz model in mind for given prices, sizes, and lease durations of real estate. So, you could potentially wow a lender by showing you've got a well-defined randomized model of break even points. If you deeply build the model, it might make some bankers shut up and lend the money. (In my case, in 2002, when I randomized numbers in a biz model for a coffee shop plan, 2 bankers tried to avoid returning my biz plan (paper version, but, on my laptop, I showed the digital version. It was in Lotus 1-2-3), but I got back my copies since they refused to fund me because I refused to let them have first place on my home mortgage, which was at 5.95 APR (I'm a veteran), and commercial rates were over 7 to 8.5 %.)

@sudhirgouti5431 28 күн бұрын

Thanks

@Lokeshgowda2023 5 ай бұрын

Superb 🎉🎉🎉

@nanabeezil3617 Ай бұрын

how many lines of 4 numbers sum up to 50,please i need the answer

@mymatemartin Жыл бұрын

That's pretty clever but how would it be used in business??

@edikind3347 11 күн бұрын

But what if I only want integers?

@deanmartin6222 4 ай бұрын

How about if the adjusted cells should be in a specified ranged values?

@andy6076 8 ай бұрын

What can I do if I need to find numbers that APPROXIMATELY hit a value. Not exactly

@bernardchrillyn6003 2 ай бұрын

What if I don't want decimals

@V-for-Vendetta01 7 ай бұрын

Cheers!

@10degreerule 8 ай бұрын

I've sent you a message on messenger but no reply I'm hoping to get a reply here thank you in advance. I have 28 golfers in a group and we play every Monday how can I arrange so that each individual player will not play twice during the seven weeks. I was wondering if there was a formula pertaining to this project thanks