Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #41   Report Post  
redchequer
 
Posts: n/a
Default


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   Report Post  
Steved
 
Posts: n/a
Default

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   Report Post  
redchequer
 
Posts: n/a
Default


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   Report Post  
Max
 
Posts: n/a
Default

"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   Report Post  
RagDyeR
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
random numbers, how can you utilize it without repeating them RS Excel Discussion (Misc queries) 1 September 9th 05 05:01 AM
random numbers from a data of numbers? MaryEng Excel Worksheet Functions 6 May 31st 05 12:09 PM
Validating random numbers plsauditor Excel Worksheet Functions 2 January 12th 05 12:12 AM
Random Numbers Change? Les Coover Excel Worksheet Functions 2 December 17th 04 03:49 AM


All times are GMT +1. The time now is 03:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"