Formula to change the decimal numbers

[NewbieAU]

Hi everyone. I have a question to ask if it's possible.

I have a set of numbers with decimal points. I have to sort them in ascending order, then remove the "gaps" in the decimal points.

Original	Sorted in ascending order	Modified
1.13​	1.01​	1.01​
1.02​	1.02​	1.02​
1.04​	1.04​	1.03​
1.01​	1.13​	1.04​
2.13​	2.01​	2.01​
2.02​	2.02​	2.02​
2.04​	2.04​	2.03​
2.01​	2.13​	2.04​

For example, in the sorted section, we have a "gap" between 1.02 and 1.04. I need to change the 1.04 to 1.03 so there is no skipping. Similarly, 1.13 then becomes 1.04.

The "main numbers" (ones and tens etc) cannot be changed - only the decimal section. How can I go about doing this?

Thanks in advance.

 

[NewbieAU]

I just realized the above example wasn't great in that in both instances, we have .04 and .13 that becomes .03 and .04 respectively. This may not always be the case

 

[Peter_SSs]

See if this is what you want.

21 10 26.xlsm
	A	B	C
1	Original	Sorted in ascending order	Modified
2	1.13	1.01	1.01
3	1.02	1.02	1.02
4	1.04	1.04	1.03
5	1.01	1.13	1.04
6	2.13	2.01	2.01
7	2.02	2.02	2.02
8	2.04	2.04	2.03
9	2.01	2.13	2.04
Sort & Alter

Cell Formulas
Range	Formula
B2:B9	B2	=SMALL(A$2:A$9,ROWS(B$2:B2))
C2:C9	C2	=INT(B2)+(COUNTIFS(B$2:B2,">="&INT(B2),B$2:B2,"<"&INT(B2)+1)/100)

 

[NewbieAU]

This is absolutely perfect! Thank you for understanding exactly what I was trying to do. I got so confused towards the end while manually changing the numbers. I really appreciate this!

Thank you again!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.