Serial number of a list

[geotso]

In a list like this:

100
200
150
120
250

how to get the serial numbers in the next cells? Like this:

100 1
200 4
150 3
120 2
250 5

thanks in advance

 

[Bernard Liengme]

In the cell next to 100 (which I will assume is in A1) enter =RANK(A1,A:A)
or =RANK(A1,$A$1:$A$100)
Copy down the column by double clicking B1's fill handle
best wishes

 

[WLMPilot]

What determines the serial number in the first place? Is the serial number
based on the sort order of the list?

Les

 

[geotso]

well, with both I get a descend order:

LIST I GET I WISH
100 5 1
200 2 4
150 3 3
120 4 2
250 1 5

Could you please turn it up side down?
Thanks

 

[geotso]

Ooops!

Never mind! I found it:
=RANK(A1,A:A,1)

Thanks again...