Advanced sorting

[Luki123]

Hello everyone,
I have a problem with advanced sorting (or at least I hope it needs some more advanced formula).
Basically I will try to explain what I would like to achieve on the screenshot.
I would like to get to the table in blue using 1 array formula or two separate formulas using (for CODE and VALUE) but I have no clue how to do it .
Do you have any ideas?

Thank you!

 

[Luki123]

Apologies. Data below:

Book1
	A	B	C	D	E	F	G	H	I	J
1	DATA
2
3	CODE	DEPT	BUILDING	ROOM	VALUE
4	ASD	A	1	3	123				SHOULD BE
5	ASD	A	1	23	342
6	SFDA	C	1	55	1342			Rank	CODE	VALUE
7	FR3	B	2	2	1243			1	SFDA	1342
8	ASD	A	2	1	543			2	ASD	465
9	FR3	A	1	3	23			3	FR3	23
10
11	Rank with CODE's DEPT=A, BUILDING=1 and ROOM=* (any value)
12
13	COUNTING CONDITION
14
15	CODE	DEPT	BUILDING	ROOM	VALUE	COUNT?
16	ASD	A	1	3	123	YES
17	ASD	A	1	23	342	YES
18	SFDA	A	1	55	1342	YES
19	FR3	B	2	2	1243	NO (DEPT=B)
20	ASD	A	2	1	543	NO (BUILDING=2)
21	FR3	A	1	3	23	YES
22
23	CODE's VALUES used in ranking
24
25	ASD	465
26	SFDA	1342
27	FR3	23
28
29
Arkusz1

Cell Formulas
Range	Formula
B25	=E16+E17
B26	=E18
B27	=E21