Need a book? Engineering books recommendations...

# Re: Consecutive Numbering of @RAND Numbers

• 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

```