Excel Random Data Input 2

[JohnWilson]

Is there any way in Excel to insert data i.e. Random Figures instead of randomly hitting keys??

TIA...........

 

[NOPOPNOSTYLE]

You could Use the RAND()syntax that will generate and number between 0 and 1.

More Useful is RANDBETWEEN(y,x)

Y=Lowest number
X=Higher Number

Useful for picking lottery numbers.

Good Luck

Lord Exell

 

[JohnWilson]

Thanx for the reply

When I try the randbetween I get a #Name error.

I have been messing about with the Random number Generation tool but can't get it to display numbers without decimal places i.e. whole numbers between 1 & 100

 

[NOPOPNOSTYLE]

Hi there

Right Copy this into your Cell and it should work. Lets us know if it doesn't

=RANDBETWEEN(1,100)

Lord Exell

 

[JohnWilson]

I got it Thanx

 

[JohnWilson]

Slight problem, When I input data anywhere on the Excel spreadsheet all the data for RANDBETWEEN changes value.

Is this ment to happen??

TIA...........

 

[NOPOPNOSTYLE]

Yes it recalculates a new random number every time the critera for recalculation is meet. You can get around this by going to Tools>Options; select the Calculation Tab, Automatic should be selected, change it to manual, then new random numbers will only appear when you hit the F9 key.

Hope this Helps

Lord Exell

 

[JohnWilson]

Once again Thanx

 

[patriciaanne]

If you need to keep the automatic calculation on for other parts of the spreadsheet consider using Paste Special.
You select and copy the random numbers and do Edit>Paste Special Values... the numbers are then converted to values and won't keep recalculating.