Home |
Search |
Today's Posts |
#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 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
random numbers, how can you utilize it without repeating them | Excel Discussion (Misc queries) | |||
random numbers from a data of numbers? | Excel Worksheet Functions | |||
Validating random numbers | Excel Worksheet Functions | |||
Random Numbers Change? | Excel Worksheet Functions |