If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#41
|
|||
|
|||
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 |
#42
|
|||
|
|||
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 |
#43
|
|||
|
|||
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 |
#44
|
|||
|
|||
"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 -- |
#45
|
|||
|
|||
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 -- |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Random numbers | john liem | Worksheet Functions | 11 | October 11th, 2005 11:06 PM |
GENERATE RANDOM NUMBERS BUT EXCLUDE A NUMBER IN THE SEQUENCE | Tracker | General Discussion | 6 | August 5th, 2005 02:49 AM |
how are random numbers determined | hectorvector | Worksheet Functions | 2 | June 10th, 2005 01:55 PM |
If I create a random list in Excel, does it repeat numbers? | Kelly | Worksheet Functions | 2 | March 30th, 2005 04:05 AM |
Random Number Generator | Rich | Worksheet Functions | 4 | August 17th, 2004 07:19 PM |