Sequential numbering of decimals

[NikkiMc204]

Hi can anyone help me with a formula or formula's

In column A I have a list of numbers with either 1 or 2 decimal points like so

A1
1.0
2.2.1
1.1
1.1.1
1.2
1.2.1
2.1
2.1.1
2.2

I just want to simply put them from smallest to largest but I'm just going round in circles, so i give up, i've thrown the towel in and have come to you guys/gals to ask for assistance.

 

[Fluff]

For 365 how about

++Fluff.xlsm
	A	B
1
2	1	1
3	2.2.1	1.1
4	1.1	1.1.1
5	1.1.1	1.2
6	1.2	1.2.1
7	1.2.1	2.1
8	2.1	2.1.1
9	2.1.1	2.2.1
10	2.2	2.2
Main

Cell Formulas
Range	Formula
B2:B10	B2	=LET(r,A2:A10,SORTBY(r,LEFT(r,1),1,MID(r,3,1),1))
Dynamic array formulas.

 

[NikkiMc204]

i get the spill error in the table?

 

[Fluff]

Is it a structured table, or just a range?

 

[NikkiMc204]

I wish i knew. It was converted into a table pressing ctrl+t so there's multiple rows and columns with various headings. The particular title heading for all the decimal numbering is in the column titled "I.D" if that helps.

 

[NikkiMc204]

Ok, thanks for trying to help.

 

[Fluff]

I just realised, that formula can be used, so I deleted my previous post.
Try

++Fluff.xlsm
	A	B
1
2	1	1
3	2.2.1	1.1
4	1.1	1.1.1
5	1.1.1	1.2
6	1.2	1.2.1
7	1.2.1	2.1
8	2.1	2.1.1
9	2.1.1	2.2.1
10	2.2	2.2
Main

Cell Formulas
Range	Formula
B2:B10	B2	=INDEX(LET(r,$A$2:$A$10,SORTBY(r,LEFT(r,1),1,MID(r,3,1),1)),ROWS(B$2:B2))

 

[NikkiMc204]

Oh you are the greatest - seriously, let me buy you a cup of coffee or something.

 

[Fluff]

You're welcome & thanks for the feedback.