Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to generate some random numbers for chart demo in Excel?
I would like to know how to generate some quick random numbers in order to
use for demo purposes. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to generate some random numbers for chart demo in Excel?
=RAND() for numbers 0 to 1
=RANDBETWEEN(n,m) for integers; needs Analysis ToolPac Remember the values will keep changing You can always Copy and Paste Special with Values specified if you want to work on a constant set of values best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "helen" wrote in message ... I would like to know how to generate some quick random numbers in order to use for demo purposes. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to generate some random numbers for chart demo in Excel?
=rand()
will return a different number between 0 and 1 when F9 is pressed. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "helen" escreveu: I would like to know how to generate some quick random numbers in order to use for demo purposes. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to generate some random numbers for chart demo in Excel?
Use this formula in a cell and fill down as necessary...
=Rand() * 100 The free "Special Randoms" workbook available here... http://excelusergroup.org/media/ can generate random numbers and text in several unique ways. -- Jim Cone Portland, Oregon USA "helen" wrote in message I would like to know how to generate some quick random numbers in order to use for demo purposes. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to generate some random numbers for chart demo in Excel?
helen,
This will put 50 unique random integers in column A. Right click your sheet tab, view code and paste this in and run it Sub No_Repeats() Dim MyRange As Range Set MyRange = Range("A1:A50") For Each c In MyRange Do c.Value = Int((9999 * Rnd) + 1) Loop Until WorksheetFunction.CountIf(MyRange, c.Value) < 2 Next End Sub Mike "helen" wrote: I would like to know how to generate some quick random numbers in order to use for demo purposes. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to generate some random numbers for chart demo in Excel?
Neat code but why did you suggest making it a worksheet macro rather than a
general one? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Mike H" wrote in message ... helen, This will put 50 unique random integers in column A. Right click your sheet tab, view code and paste this in and run it Sub No_Repeats() Dim MyRange As Range Set MyRange = Range("A1:A50") For Each c In MyRange Do c.Value = Int((9999 * Rnd) + 1) Loop Until WorksheetFunction.CountIf(MyRange, c.Value) < 2 Next End Sub Mike "helen" wrote: I would like to know how to generate some quick random numbers in order to use for demo purposes. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generate random numbers | Excel Discussion (Misc queries) | |||
using excel generate random numbers 1 to 52 without repeating | Excel Worksheet Functions | |||
How do I generate random lottery numbers in Excel? | Excel Worksheet Functions | |||
How do I generate random numbers using dates in excel? | Excel Worksheet Functions | |||
generate random numbers | Excel Worksheet Functions |