Hi,
In column A I have a list of dollar values.
$40
$-30
$10
$0
$0
$120
What I would like to do is in column B put a ranking 1through whatever
corresponding to their dollar value so it would look like this:
$40 2
$-30 6
$10 3
$0 4
$0 4
$120 1
I hope I explained it well. In other words, in column B, they are
sorted according to rank right where they stand. $120 is number 1.
$-30 is number 6, etc.
Thanks,
Tom
Dave Peterson - 25 Nov 2006 04:06 GMT
In B1:
=rank(a1,$a$1:$a$6)
and copy down to B6
> Hi,
>
[quoted text clipped - 24 lines]
>
> Tom

Signature
Dave Peterson
Tom G - 25 Nov 2006 08:44 GMT
>In B1:
>=rank(a1,$a$1:$a$6)
[quoted text clipped - 28 lines]
>>
>> Tom
Thank you, that worked perfectly.
Tom