Formulas for 9 box grid

B

bematthe

New Member
Joined
Nov 20, 2018
Messages
5
I'm working on a 9-box talent matrix, and what we're trying to do is pull names from a list and into their respective grid square. Everything is working, except for the category of "High-Low." I keep checking the formula, tested tweaks, and even re-created it multiple times from scratch. But I run into the same issue every time. The correct names for the other 8 boxes generate just fine, but the High-Low box either displays nothing, or pulls an incorrect name.
Any suggestions as to what might be causing this?

BCDEFGHIJKL
1Talent ReviewPerformance
2Department/Group:PotentialLowMediumHigh
3Leader:HighLowHighMediumHighHigh
4High0Shadow ScruffyWinston Charles
5Employee NameD NumberCurrent
Employee Role		Current ManagerPotentialPerformance Tucker Marshall
6Ginger PyeHighLow
7Shadow ScruffyHighMedium
8Winston CharlesHighHigh
9Laila SerenaMediumLow
10Harper ShadowMediumMedium
11Isobel EliMediumHigh
12Abigail MaragretWell PositionedLow
13Tilly InaWell PositionedMedium(Hide)MediumLowMediumMediumMediumHigh
14Hunter MurphyWell PositionedHighMediumLaila SerenaHarper ShadowIsobel Eli
15Tucker MarshallHighMedium
16
17
18
19
20
21
22
23
24
25
26(Hide)Well PositionedLowWell PositionedMediumWell PositionedHigh
27Well PositionedAbigail MaragretTilly InaHunter Murphy
28
29
30

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
9 box​

Worksheet Formulas
CellFormula
J4=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(1:1)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(1:1)),2))
J5=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(2:2)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(2:2)),2))
J6=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(3:3)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(3:3)),2))
J7=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(4:4)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(4:4)),2))
J8=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(5:5)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(5:5)),2))
J9=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(6:6)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(6:6)),2))
J10=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(7:7)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(7:7)),2))
J11=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(8:8)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(8:8)),2))

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>

