# Tagged Questions

**1**

vote

**3**answers

10k views

### excel: how to use vba to repeatedly generate random numbers?

I know that in Excel one can use "rand()" function to generate random numbers, and each time pressing F9, all "rand()" results on that sheet will be refreshed.
However, now I need to repeated ...

**0**

votes

**1**answer

5k views

### MS Excel: Unique random number generator within a range

I searched for a similar question but couldn't find one..
I want to generate 10 groups out of numbers ranging from 1-60 (including both), with each and every group containing random and non-repeating ...

**2**

votes

**1**answer

185 views

### Calculating mean of value across random trials/refreshes in Excel?

Say I have a 1000 cells filled with random values and a particular cell that computes a final answer based on those 1000 values. Now I wish to track the value of the answer over 1000 trials i.e., I ...

**1**

vote

**1**answer

1k views

### Math Round multiple cells, generate integers and histogram integer values

I want your help for the following points:
How generate integer values using Data menu > Data Analysis > Random Number Generation
or (if this action can't be done)
how round multiple cells in same ...