PDA

View Full Version : Generate a list of numbers


jprice1542
04-22-04, 02:56 PM
I am looking for an open source program where I can generate a list of numbers and export them to an excel file.

Example:
generate a list of numbers from 50000 - 59999 and save it to an excel file.


Or a text file can work and I can copy paste them to excell.


Thanks

Nerddette
04-22-04, 07:42 PM
Hi,

I might be stating the obvious here and if I am I apologise...

Excel can easily generate it's own list of numbers, either randomly or sequential between two given boundary values.

Generate Random Number
=RAND()


Generate Random Number between two values
=RANDBETWEEN(50000,59999)
- this may require the installating of Add Ins, Go into Tools, Add-Ins and Select Analysis ToolPak.
If you want to repeat this 10000 times without having to copy/paste then just define a named range, then copy and paste to range. (Just ask me for more info if required).


Generate Sequential List of Numbers
Define a named range (size 10000), type in first number, then second cell has =(firstcell)+1. Copy/Paste formula to named range.


Nerddette