Need a book? Engineering books recommendations...
RE: Consecutive Numbering the @RAND Numbers[Subject Prev][Subject Next][Thread Prev][Thread Next]
- To: seaint(--nospam--at)seaint.org
- Subject: RE: Consecutive Numbering the @RAND Numbers
- From: Yank2002(--nospam--at)aol.com
- Date: Fri, 17 Dec 1999 19:24:08 EST
In a message dated 12/17/99 1:14:14 PM Pacific Standard Time, mtv(--nospam--at)skilling.com writes: > 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. > Hi Michael, Thank you Michael for the solution. Unfortunately I cannot use it because the spreadsheet was created in 1991 when 123 version 2.2 was the standard. For one reason or another I cannot load the spreadsheet into the later version of 123 where function =rank(....) can be applied. And if I do, any further spreadsheet manipulations (such as compiling the spreadsheet) just don't work. 123 ver 2.2 does not have =rank(...) function. I have to find some other way to solve my problem. Any other ideas? Thank you.
- Prev by Subject: Re: Consecutive Numbering of @RAND Numbers
- Next by Subject: Continuous Monorail
- Previous by thread: UBC Section 1806.6 and CBC 1806A.6
- Next by thread: Twist-off bolts with hex heads