A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Random Numbers



 
 
Thread Tools Display Modes
  #41  
Old September 13th, 2005, 06:50 AM
redchequer
external usenet poster
 
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  
Old September 13th, 2005, 07:24 AM
Steved
external usenet poster
 
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  
Old September 14th, 2005, 12:31 AM
redchequer
external usenet poster
 
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  
Old September 14th, 2005, 01:56 AM
Max
external usenet poster
 
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  
Old September 14th, 2005, 04:30 PM
RagDyeR
external usenet poster
 
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
--



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 11:18 AM.


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