Need a book? Engineering books recommendations...
Return to index: [Subject] [Thread] [Date] [Author]
Re: Consecutive Numbering of @RAND Numbers
[Subject Prev][Subject Next][Thread Prev][Thread Next]- To: seaint(--nospam--at)seaint.org
- Subject: Re: Consecutive Numbering of @RAND Numbers
- From: "Michael Valley" <mtv(--nospam--at)skilling.com>
- Date: Fri, 17 Dec 1999 12:58:32 -0700
- Comments: Authenticated sender is <mtv(--nospam--at)mail.skilling.com>
- Priority: normal
The equation in A2 should be: =rank(a1,$a$1:$iv$1) Fill this equation across as many columns as you want. [thus the equation in B2 would be: =rank(b1,$a$1:$iv$1)] This equation looks at the entire first row [because iv is the last possible column] and returns the rank of the item indicated (a1, b1, c1, etc.) ignoring blank items. Note that two identical items in the range of source data would have the same rank. However, if the random number generator is used to produce those numbers, this shouldn't happen. This solution is very simple, efficient, and recalcs automatically. ********** > From: Yank2002(--nospam--at)aol.com > Date: Fri, 17 Dec 1999 15:36:54 EST > Subject: Consecutive Numbering of @RAND Numbers > For all you spreadsheet wizards ....continuing the previous @RAND topic: > > I have the following numbers: (example) > > A1 B1 C1 D1 E1 F1 <-- these are the positions > of cells in the spreadsheet where the numbers shown below are entered > > 0.542 0.217 0.981 0.524 0.237 0.152 and so on > > Below each of these cells I would like to write an equation which would > display which of these numbers is the highest number, the second highest, the > third highest, and so on, of all numbers entered in the spreadsheet. The > answer, of course, must be: > A2 B2 C2 D2 E2 F2 <--- (on line 2 or on any > line below) > 2 5 1 3 4 6 > > The answer must be instantaneous and changing as you enter new @RAND numbers. > > I am looking for the most efficient equation or set of equations. Since there > might be as few numbers as 2 and as many as thousands, the simplest solution > is sought. > > It has to be remembered that every time you press the F9 key, a brand new > situation develops. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Michael Valley E-mail: mtv(--nospam--at)skilling.com Skilling Ward Magnusson Barkshire Inc. Tel:(206)292-1200 1301 Fifth Ave, #3200, Seattle WA 98101-2699 Fax: -1201
- References:
- Consecutive Numbering of @RAND Numbers
- From: Yank2002
- Consecutive Numbering of @RAND Numbers
- Prev by Subject: Consecutive Numbering of @RAND Numbers
- Next by Subject: RE: Consecutive Numbering the @RAND Numbers
- Previous by thread: Consecutive Numbering of @RAND Numbers
- Next by thread: Architect Search
- About this archive
- Messages sorted by: [Subject][Thread][Author][Date]