Random Numbers

R

redchequer

I cannot follow your Random Numbers
Can you eplease explain to me what entrys go in which cells
Can you also let me know if a profile in this forum
 
S

Steved

Hello redchequer from Steved

Put a formula in 6 columns by 10 Rows.
Objective is each cell picks a number between 1 to 40.
Secondly on one line only a individual number can appear only once.

I in this exercise chose to do it from A1:F10.

I've been lucky to have the advice from so many.

That is all it is to it redchequer

Hope this helps.
 
R

redchequer

In this reply from Max to Steved re lotto numbers
I am curious to find out how Pressing F9 will recalculate the numbers.
 
M

Max

redchequer said:
.. I am curious to find out how
Pressing F9 will recalculate the numbers.

Harlan's formula uses RAND() which returns a new random number every time
the worksheet is calculated. Pressing F9 is a short-cut keystroke which
will (from Excel's help) calculate all worksheets in all open workbooks.
 
R

RagDyeR

And of course, there is also:

<Shift> <F9>

Which *only* calculates the active (in focus) sheet.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

redchequer said:
.. I am curious to find out how
Pressing F9 will recalculate the numbers.

Harlan's formula uses RAND() which returns a new random number every time
the worksheet is calculated. Pressing F9 is a short-cut keystroke which
will (from Excel's help) calculate all worksheets in all open workbooks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top