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

--
geotso
---- ---- --- -- - -
Please, remove hyphens to contact me
---- ---- --- -- - -

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"geotso" wrote in message
...
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

--
geotso
---- ---- --- -- - -
Please, remove hyphens to contact me
---- ---- --- -- - -

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

"Bernard Liengme" wrote in message
...

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"geotso" wrote in message
...
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

--
geotso
---- ---- --- -- - -
Please, remove hyphens to contact me
---- ---- --- -- - -

Ooops!

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

Thanks again...

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

Les

"geotso" wrote:

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

--
geotso
---- ---- --- -- - -
Please, remove hyphens to contact me
---- ---- --- -- - -