I suuuure am glad places like this and people like YOU exist!!!
In case the title doesn't give it away, I'm lost as to how to even ask my question so I DON'T have to bother everyone that knows what they're talking about! But, alas, here we are...
I need create a formula (or something...) so I can take a list of items and generate a random list from it based on an assigned percentage of each item. over a given number of cells. I'm going to try to break this out in a way that might actually make sense to someone other than me!
Let say I have a list of animals, Possum, Squirrel, Red Fox, Gray Fox, Raccoon, Coyote, Skunk, and Bobcat. There is a set number of animals that I need to populate a list of XX. In my example, there should be 34, but this number changes frequently. Of those 34 animals, I need 65% to be Possum, 7% to be Fox Squirrel, 2% to be Red Fox, 2% to be Gray Fox, 16% to be Raccoon, 1% to be Coyote, 6% to be Skunk, and 1% to be Bobcat.
How do I create a formula/code that I can populate this list into column D on my attached Mini Sheet?
(Clear as mud, right?!?)
Thank you!
In case the title doesn't give it away, I'm lost as to how to even ask my question so I DON'T have to bother everyone that knows what they're talking about! But, alas, here we are...
I need create a formula (or something...) so I can take a list of items and generate a random list from it based on an assigned percentage of each item. over a given number of cells. I'm going to try to break this out in a way that might actually make sense to someone other than me!
Let say I have a list of animals, Possum, Squirrel, Red Fox, Gray Fox, Raccoon, Coyote, Skunk, and Bobcat. There is a set number of animals that I need to populate a list of XX. In my example, there should be 34, but this number changes frequently. Of those 34 animals, I need 65% to be Possum, 7% to be Fox Squirrel, 2% to be Red Fox, 2% to be Gray Fox, 16% to be Raccoon, 1% to be Coyote, 6% to be Skunk, and 1% to be Bobcat.
How do I create a formula/code that I can populate this list into column D on my attached Mini Sheet?
Report Informatino Generation.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Total Number of Animals | Species | Percentage of Probibility | Results | ||
2 | 34 | Virginia Opossum | 65.00% | |||
3 | Fox Squirrel | 7.00% | ||||
4 | Red Fox | 2.00% | ||||
5 | Gray Fox | 2.00% | ||||
6 | Raccoons | 16.00% | ||||
7 | Coyotes | 1.00% | ||||
8 | Skunks | 6.00% | ||||
9 | Bobcat | 1.00% | ||||
10 | ||||||
11 | ||||||
12 | ||||||
13 | ||||||
14 | ||||||
15 | ||||||
16 | ||||||
17 | ||||||
18 | ||||||
19 | ||||||
20 | ||||||
21 | ||||||
22 | ||||||
23 | ||||||
24 | ||||||
25 | ||||||
26 | ||||||
27 | ||||||
28 | ||||||
29 | ||||||
30 | ||||||
31 | ||||||
32 | ||||||
33 | ||||||
34 | ||||||
35 | ||||||
Sheet2 |
(Clear as mud, right?!?)
Thank you!