Array Formulas
CellFormula
K4{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(1:1)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(1:1)),2))}
L4{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(1:1)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(1:1)),2))}
K5{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(2:2)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(2:2)),2))}
L5{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(2:2)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(2:2)),2))}
K6{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(3:3)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(3:3)),2))}
L6{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(3:3)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(3:3)),2))}
K7{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(4:4)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(4:4)),2))}
L7{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(4:4)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(4:4)),2))}
K8{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(5:5)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(5:5)),2))}
L8{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(5:5)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(5:5)),2))}
K9{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(6:6)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(6:6)),2))}
L9{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(6:6)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(6:6)),2))}
K10{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(7:7)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(7:7)),2))}
L10{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(7:7)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(7:7)),2))}
K11{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(8:8)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(8:8)),2))}
L11{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(8:8)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(8:8)),2))}
J12{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(9:9)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$3,ROW($A$1:$A$38)),ROW(9:9)),2))}
K12{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(9:9)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$3,ROW($A$1:$A$38)),ROW(9:9)),2))}
L12{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(9:9)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$3,ROW($A$1:$A$38)),ROW(9:9)),2))}
J14{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(1:1)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(1:1)),2))}
K14{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(1:1)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(1:1)),2))}
L14{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(1:1)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(1:1)),2))}
J15{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(2:2)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(2:2)),2))}
K15{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(2:2)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(2:2)),2))}
L15{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(2:2)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(2:2)),2))}
J16{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(3:3)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(3:3)),2))}
K16{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(3:3)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(3:3)),2))}
L16{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(3:3)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(3:3)),2))}
J17{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(4:4)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(4:4)),2))}
K17{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(4:4)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(4:4)),2))}
L17{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(4:4)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(4:4)),2))}
J18{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(5:5)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(5:5)),2))}
K18{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(5:5)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(5:5)),2))}
L18{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(5:5)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(5:5)),2))}
J19{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(6:6)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(6:6)),2))}
K19{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(6:6)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(6:6)),2))}
L19{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(6:6)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(6:6)),2))}
J20{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(7:7)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(7:7)),2))}
K20{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(7:7)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(7:7)),2))}
L20{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(7:7)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(7:7)),2))}
J21{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(8:8)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(8:8)),2))}
K21{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(8:8)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(8:8)),2))}
L21{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(8:8)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(8:8)),2))}
J22{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(9:9)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(9:9)),2))}
K22{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(9:9)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(9:9)),2))}
L22{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(9:9)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(9:9)),2))}
J23{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(10:10)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(10:10)),2))}
K23{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(10:10)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(10:10)),2))}
L23{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(10:10)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(10:10)),2))}
J24{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(11:11)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(11:11)),2))}
K24{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(11:11)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(11:11)),2))}
L24{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(11:11)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(11:11)),2))}
J25{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(12:12)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$13,ROW($A$1:$A$38)),ROW(12:12)),2))}
K25{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(12:12)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$13,ROW($A$1:$A$38)),ROW(12:12)),2))}
L25{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(12:12)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$13,ROW($A$1:$A$38)),ROW(12:12)),2))}
J27{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$26,ROW($A$1:$A$38)),ROW(1:1)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$26,ROW($A$1:$A$38)),ROW(1:1)),2))}
K27{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$26,ROW($A$1:$A$38)),ROW(1:1)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$26,ROW($A$1:$A$38)),ROW(1:1)),2))}
L27{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$26,ROW($A$1:$A$38)),ROW(1:1)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$26,ROW($A$1:$A$38)),ROW(1:1)),2))}
J28{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$26,ROW($A$1:$A$38)),ROW(2:2)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$26,ROW($A$1:$A$38)),ROW(2:2)),2))}
K28{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$26,ROW($A$1:$A$38)),ROW(2:2)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$26,ROW($A$1:$A$38)),ROW(2:2)),2))}
L28{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$26,ROW($A$1:$A$38)),ROW(2:2)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$26,ROW($A$1:$A$38)),ROW(2:2)),2))}
J29{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$26,ROW($A$1:$A$38)),ROW(3:3)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$26,ROW($A$1:$A$38)),ROW(3:3)),2))}
K29{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$26,ROW($A$1:$A$38)),ROW(3:3)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$26,ROW($A$1:$A$38)),ROW(3:3)),2))}
L29{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$26,ROW($A$1:$A$38)),ROW(3:3)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$26,ROW($A$1:$A$38)),ROW(3:3)),2))}
J30{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$26,ROW($A$1:$A$38)),ROW(4:4)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$J$26,ROW($A$1:$A$38)),ROW(4:4)),2))}
K30{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$26,ROW($A$1:$A$38)),ROW(4:4)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$K$26,ROW($A$1:$A$38)),ROW(4:4)),2))}
L30{=IF(ISERROR(INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$26,ROW($A$1:$A$38)),ROW(4:4)),2))," ",INDEX($A$1:$B$38,SMALL(IF($A$1:$A$38=$L$26,ROW($A$1:$A$38)),ROW(4:4)),2))}

<thead>
</thead><tbody>
</tbody>
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>



<tbody>
</tbody>
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
sandy666

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
something like that?

PotentialLowMediumHigh
HighGinger PyeWinston Charles
MediumLaila SerenaHarper ShadowIsobel Eli
Well PositionedAbigail MaragretTilly InaHunter Murphy


