Sorting a List

[Tom G]

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]

In B1:
=rank(a1,$a$1:$a$6)
and copy down to B6

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

 

[Tom G]

In B1:
=rank(a1,$a$1:$a$6)
and copy down to B6

Thank you, that worked perfectly.

Tom