Decent FREE Random Number generator

Status
Not open for further replies.

CrazyHelloDeli

Platinum Member
Jun 24, 2001
2,854
0
0
Here are the features I would like:

Ability to export to .xls
Generate numbers up to twenty digits
Generate in bulk upwards of 10,000 numbers at a time.
Exclude duplicate numbers
And, if possible, able to specify alphanumeric sequences in front of the random numbers. For instance, TBD<random number>

Thanks and here is a pic for your trouble.

tumblr_lfa4flSyXn1qgo426
 

DesiPower

Lifer
Nov 22, 2008
15,299
740
126
doesnt Excel have a inbuilt Rand function? a simple vb code can do it too. not sure about the 20 digit number though, seems to be awfully LONG, what? its like a gazziligigantialion?

Ability to export to .xls - Excel can do it
Generate numbers up to twenty digits - not sure if anyone can do it.
Generate in bulk upwards of 10,000 numbers at a time. - Excel cal do it (drag and extend to 10k rows)
Exclude duplicate numbers - Excel can do it (Data > Remove Duplicate)
And, if possible, able to specify alphanumeric sequences in front of the random numbers. For instance, TBD<random number> - Excel can do it (combine two columns)
 
Last edited:

DesiPower

Lifer
Nov 22, 2008
15,299
740
126
that's the URL i use to randomly draw winners whenever i have giveaways on my blog.

You dont need to go to a website, just put this code in notepad and save it as whatever.vbs and just run it. You can replace 10000 with you high limit and 1 with lower.
Randomize()
redo = msgbox(Int ((10000 - 1 + 1) * Rnd + 1))
 

gevorg

Diamond Member
Nov 3, 2004
5,070
1
0
doesnt Excel have a inbuilt Rand function? a simple vb code can do it too. not sure about the 20 digit number though, seems to be awfully LONG, what? its like a gazziligigantialion?

It does, but most statisticians do not consider Excel as a good random number generator (YMMV, rand() in Excel might have some usability). The link above to random.org is considered as a better alternative.
 
Status
Not open for further replies.