Edit:
Wrong, I missed error in blank cell :(
 
Last edited:
sandy666

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
here is:

PotentialLowMediumHigh
HighGinger PyeShadow Scruffy,Tucker MarshallWinston Charles
MediumLaila SerenaHarper ShadowIsobel Eli
Well PositionedAbigail MaragretTilly InaHunter Murphy
 
B

bematthe

New Member
Joined
Nov 20, 2018
Messages
5
So my question would be, how did you adjust the formula so that the name(s) going in the "HighLow" box populated?
 
B

bematthe

New Member
Joined
Nov 20, 2018
Messages
5

ADVERTISEMENT

I don't think I included the hidden columnA in the original post, if that helps.

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style="text-align: right;;"></td><td style="font-weight: bold;;">Talent Review</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;;"></td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #BDD7EE;;">Performance</td><td style="text-align: right;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style="text-align: right;;"></td><td style="font-weight: bold;;">Department/Group:</td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #BDD7EE;;">Potential</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;">Low</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;">Medium</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;">High</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style="text-align: right;;"></td><td style="font-weight: bold;;">Leader:</td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #0D0D0D;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #0D0D0D;;">HighLow</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #0D0D0D;;">HighMedium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #0D0D0D;;">HighHigh</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style="text-align: right;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;">High</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;">0</td><td style="border-right: 1px solid black;border-left: 1px solid black;;">Shadow Scruffy</td><td style="border-right: 1px solid black;border-left: 1px solid black;;">Winston Charles</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style="border-right: 1px solid black;;">Rating</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Employee Name</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #595959;;">D Number</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #595959;;">Current Employee Role</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #595959;;">Current Manager</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #4472C4;;">Potential</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #4472C4;;">Performance</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;">Tucker Marshall</td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style="border-right: 1px solid black;;">HighLow</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Ginger Pye</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">High</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Low</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style="border-right: 1px solid black;;">HighMedium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Shadow Scruffy</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">High</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Medium</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style="border-right: 1px solid black;;">HighHigh</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Winston Charles</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">High</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">High</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style="border-right: 1px solid black;;">MediumLow</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Laila Serena</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Medium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Low</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style="border-right: 1px solid black;;">MediumMedium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Harper Shadow</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Medium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Medium</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">11</td><td style="border-right: 1px solid black;;">MediumHigh</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Isobel Eli</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Medium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">High</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">12</td><td style="border-right: 1px solid black;;">Well PositionedLow</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Abigail Maragret</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Well Positioned</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Low</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">13</td><td style="border-right: 1px solid black;;">Well PositionedMedium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Tilly Ina</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Well Positioned</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Medium</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #0D0D0D;;">(Hide)</td><td style="border-top: 1px solid black;border-bottom: 1px solid black;background-color: #0D0D0D;;">MediumLow</td><td style="border-top: 1px solid black;border-bottom: 1px solid black;background-color: #0D0D0D;;">MediumMedium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;background-color: #0D0D0D;;">MediumHigh</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">14</td><td style="border-right: 1px solid black;;">Well PositionedHigh</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Hunter Murphy</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Well Positioned</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">High</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;">Medium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;">Laila Serena</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;">Harper Shadow</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;">Isobel Eli</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">15</td><td style="border-right: 1px solid black;;">HighMedium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Tucker Marshall</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">High</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;">Medium</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">16</td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">17</td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">18</td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">19</td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">20</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">21</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">22</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">23</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">24</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">25</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">26</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #0D0D0D;;">(Hide)</td><td style="border-top: 1px solid black;border-bottom: 1px solid black;background-color: #0D0D0D;;">Well PositionedLow</td><td style="border-top: 1px solid black;border-bottom: 1px solid black;background-color: #0D0D0D;;">Well PositionedMedium</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;background-color: #0D0D0D;;">Well PositionedHigh</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">27</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;">Well Positioned</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;">Abigail Maragret</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;">Tilly Ina</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;">Hunter Murphy</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">28</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">29</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">30</td><td style="border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #D9D9D9;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #DDEBF7;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #FFF2CC;;"></td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td><td style="border-right: 1px solid black;border-left: 1px solid black;;"> </td></tr></tbody></table><p style="width:4em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">9 box</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J4</th><td style="text-align:left">=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">1:1</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">1:1</font>)</font>),2</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J5</th><td style="text-align:left">=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">2:2</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">2:2</font>)</font>),2</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J6</th><td style="text-align:left">=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">3:3</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">3:3</font>)</font>),2</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J7</th><td style="text-align:left">=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">4:4</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">4:4</font>)</font>),2</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J8</th><td style="text-align:left">=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">5:5</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">5:5</font>)</font>),2</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J9</th><td style="text-align:left">=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">6:6</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">6:6</font>)</font>),2</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J10</th><td style="text-align:left">=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">7:7</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">7:7</font>)</font>),2</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J11</th><td style="text-align:left">=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">8:8</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">8:8</font>)</font>),2</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A7</th><td style="text-align:left">=F7&G7</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A8</th><td style="text-align:left">=F8&G8</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A9</th><td style="text-align:left">=F9&G9</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A10</th><td style="text-align:left">=F10&G10</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A11</th><td style="text-align:left">=F11&G11</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A12</th><td style="text-align:left">=F12&G12</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A13</th><td style="text-align:left">=F13&G13</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A14</th><td style="text-align:left">=F14&G14</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A15</th><td style="text-align:left">=F15&G15</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A20</th><td style="text-align:left">=F20&G20</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A21</th><td style="text-align:left">=F21&G21</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A22</th><td style="text-align:left">=F22&G22</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A23</th><td style="text-align:left">=F23&G23</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A24</th><td style="text-align:left">=F24&G24</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A25</th><td style="text-align:left">=F25&G25</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A26</th><td style="text-align:left">=F26&G26</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A27</th><td style="text-align:left">=F27&G27</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A28</th><td style="text-align:left">=F28&G28</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A29</th><td style="text-align:left">=F29&G29</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A30</th><td style="text-align:left">=F30&G30</td></tr></tbody></table></td></tr></table><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Array Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K4</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">1:1</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">1:1</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L4</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">1:1</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">1:1</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K5</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">2:2</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">2:2</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L5</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">2:2</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">2:2</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K6</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">3:3</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">3:3</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L6</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">3:3</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">3:3</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K7</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">4:4</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">4:4</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L7</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">4:4</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">4:4</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K8</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">5:5</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">5:5</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L8</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">5:5</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">5:5</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K9</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">6:6</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">6:6</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L9</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">6:6</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">6:6</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K10</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">7:7</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">7:7</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L10</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">7:7</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">7:7</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K11</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">8:8</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">8:8</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L11</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">8:8</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">8:8</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J12</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">9:9</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">9:9</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K12</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">9:9</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">9:9</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L12</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$3,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">9:9</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$3,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">9:9</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J14</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">1:1</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">1:1</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K14</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">1:1</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">1:1</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L14</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">1:1</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">1:1</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J15</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">2:2</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">2:2</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K15</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">2:2</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">2:2</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L15</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">2:2</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">2:2</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J16</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">3:3</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">3:3</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K16</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">3:3</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">3:3</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L16</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">3:3</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">3:3</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J17</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">4:4</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">4:4</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K17</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">4:4</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">4:4</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L17</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">4:4</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">4:4</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J18</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">5:5</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">5:5</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K18</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">5:5</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">5:5</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L18</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">5:5</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">5:5</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J19</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">6:6</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">6:6</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K19</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">6:6</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">6:6</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L19</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">6:6</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">6:6</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J20</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">7:7</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">7:7</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K20</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">7:7</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">7:7</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L20</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">7:7</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">7:7</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J21</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">8:8</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">8:8</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K21</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">8:8</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">8:8</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L21</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">8:8</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">8:8</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J22</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">9:9</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">9:9</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K22</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">9:9</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">9:9</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L22</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">9:9</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">9:9</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J23</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">10:10</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">10:10</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K23</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">10:10</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">10:10</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L23</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">10:10</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">10:10</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J24</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">11:11</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">11:11</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K24</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">11:11</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">11:11</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L24</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">11:11</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">11:11</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J25</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">12:12</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">12:12</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K25</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">12:12</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">12:12</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L25</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$13,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">12:12</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$13,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">12:12</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J27</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">1:1</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">1:1</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K27</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">1:1</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">1:1</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L27</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">1:1</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">1:1</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J28</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">2:2</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">2:2</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K28</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">2:2</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">2:2</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L28</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">2:2</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">2:2</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J29</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">3:3</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">3:3</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K29</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">3:3</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">3:3</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L29</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">3:3</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">3:3</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">J30</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$J$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">4:4</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$J$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">4:4</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">K30</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$K$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">4:4</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$K$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">4:4</font>)</font>),2</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">L30</th><td style="text-align:left">{=IF(<font color="Blue">ISERROR(<font color="Red">INDEX(<font color="Green">$A$1:$B$38,SMALL(<font color="Purple">IF(<font color="Teal">$A$1:$A$38=$L$26,ROW(<font color="#FF00FF">$A$1:$A$38</font>)</font>),ROW(<font color="Teal">4:4</font>)</font>),2</font>)</font>)," ",INDEX(<font color="Red">$A$1:$B$38,SMALL(<font color="Green">IF(<font color="Purple">$A$1:$A$38=$L$26,ROW(<font color="Teal">$A$1:$A$38</font>)</font>),ROW(<font color="Purple">4:4</font>)</font>),2</font>)</font>)}</td></tr></tbody></table><b>Entered with Ctrl+Shift+Enter.</b> If entered correctly, Excel will surround with curly braces {}.
<b>Note: Do not try and enter the {} manually yourself</b></td></tr></table><br />
 
sandy666

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
if this is what you want, here is M-code for PowerQuery (based on 1st post):

Code: 
[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Employee Name", type text}, {"ID Number", type any}, {"Current Employee Role", type any}, {"Current Manager", type any}, {"Potential", type text}, {"Performance", type text}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"ID Number", "Current Employee Role", "Current Manager"}),
    #"Grouped Rows" = Table.Group(#"Removed Columns", {"Potential", "Performance"}, {{"Count", each _, type table}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.Column([Count],"Employee Name")),
    #"Extracted Values" = Table.TransformColumns(#"Added Custom", {"Custom", each Text.Combine(List.Transform(_, Text.From), ","), type text}),
    #"Removed Columns1" = Table.RemoveColumns(#"Extracted Values",{"Count"}),
    #"Pivoted Column" = Table.Pivot(#"Removed Columns1", List.Distinct(#"Removed Columns1"[Performance]), "Performance", "Custom")
in
    #"Pivoted Column"[/SIZE]
 
Last edited:
Fluff

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,795
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

Your formula in J4 down should be an array formula like the others.
 
B

bematthe

New Member
Joined
Nov 20, 2018
Messages
5
Fluff said:
Your formula in J4 down should be an array formula like the others.
Click to expand...

Aha! Thank you! I knew it has to be something silly that I was just missing. Why I kept missing it, I have no idea.
Thank you!
 
Fluff

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,795
Office Version
  1. 365
Platform
  1. Windows
You're welcome
 
You must log in or register to reply here.

Similar threads

P
  • Question
Need to setup slicer for allocation percentage for each resource for the each month
Replies
0
Views
33
param
P
M
  • Solved
Specific range by week number
Replies
3
Views
26
Fluff
Fluff
C
  • Solved
Obtaining a Rank by multiple columns of values.
Replies
8
Views
188
Fluff
Fluff
A
  • Solved
Star (Min) and End (Max) date claculation from series of dates in table
Replies
6
Views
154
ateeqsindhu
A
F
  • Solved
consolidate date time in cells
Replies
1
Views
66
FROGGER24
F

Watch MrExcel Video

Learn Excel from MrExcel - Create A Bell Curve in Excel - Podcast #1663

Forum statistics

Threads
1,130,060
Messages
5,639,828
Members
417,117
Latest member
Ravi Pandey

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top