"ekkeindoha" wrote:
I would like to auto change the top number to 5 and descending
to the last one to be 2.

You neglected to say how you want the numbers between 5 and 2 to be
distributed.

Perhaps the following is what you have in mind, assumeing the numbers are in
A1:A12 in descending order.

B1: =2+(5-2)*(A1-$A$12)/($A$1-$A$12)

Copy down through B12.


----- original message -----

"ekkeindoha" wrote in message
...
Good day,
I would like to auto change the top number to 5 and descending to the last
one to be 2.
2868 5
1800
1800
1200
624
624
576
576
528
528
480 2
480 2