Previous in Forum: Excel Generate Random Number   Next in Forum: Excel Chart Showing Data from Multiple Sheets
Close

Comments Format:






Change Mode
Close

Subscribe to Discussion:

CR4 allows you to "subscribe" to a discussion
so that you can be notified of new comments to
the discussion via email.

Close

Rating Vote:







Add Vote
3 comments
Rate Comments: Nested
Anonymous Poster #1

Excel Number Generator

04/22/2012 6:40 AM

Hi, All

I need for my project, i have a number in a row 1 to 20, i need randomly select six number for the row 1 to 20 with no repeats, 10 times.
Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.
irelandeng
Power-User

Join Date: Feb 2008
Location: Waterford, Ireland
Posts: 109
#1

Re: excel number generator

04/22/2012 6:55 AM

Look at the latest lottery results.

__________________
 You see things; and you say, 'Why?' But I dream things that never were; and I say 'Why not?' George Bernard Shaw.
Reply
Tornado
Guru
Technical Fields - Technical Writing - New Member Engineering Fields - Piping Design Engineering - New Member

Join Date: May 2009
Location: Richland, WA, USA
Posts: 21017
Good Answers: 795
#2

Re: Excel Number Generator

04/22/2012 12:07 PM

Are you in the same class as the person who asked almost the same question a day or two ago?

__________________
 In vino veritas; in cervisia carmen; in aqua E. coli.
Reply
jack of all trades
Guru
New Zealand - Member - Kiwi Popular Science - Weaponology - New Member Engineering Fields - Power Engineering - New Member Engineering Fields - Electrical Engineering - New Member

Join Date: Sep 2006
Location: Auckland, New Zealand
Posts: 8777
Good Answers: 376
#3

Re: Excel Number Generator

04/22/2012 3:00 PM

You could try an internet search for a random number generator (a 1d20 dice random generator for board games should do the trick), I wouldn't trust any random function generator built into the function set of Excel.

Just how random does it need to be as the randomness varies depending on the number generation method (many seemingly random number generators are in fact not random at all).

What's the random number being used for, school statistics project?

__________________
 jack of all trades
Reply
Reply to Forum Thread
Have a Different Question?
3 comments
Copy to Clipboard

Users who posted comments:

irelandeng (1); jack of all trades (1); Tornado (1)

Previous in Forum: Excel Generate Random Number   Next in Forum: Excel Chart Showing Data from Multiple Sheets

Advertisement

Got Something to Say?
Ask a Question
Start a Discussion

Search this Forum
Software & Programming:
Go

CR4 Sections
Aerospace
BioMech & BioMed
Chemical & Material Science
Civil Engineering
Communications & Electronics
Education and Engineering Careers
Electrical Engineering
General Discussion
Instrumentation
Manufacturing
Mechanical Engineering
New Technologies & Research
Software & Programming
Sustainable Engineering
Transportation

Site Directories
Forum Directory
Blog Directory
User Group Directory
RSS Feeds

CR4 Rules of Conduct
CR4 FAQ
Site Glossary

Who's Online (80 right now)
Show Members
Advertisement