Formula to sort multiple columns in numerical order in excel

[MrsFrankieH]

Book2 (version 1).xlsb
	A	B	C	D	E	F	G	H	I	J	K	L
1		ROW1	ROW2	ROW3	ROW4	ROW5		NUMERICAL ORDER
2	Monday, May 19, 2014	15	37	30	22	31		15	22	30	31	37
3	Sunday, May 18, 2014	4	15	12	3	38
4	Saturday, May 17, 2014	20	11	31	7	36
5	Friday, May 16, 2014	21	33	35	20	8
6	Thursday, May 15, 2014	38	12	2	4	5
7	Wednesday, May 14, 2014	4	27	1	34	36
8	Tuesday, May 13, 2014	7	29	11	39	1
9	Monday, May 12, 2014	15	33	31	12	5
10	Sunday, May 11, 2014	29	33	37	22	32
11	Saturday, May 10, 2014	29	8	20	15	5
12	Friday, May 9, 2014	22	17	4	27	36
13	Thursday, May 8, 2014	31	36	5	7	17
14	Wednesday, May 7, 2014	13	12	9	21	23
15	Tuesday, May 6, 2014	33	15	35	12	32
16	Monday, May 5, 2014	6	19	26	28	15
Sheet2

 

[MrsFrankieH]

My Notebook is Samsung
My operating system is Windows 11

Can I please get a formula to sort columns in numerical order?

Thank you so much in advance.

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1		ROW1	ROW2	ROW3	ROW4	ROW5		NUMERICAL ORDER
2	19/05/2014	15	37	30	22	31		15	22	30	31	37
3	18/05/2014	4	15	12	3	38		3	4	12	15	38
4	17/05/2014	20	11	31	7	36		7	11	20	31	36
5	16/05/2014	21	33	35	20	8		8	20	21	33	35
6	15/05/2014	38	12	2	4	5		2	4	5	12	38
7	14/05/2014	4	27	1	34	36		1	4	27	34	36
8	13/05/2014	7	29	11	39	1		1	7	11	29	39
9	12/05/2014	15	33	31	12	5		5	12	15	31	33
10	11/05/2014	29	33	37	22	32		22	29	32	33	37
11	10/05/2014	29	8	20	15	5		5	8	15	20	29
12	09/05/2014	22	17	4	27	36		4	17	22	27	36
13	08/05/2014	31	36	5	7	17		5	7	17	31	36
14	07/05/2014	13	12	9	21	23		9	12	13	21	23
15	06/05/2014	33	15	35	12	32		12	15	32	33	35
16	05/05/2014	6	19	26	28	15		6	15	19	26	28
Sheet3

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

 

[Snakehips]

@MrsFrankieH try

=SORT(B2:F2,,1,1)

. in H2 and drag down.

 

[MrsFrankieH]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1		ROW1	ROW2	ROW3	ROW4	ROW5		NUMERICAL ORDER
2	19/05/2014	15	37	30	22	31		15	22	30	31	37
3	18/05/2014	4	15	12	3	38		3	4	12	15	38
4	17/05/2014	20	11	31	7	36		7	11	20	31	36
5	16/05/2014	21	33	35	20	8		8	20	21	33	35
6	15/05/2014	38	12	2	4	5		2	4	5	12	38
7	14/05/2014	4	27	1	34	36		1	4	27	34	36
8	13/05/2014	7	29	11	39	1		1	7	11	29	39
9	12/05/2014	15	33	31	12	5		5	12	15	31	33
10	11/05/2014	29	33	37	22	32		22	29	32	33	37
11	10/05/2014	29	8	20	15	5		5	8	15	20	29
12	09/05/2014	22	17	4	27	36		4	17	22	27	36
13	08/05/2014	31	36	5	7	17		5	7	17	31	36
14	07/05/2014	13	12	9	21	23		9	12	13	21	23
15	06/05/2014	33	15	35	12	32		12	15	32	33	35
16	05/05/2014	6	19	26	28	15		6	15	19	26	28
Sheet3

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

Thank you Fluff!! It works!! Have a wonderful weekend!

 

[MrsFrankieH]

@MrsFrankieH try

=SORT(B2:F2,,1,1)

. in H2 and drag down.

Hello Snakehips!! Thank you so much for your help! Your solution works too! I wish I could check your solution but I've already checked Fluff's and it won't allow me to check both. Have a wonderful weekend and again thank you!

 

[Fluff]

Glad we could help & thanks for the feedback.