Thread: convert numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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