Excel 2007 : unique random numbers

**mani01** · 03-24-2010, 05:10 PM

hi, im not very good with excel and need some help asap

i need to generate 3 random numbers between 0 and 9, and the numbers cannot be the same

ive been using the randbetween() function, but im just struggling to get them so they do not show the same numbers

please any help will be much appriciated

and id prefer not to use VB, if it is possible

many thanks

**NBVC** · 03-24-2010, 05:14 PM

I did a quick google...

http://www.cpearson.com/excel/RandomNumbers.aspx

http://www.mrexcel.com/forum/showthread.php?t=83925

http://www.ozgrid.com/VBA/RandomNumbers.htm

**mani01** · 03-24-2010, 05:18 PM

ah ive already scoured the net trying to find a solution to this, ive even been on those websites, and i dnt understand them because they are visual basic codes, which is not what i want...but thanks alot for searching

i was hoping someone knew a formula in which i can use

**NBVC** · 03-24-2010, 05:23 PM

In the second link I provided, there are a couple of entries that are formula based. Read through the entire thread...

**mani01** · 03-24-2010, 05:25 PM

yea i tried some of those codes before and it was no good

**NBVC** · 03-24-2010, 05:33 PM

As you can see by Aladin's formula.. it is not a simple single formula thing...

The UDF is much easier to apply....

But if you follow Aladin's way, substituting as per your needs.. you should get the results desired.

**NBVC** · 03-24-2010, 05:50 PM

See attached for a simplified interpretation of Aladin's formulas...

I am not sure you need column E as he shows... And I altered column C formulas a bit...

Test it.

Note: If you change the number in B2, you get that number of unique randoms...