Sort from Z-A with condition

[el c]

Hi,
I would like to sort the "Location" from Z-A for each order . The label "item" goes with the Location, they are pairs. Here is an example of what I want to do:

Book7
	A	B	C	D	E	F	G
1	Orders	item	Location		Orders	item	Location
2	1	367-66-400	11276		1	367-66-400	11278
3	1	311-12-141	11119		1	367-66-400	11276
4	1	311-12-141	11033	to	1	311-12-141	11235
5	1	311-12-141	11235		1	311-12-141	11119
6	1	367-66-400	11278		1	311-12-141	11033
7	2	418-15-001	11237		2	418-15-001	11239
8	2	418-15-001	11239		2	418-15-001	11237
9	2	418-15-001	11231		2	418-15-001	11231
Sheet1

Cell Formulas
Range	Formula
E2:E9	E2	=A2

 

[Fluff]

How about

+Fluff.xlsm
	A	B	C	D	E	F	G
1	Orders	item	Location		Orders	item	Location
2	1	367-66-400	11276		1	367-66-400	11278
3	1	311-12-141	11119		1	367-66-400	11276
4	1	311-12-141	11033		1	311-12-141	11235
5	1	311-12-141	11235		1	311-12-141	11119
6	1	367-66-400	11278		1	311-12-141	11033
7	2	418-15-001	11237		2	418-15-001	11239
8	2	418-15-001	11239		2	418-15-001	11237
9	2	418-15-001	11231		2	418-15-001	11231
Master

Cell Formulas
Range	Formula
E2:G9	E2	=SORTBY(A2:C9,A2:A9,1,C2:C9,-1)
Dynamic array formulas.

 

[el c]

Thank you for responding. When I copy-paste it it appears like this :

Book7
	A	B	C	D	E	F	G
1	Orders	item	Location		Orders	item	Location
2	1	367-66-400	11276		#NAME?
3	1	311-12-141	11119
4	1	311-12-141	11033
5	1	311-12-141	11235
6	1	367-66-400	11278
7	2	418-15-001	11237
8	2	418-15-001	11239
9	2	418-15-001	11231
Sheet1

Cell Formulas
Range	Formula
E2	E2	=SORTBY(A2:C9,A2:A9,1,C2:C9,-1)

 

[sandy666]

SORTBY()
Note: This function is currently available to Office 365 subscribers in the Monthly channel. It will be available to Office 365 subscribers in the Semi-Annual channel starting in July 2020.

 

[Peter_SSs]

Until you get the SORTBY function, see if these, copied down, do what you want.

20 04 05.xlsm
	A	B	C	D	E	F	G
1	Orders	item	Location		Orders	item	Location
2	1	367-66-400	11276		1	367-66-400	11278
3	1	311-12-141	11119		1	367-66-400	11276
4	1	311-12-141	11033		1	311-12-141	11235
5	1	311-12-141	11235		1	311-12-141	11119
6	1	367-66-400	11278		1	311-12-141	11033
7	2	418-15-001	11237		2	418-15-001	11239
8	2	418-15-001	11239		2	418-15-001	11237
9	2	418-15-001	11231		2	418-15-001	11231
Sort

Cell Formulas
Range	Formula
E2:E9	E2	=A2
F2:F9	F2	=INDEX(B$2:B$9,AGGREGATE(15,6,(ROW(B$2:B$9)-ROW(B$2)+1)/((A$2:A$9=E2)*(C$2:C$9=G2)),1))
G2:G9	G2	=AGGREGATE(14,6,C$2:C$9/(A$2:A$9=E2),COUNTIF(E$2:E2,E2))

 

[el c]

Thank you very much, Peter!

 

[Peter_SSs]

Thank you very much, Peter!

You're welcome. Thanks for the follow-up.