Random Numbers

[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

 

[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.

 

[redchequer]

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

 

[Max]

.. 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.

 

[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 !
----------------------------------------------------------------------------
-------------------

.. 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.