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
vBulletin® v3.6.4, Copyright ©2000-2009, Jelsoft Enterprises Ltd.