Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kelly
 
Posts: n/a
Default If I create a random list in Excel, does it repeat numbers?


  #2   Report Post  
Harald Staff
 
Posts: n/a
Default

Yes.
But not too often.
Sometimes never.

HTH. Best wishes Harald


  #3   Report Post  
RagDyer
 
Posts: n/a
Default

True random means just that ... *ANY* number can come up, and sometimes its
a duplicate of what came up before.

However, you can create a specific set of numbers, and then display them in
random *order*.
That eliminates the possibility of duplicates.

If you're interested in such a procedure, post back with some particulars
.... BUT use the body of the message, not just the subjet line.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Kelly" wrote in message
...

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
How do you create a random number generator in Excel? gmrobillard Excel Worksheet Functions 5 March 23rd 05 09:10 AM
how do i create a find function for an excel drop list? RC Excel Discussion (Misc queries) 3 March 18th 05 03:09 PM
i need to create an invioce in EXCEL and then send it into a WORD. cassie Excel Discussion (Misc queries) 1 March 12th 05 07:49 PM
create a drop down list with the source from a different workbook Sampath Excel Discussion (Misc queries) 2 January 8th 05 07:57 PM
How do you create a drop down list? Aviator Excel Discussion (Misc queries) 2 December 28th 04 03:07 PM


All times are GMT +1. The time now is 02:00 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"