How to sort data?

[minhphuong_humg]

Hello, everybody.
I have a file data excel. Please view file attach. I want sort sample?
Please, help me.
Thank you very much.
Capture.PNG
sort2.xlsx

[protonLeah]

You can use a helper column, say B. Then put:

Please Login or Register  to view this content.

and copy down. Then sort columns A & B on B
Hide column B

[minhphuong_humg]

You can use a helper column, say B. Then put:

Please Login or Register  to view this content.

and copy down. Then sort columns A & B on B
Hide column B

Thanks ProtonLeah,
but a few cases it is not longer accurate.
e.x. (Please, view file)
special.xlsx
Thank you very much!

[protonLeah]

O.k., try:

Please Login or Register  to view this content.

[bebo021999]

@minhphuong.humg
Xin chào bạn.
@protonLeah,
Yours seems to treat 7.10 as 7.1, while OP request:
7.1
7.2
...
7.9
7.10
...

I am trying to get my solution for this.

[minhphuong_humg]

O.k., try:

Please Login or Register  to view this content.

Thank ProtonLeah,
Seem you don't test on my data.
If you do, the error becomes more and more serious!
(e.x: '7.10 ----> 71 (in fact 710).
Please, help me.
Thank you very much.

[minhphuong_humg]

@bebo021999:
Rất vui được làm quen với bạn. Tìm thấy bạn giữa biển người, ắt hẳn có duyên!

[bebo021999]

Assuming your data from A1:A19
In F1:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Drag down
This function ROWS($1:1) to returns integer starting from 1. Error may occur from this if your actual data did not start from row 1. Try to adjust it to ROWS($1:1) in the first row formula.

[minhphuong_humg]

Assuming your data from A1:A19
In F1:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Drag down
This function ROWS($1:1) to returns integer starting from 1. Error may occur from this if your actual data did not start from row 1. Try to adjust it to ROWS($1:1) in the first row formula.

Thank bebo021999,
Can you test my "special" file?
(file attach).
special.xlsx
Thank you.

[bebo021999]

"Monster Special formula" for "special file"

[minhphuong_humg]

"Monster Special formula" for "special file"

Thank bebo021999,
When I applied to my data, I found it not true anymore. I want to sort out the integer part and the odd numbers. E.x:
1
2
1.1
1.2
1.1.1
1.1.2
.....
special-2.xlsx
Thank you very much.