RANDBETWEEN PROBLEM

[CarolAn]

I would like a formula to randumly pick numbers between 1 and 45 but once a
number is picked the number won't be picked again. Is that possible?

 

[Niek Otten]

Look here:

http://www.mcgimpsey.com/excel/udfs/randint.html

 

[Ashish Mathur]

Hi,

You can download the random number generator from here -
http://www.ablebits.com/excel-random-generator-assistant-free-addins/.

This allows you to generate unique random numbers.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Otávio Alves Ribeiro]

Hi there.
One possible solution involves the following steps:
1. Select cells A1:A45.
2. Type in the formula =row() and press CTRL + ENTER.
3. Select cells B1:B45.
4. Type in the formula =RAND() and press CTRL + ENTER
5. Select cells A1:B45, press Ctrl C and choose the menu Paste Values Only.
6. With cells A1:B45 selected sort them by column B.
7. Select cells, say, G1:G45.
8. Type in the formula =INDEX(A1:A45,ROW(A1:A45),1) and press CTRL + ENTER.

This will give you fourty-five rows with an integer "randomly" generated
between 1 and 45 without repetition.

Regards,
Otávio