2000 random numbers from 40000+ numbers

[Ben H]

Hi

Please can you help me generate 2,000 random numbers from 40,000 random numbers.

Thanks

Ben Howard

 

[Deepak]

Check the native formula

RANDBETWEEN

http://www.techonthenet.com/excel/formulas/randbetween.php


Or lets us know if still the goal is far away!!!

 

[Ben H]

Hi

Its become more complex since posting now i need to randomly select employee departments and employee numbers from the list.

Its now ...

- 5,0000 random numbers from the list of 40,000 numbers
- An equal selection of department names to be included in the group.

Thanks
Ben Howard

 

[Deepak]

Hi Ben H,

Can we have the sample file with expected result.