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
|