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>
 
sandy666

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,860
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

Well-known Member
Joined
Oct 24, 2015
Messages
3,860
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
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

Well-known Member
Joined
Oct 24, 2015
Messages
3,860
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
32,445
Office Version
365
Platform
Windows
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
32,445
Office Version
365
Platform
Windows
You're welcome
 
You must log in or register to reply here.

Forum statistics

Threads
1,082,632
Messages
5,366,674
Members
400,912
Latest member
Click22

Share this page

Some videos you may like

This Week's Hot Topics

Top