convert numbers
 

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

convert numbers
 

Hi,

What is the logic for the converssion? Why does 2868 become 5 and 480 become
2?

Mike

"ekkeindoha" wrote:

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

convert numbers
 

With data in cell A1:A12, try the below in cell B1 and copy down as required

=IF(COUNTIF($A$1:$A$12,""&A1)=0,5,IF(COUNTIF($A$1 :$A$12,"<"&A1)=0,2,""))

--
Jacob


"ekkeindoha" wrote:

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

convert numbers
 

"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