Sort 4 columns using excel 2000

[motilulla]

Hello,

Data are found in the Range A5:P22 I want to Sort 4 columns D, E, F and G data and full range accordingly in the ascending order

I tried to sort as shown below but it sort only 3 columns so far 4th column data remain in the descending order. Like G6 remains 21 & G7 remains 15...G15=42, G16=24, G17=33

*	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1
2
3
4
5	Year	SORTEO	FECHA	n1	n2	n3	n4	n5	*1	*2	EM	Sum Num	n2-n1	n3-n2	n4-n3	n5-n4
6	2004	14	14/05/2004​	1	3	21	32	39	2	6		96​	2	18	11	7
7	2004	44	10/12/2004​	1	3	13	16	43	2	7		76​	2	10	3	27
8	2006	39	29/09/2006​	1	3	6	18	24	5	8		52​	2	3	12	6
9	2007	34	24/08/2007​	1	3	16	42	48	2	3		110​	2	13	26	6
10	2008	52	26/12/2008​	1	2	26	44	50	1	7		123​	1	24	18	6
11	2012	7	24/01/2012​	1	2	6	20	36	8	11		65​	1	4	14	16
12	2012	55	10/07/2012​	1	3	16	24	37	1	8		81​	2	13	8	13
13	2013	98	06/12/2013​	1	2	18	31	36	7	10		88​	1	16	13	5
14	2014	4	10/01/2014​	1	2	11	27	29	1	10		70​	1	9	16	2
15	2014	99	09/12/2014​	1	3	31	42	46	4	11		123​	2	28	11	4
16	2016	3	12/01/2016​	1	2	10	30	44	1	8		87​	1	8	20	14
17	2018	74	14/09/2018​	1	3	33	40	45	3	4		122​	2	30	7	5
18	2018	84	19/10/2018​	1	3	29	47	48	3	12		128​	2	26	18	1
19	2018	85	23/10/2018​	1	2	5	21	32	2	12		61​	1	3	16	11
20	2019	53	28/06/2019​	1	3	16	33	49	2	11		102​	2	13	17	16
21	2019	99	06/12/2019​	1	3	27	39	46	1	10		116​	2	24	12	7
22	2020	62	04/08/2020​	1	2	5	15	42	5	8		65​	1	3	10	27
23
24
*	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1
2
3
4
5	Year	SORTEO	FECHA	n1	n2	n3	n4	n5	*1	*2	EM	Sum Num	n2-n1	n3-n2	n4-n3	n5-n4
6	2018	85	23/10/2018​	1	2	5	21	32	2	12		61​	1	3	16	11
7	2020	62	04/08/2020​	1	2	5	15	42	5	8		65​	1	3	10	27
8	2012	7	24/01/2012​	1	2	6	20	36	8	11		65​	1	4	14	16
9	2016	3	12/01/2016​	1	2	10	30	44	1	8		87​	1	8	20	14
10	2014	4	10/01/2014​	1	2	11	27	29	1	10		70​	1	9	16	2
11	2013	98	06/12/2013​	1	2	18	31	36	7	10		88​	1	16	13	5
12	2008	52	26/12/2008​	1	2	26	44	50	1	7		123​	1	24	18	6
13	2006	39	29/09/2006​	1	3	6	18	24	5	8		52​	2	3	12	6
14	2004	44	10/12/2004​	1	3	13	16	43	2	7		76​	2	10	3	27
15	2007	34	24/08/2007​	1	3	16	42	48	2	3		110​	2	13	26	6
16	2012	55	10/07/2012​	1	3	16	24	37	1	8		81​	2	13	8	13
17	2019	53	28/06/2019​	1	3	16	33	49	2	11		102​	2	13	17	16
18	2004	14	14/05/2004​	1	3	21	32	39	2	6		96​	2	18	11	7
19	2019	99	06/12/2019​	1	3	27	39	46	1	10		116​	2	24	12	7
20	2018	84	19/10/2018​	1	3	29	47	48	3	12		128​	2	26	18	1
21	2014	99	09/12/2014​	1	3	31	42	46	4	11		123​	2	28	11	4
22	2018	74	14/09/2018​	1	3	33	40	45	3	4		122​	2	30	7	5
23
24

Please need help

Simple image is attached

Thank you all.

I am using Excel 2000

Regards,
Moti

 

[Fluff]

All you need to do is sort the data by one column (the lowest priority) then sort again by the other 3 columns.

 

[motilulla]

All you need to do is sort the data by one column (the lowest priority) then sort again by the other 3 columns.

Fluff, thank you for the tip I have spent 20-hours instead of sorting column D, E and F now sort as per your suggestion E, F and G and it worked fine.

Thank you so much for you help.

Kind Regards
Moti

 

[Fluff]

You're welcome & thanks for the feedback.

 

[motilulla]

Hello again,

I am blocked can not able to sort following all 5 columns, as it should be if I sort C, D and E I am getting result as per attached image but column F remain unsorted where 36 has to be upside and 45 down to 36, does it has any solution for my older version it could be VBA also is perfect.

A	B	C	D	E	F	G	H
	7	20	26	32	47
	7	20	38	40	43
	7	21	22	24	28
	7	21	23	24	44
	7	21	23	36	38
	7	21	26	35	43
	7	21	26	43	45
	7	23	24	34	36
	7	23	29	37	41
	7	23	30	32	45
	7	23	30	32	36
	7	23	31	33	39
	7	24	26	37	45
	7	25	27	48	49
	7	25	30	32	39
	7	25	34	40	49
	7	26	36	38	43
	7	27	29	39	50
	7	27	30	40	43

Regards,
Moti

 

[Fluff]

Sort on cols E & F, then sort on cols B, C & D

 

[motilulla]

Sort on cols E & F, then sort on cols B, C & D

Yes master Fluff, following as per your suggested step it sorted as I request thank you so much for your kind help and time.

It is just a question does there is any unique solution to sort all 5 at a time in one step only because I am facing this problem in different situations.

Kind Regards
Moti

 

[Fluff]

is any unique solution to sort all 5 at a time in one step

Not with your version of Excel.

 

[motilulla]

Not with your version of Excel.

Fluff, I can understand, normally said *Old Is Gold* but here it has meaning Old is Old* thank you master for your answer.

Have a great weekend ?

Kind Regards
Moti

 

[Fluff]

Glad to help & thanks for the feedback.