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


--
redchequer


------------------------------------------------------------------------
redchequer's Profile: http://www.excelforum.com/member.php...o&userid=17396
View this thread: http://www.excelforum.com/showthread...hreadid=466421

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" wrote:


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


--
redchequer


------------------------------------------------------------------------
redchequer's Profile: http://www.excelforum.com/member.php...o&userid=17396
View this thread: http://www.excelforum.com/showthread...hreadid=466421

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

Here's an adaptation of Harlan's solution to the
OP's pick 6 out of 40 case

Define* a name: LottoNumbers
referring to: =ROW(INDIRECT("1:40"))
*via Insert Name Define

Then in A1 enter the formula:
=INT(1+COUNT(LottoNumbers)*RAND())

In B1, enter the array formula:
=LARGE(IF(COUNTIF($A1:A1,LottoNumbers),0,LottoNumb ers),
INT(1+(COUNT(LottoNumbers)-COUNT($A1:A1))*RAND()))

Copy B1 to F1

Select A1:F1, fill down to say, F10

A1:F10 will return 10 sets of 6 numbers (from 1-40)
w/o duplicates in any one set

*Press F9 to recalc* --
Rgds
Max


--
redchequer


------------------------------------------------------------------------
redchequer's Profile: http://www.excelforum.com/member.php...o&userid=17396
View this thread: http://www.excelforum.com/showthread...hreadid=466421

"redchequer" wrote:
.. 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.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

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

"Max" wrote in message
...
"redchequer" wrote:
.. 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.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--