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]
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