How to get specific total as sum of randomly(using randbetween/rand()) generated values?
I always want to get specific value as the sum of randomly generated values
For example I have sheet as shown below.
<tbody>
</tbody>
From the above sheet(table) I want to get specific value as the sum of value in Column B(B1:B10 contains =RANDBETWEEN(5,10))
If I want to get 92 as my sum of randomly generated value the excel should populate the random values in column B which gives sum of 92.
How do I do it?
Could someone help me please!
I always want to get specific value as the sum of randomly generated values
For example I have sheet as shown below.
A | B | |
1 | =RANDBETWEEN(5,10)→ | 5 |
2 | =RANDBETWEEN(5,10)→ | 6 |
3 | =RANDBETWEEN(5,10)→ | 7 |
4 | =RANDBETWEEN(5,10)→ | 6 |
5 | =RANDBETWEEN(5,10)→ | 9 |
6 | =RANDBETWEEN(5,10)→ | 7 |
7 | =RANDBETWEEN(5,10)→ | 10 |
8 | =RANDBETWEEN(5,10)→ | 5 |
9 | =RANDBETWEEN(5,10)→ | 6 |
10 | =RANDBETWEEN(5,10)→ | 9 |
11 | =SUM(B1:B10)→ | 70 |
<tbody>
</tbody>
From the above sheet(table) I want to get specific value as the sum of value in Column B(B1:B10 contains =RANDBETWEEN(5,10))
If I want to get 92 as my sum of randomly generated value the excel should populate the random values in column B which gives sum of 92.
How do I do it?
Could someone help me please!