S
susielotus
I have quite a lot of rows that i need the rows to be sorted in ascending order
for example
1 5 14 26 42 45
4 14 28 36 7 39
5 25 6 27 9 37
12 18 14 26 2 36
25 4 5 34 4 14
28 25 43 1 11 15
14 5 42 26 45 1
I need a formula or something that will get me the rows looking like this
1 5 14 26 42 45
4 7 14 28 36 39
5 6 9 25 27 37
2 12 14 18 26 36
4 4 5 14 25 34
1 11 15 25 28 43
1 5 14 26 42 45
I have tried the normal sorting, but it's not working, please help
for example
1 5 14 26 42 45
4 14 28 36 7 39
5 25 6 27 9 37
12 18 14 26 2 36
25 4 5 34 4 14
28 25 43 1 11 15
14 5 42 26 45 1
I need a formula or something that will get me the rows looking like this
1 5 14 26 42 45
4 7 14 28 36 39
5 6 9 25 27 37
2 12 14 18 26 36
4 4 5 14 25 34
1 11 15 25 28 43
1 5 14 26 42 45
I have tried the normal sorting, but it's not working, please help