Help with sorting rows of numbers from small to large numbers

[MrsFrankieH]

Hello all,

My operating system is Windows 10.
Samsung Tablet

Could someone please help me with a formula to sort rows of numbers in numerical order? I was told that my Excel had "limitations" and that's why I can't get the results I need. As you can see, I put a couple of sorted rows in cells on the right. The cells on the left are not sorted. I know if anyone can do it, most of you can. Thank you in advance.

MM.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Date	Number 1	Number 2	Number 3	Number 4	Number 5
2	Tuesday, June 7, 2022	41	34	4	53	40			4	34	40	41	53
3	Friday, June 3, 2022	16	11	22	48	59			11	16	22	48	59
4	Tuesday, May 31, 2022	15	63	64	6	41
5	Friday, May 27, 2022	53	40	3	54	14
6	Tuesday, May 24, 2022	3	5	63	6	68
7	Friday, May 20, 2022	40	33	60	69	59
8	Tuesday, May 17, 2022	41	24	21	7	65
9	Friday, May 13, 2022	11	44	65	43	41
10	Tuesday, May 10, 2022	15	19	70	61	20
11	Friday, May 6, 2022	16	52	21	33	70
12	Tuesday, May 3, 2022	57	27	35	19	15
Sheet1

 

[dave3009]

You can try, in I2:

=SORT(B2:F12,,,TRUE)

 

[MrsFrankieH]

You can try, in I2:

=SORT(B2:F12,,,TRUE)

I'll give it a try Dave! Where would I put the formula?

 

[MrsFrankieH]

You can try, in I2:

=SORT(B2:F12,,,TRUE)

Hi Dave! I tried it and got a "spill".

 

[MrsFrankieH]

You can try, in I2:

=SORT(B2:F12,,,TRUE)

Hi Dave, the second time I tried it, it did sort the first line, but not the other lines.

MM.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Date	Number 1	Number 2	Number 3	Number 4	Number 5
2	Tuesday, June 7, 2022	41	34	4	53	40			4	34	40	41	53
3	Friday, June 3, 2022	16	11	22	48	59			22	11	59	16	48
4	Tuesday, May 31, 2022	15	63	64	6	41			64	63	41	15	6
5	Friday, May 27, 2022	53	40	3	54	14			3	40	14	53	54
6	Tuesday, May 24, 2022	3	5	63	6	68			63	5	68	3	6
7	Friday, May 20, 2022	40	33	60	69	59			60	33	59	40	69
8	Tuesday, May 17, 2022	41	24	21	7	65			21	24	65	41	7
9	Friday, May 13, 2022	11	44	65	43	41			65	44	41	11	43
10	Tuesday, May 10, 2022	15	19	70	61	20			70	19	20	15	61
11	Friday, May 6, 2022	16	52	21	33	70			21	52	70	16	33
12	Tuesday, May 3, 2022	57	27	35	19	15			35	27	15	57	19
Sheet1

Cell Formulas
Range	Formula
I2:M1290	I2	=SORT(B2:F1290,,,TRUE)
Dynamic array formulas.

 

[Peter_SSs]

Copy this I2 formula down column I.

22 06 11.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M
1	Number 1	Number 2	Number 3	Number 4	Number 5
2	41	34	4	53	40			4	34	40	41	53
3	16	11	22	48	59			11	16	22	48	59
4	15	63	64	6	41			6	15	41	63	64
5	53	40	3	54	14			3	14	40	53	54
6	3	5	63	6	68			3	5	6	63	68
7	40	33	60	69	59			33	40	59	60	69
8	41	24	21	7	65			7	21	24	41	65
9	11	44	65	43	41			11	41	43	44	65
10	15	19	70	61	20			15	19	20	61	70
11	16	52	21	33	70			16	21	33	52	70
12	57	27	35	19	15			15	19	27	35	57
Sort Rows

Cell Formulas
Range	Formula
I2:M12	I2	=SORT(B2:F2,,,1)
Dynamic array formulas.

 

[Fluff]

Another option ("borrowed" from Eric W) this assumes that the largest value will be 99, but that can be changed.

Fluff.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M
1	Number 1	Number 2	Number 3	Number 4	Number 5
2	41	34	4	53	40			4	34	40	41	53
3	16	11	22	48	59			11	16	22	48	59
4	15	63	64	6	41			6	15	41	63	64
5	53	40	3	54	14			3	14	40	53	54
6	3	5	63	6	68			3	5	6	63	68
7	40	33	60	69	59			33	40	59	60	69
8	41	24	21	7	65			7	21	24	41	65
9	11	44	65	43	41			11	41	43	44	65
10	15	19	70	61	20			15	19	20	61	70
11	16	52	21	33	70			16	21	33	52	70
12	57	27	35	19	15			15	19	27	35	57
Data

Cell Formulas
Range	Formula
I2:M12	I2	=LET(Rng,B2:F12,r,ROWS(Rng),c,COLUMNS(Rng),m,MAX(Rng),MOD(SMALL(Rng+SEQUENCE(r,,100,100),SEQUENCE(r,c)),100))
Dynamic array formulas.

 

[MrsFrankieH]

Copy this I2 formula down column I.

22 06 11.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M
1	Number 1	Number 2	Number 3	Number 4	Number 5
2	41	34	4	53	40			4	34	40	41	53
3	16	11	22	48	59			11	16	22	48	59
4	15	63	64	6	41			6	15	41	63	64
5	53	40	3	54	14			3	14	40	53	54
6	3	5	63	6	68			3	5	6	63	68
7	40	33	60	69	59			33	40	59	60	69
8	41	24	21	7	65			7	21	24	41	65
9	11	44	65	43	41			11	41	43	44	65
10	15	19	70	61	20			15	19	20	61	70
11	16	52	21	33	70			16	21	33	52	70
12	57	27	35	19	15			15	19	27	35	57
Sort Rows

Cell Formulas
Range	Formula
I2:M12	I2	=SORT(B2:F2,,,1)
Dynamic array formulas.

Hi Peter!! Woohoo it worked!!!! Thank you!!!

 

[MrsFrankieH]

Another option ("borrowed" from Eric W) this assumes that the largest value will be 99, but that can be changed.

Fluff.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M
1	Number 1	Number 2	Number 3	Number 4	Number 5
2	41	34	4	53	40			4	34	40	41	53
3	16	11	22	48	59			11	16	22	48	59
4	15	63	64	6	41			6	15	41	63	64
5	53	40	3	54	14			3	14	40	53	54
6	3	5	63	6	68			3	5	6	63	68
7	40	33	60	69	59			33	40	59	60	69
8	41	24	21	7	65			7	21	24	41	65
9	11	44	65	43	41			11	41	43	44	65
10	15	19	70	61	20			15	19	20	61	70
11	16	52	21	33	70			16	21	33	52	70
12	57	27	35	19	15			15	19	27	35	57
Data

Cell Formulas
Range	Formula
I2:M12	I2	=LET(Rng,B2:F12,r,ROWS(Rng),c,COLUMNS(Rng),m,MAX(Rng),MOD(SMALL(Rng+SEQUENCE(r,,100,100),SEQUENCE(r,c)),100))
Dynamic array formulas.

Hi Fluff!!! How are you doing? It's good to see you again!! I tried your solution and it worked too!! I wish I could approve two methods that work!! Thank you so much my friend!

 

[MrsFrankieH]

You can try, in I2:

=SORT(B2:F12,,,TRUE)

Thank you for your efforts Dave!! You're the best!!!