Finding the smallest 3 values by region

Please try at K4:K18
=IFERROR(INDEX(B:B,MOD(AGGREGATE(15,6,C$3:C$52*10^6+ROW(C$3:C$52)/(A$3:A$52=LOOKUP("z",I$4:I4)),J4),10^6)),"")

Excel 2016 (Windows) 32 bit

	I	J	K
2	The worst 3 (smallest value) units by region
3
4	North	1	170
5		2	181
6		3	188
7
8	East	1	126
9		2	167
10		3	302
11
12	South	1	162
13		2	171
14		3	213
15
16	West	1	132
17		2	172
18		3	224

Excel 2016 (Windows) 32 bit

	K
4	=SMALL(IF(A:A=$I$4,C:C,10^9),ROW()-3)
5	=SMALL(IF(A:A=$I$4,C:C,10^9),ROW()-3)
6	=SMALL(IF(A:A=$I$4,C:C,10^9),ROW()-3)
7
8	=SMALL(IF(A:A=$I$8,C:C,10^9),ROW()-7)
9	=SMALL(IF(A:A=$I$8,C:C,10^9),ROW()-7)
10	=SMALL(IF(A:A=$I$8,C:C,10^9),ROW()-7)
11
12	=SMALL(IF(A:A=$I$12,C:C,10^9),ROW()-11)
13	=SMALL(IF(A:A=$I$12,C:C,10^9),ROW()-11)
14	=SMALL(IF(A:A=$I$12,C:C,10^9),ROW()-11)
15
16	=SMALL(IF(A:A=$I$16,C:C,10^9),ROW()-15)
17	=SMALL(IF(A:A=$I$16,C:C,10^9),ROW()-15)
18	=SMALL(IF(A:A=$I$16,C:C,10^9),ROW()-15)

In K4 then copy down

=IFERROR(AGGREGATE(15,6,$C$3:$C$52/($A$3:$A$52=INDEX($I$4:$I4,MATCH("ZZZ",$I$4:$I4,1))),J4),"")

In K3 Cell

Please Login or Register  to view this content.

Drag the formula down