convert numbers

  • Thread starter Thread starter ekkeindoha
  • Start date Start date
E

ekkeindoha

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
 
Hi,

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

Mike
 
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,""))
 
ekkeindoha said:
I would like to auto change the top number to 5 and descending
to the last one to be 2.
Click to expand...

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 -----
 
Back
Top