Previous in Forum: Need Books for Software Risk Management   Next in Forum: Excel Number Generator
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
2 comments
Rating: Comments: Nested
Anonymous Poster #1

Excel Generate Random Number

04/22/2012 12:41 AM

Hi All

Need your help

I Have number(1~16) in excel from A1 to O1, i need to generate 5 conbination number.

Any help please.

Regard
Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.
SolarEagle
Guru

Join Date: Mar 2007
Location: by the beach in Florida
Posts: 33392
Good Answers: 1817
#1

Re: Excel Generate random number

04/22/2012 1:01 AM

Take your pick....

__________________
 All living things seek to control their own destiny....this is the purpose of life
Reply
Mikerho
Guru
Hobbies - Musician - Engineering Fields - Chemical Engineering - New Member Engineering Fields - Control Engineering - New Member Engineering Fields - Instrumentation Engineering - New Member

Join Date: Jan 2007
Location: Moses Lake, WA, USA, Thulcandra - The Silent Planet (C.S. Lewis)
Posts: 4216
Good Answers: 194
#2

Re: Excel Generate random number

04/22/2012 1:09 AM

There is a RAND (type "=RAND") function that you can use. It gives a random number between 0 and 1. Scale and shift this number to give you the 1 - 16 range. Use the ROUND, ROUNDUP or ROUNDDOWN functions to condition the scaled number.

You will also need to recalculate the spreadsheet to generate the next set of numbers.

__________________
 "Reason is not automatic. Those who deny it cannot be conquered by it. Do not count on them. Leave them alone." - Ayn Rand
Reply
Reply to Forum Thread
Have a Different Question?
2 comments

Previous in Forum: Need Books for Software Risk Management   Next in Forum: Excel Number Generator

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 (88 right now)
Show Members
Advertisement