Formulas for 9 box grid

bematthe · Nov 21, 2018

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?

	B	C	D
Talent Review
Department/Group:
Leader:
Shadow Scruffy	Winston Charles
Employee Name		Tucker Marshall
Ginger Pye
Shadow Scruffy
Winston Charles
Laila Serena
Harper Shadow
Isobel Eli
Abigail Maragret
Tilly Ina
Hunter Murphy	Laila Serena	Harper Shadow	Isobel Eli
Tucker Marshall











Abigail Maragret	Tilly Ina	Hunter Murphy

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE"]Performance[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE"]Potential[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] "]Low[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] "]Medium[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] "]High[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0D0D0D]#0D0D0D[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0D0D0D]#0D0D0D[/URL] "]HighLow[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0D0D0D]#0D0D0D[/URL] "]HighMedium[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0D0D0D]#0D0D0D[/URL] "]HighHigh[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] "]High[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]5[/TD]

[TD="bgcolor: #595959"]D Number[/TD]
[TD="bgcolor: #595959"]Current
Employee Role[/TD]
[TD="bgcolor: #595959"]Current Manager[/TD]
[TD="bgcolor: #4472C4"]Potential[/TD]
[TD="bgcolor: #4472C4"]Performance[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]High[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Low[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]High[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Medium[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]8[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]High[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]High[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Medium[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Low[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]10[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Medium[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Medium[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]11[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Medium[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]High[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]12[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Well Positioned[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Low[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]13[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Well Positioned[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Medium[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0D0D0D]#0D0D0D[/URL] "](Hide)[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0D0D0D]#0D0D0D[/URL] "]MediumLow[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0D0D0D]#0D0D0D[/URL] "]MediumMedium[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0D0D0D]#0D0D0D[/URL] "]MediumHigh[/TD]

[TD="align: center"]14[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Well Positioned[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]High[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] "]Medium[/TD]

[TD="align: center"]15[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]High[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] "]Medium[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]16[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]17[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]18[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]19[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]20[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]21[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]22[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]23[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]24[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]25[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]26[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0D0D0D]#0D0D0D[/URL] "](Hide)[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0D0D0D]#0D0D0D[/URL] "]Well PositionedLow[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0D0D0D]#0D0D0D[/URL] "]Well PositionedMedium[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0D0D0D]#0D0D0D[/URL] "]Well PositionedHigh[/TD]

[TD="align: center"]27[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] "]Well Positioned[/TD]

[TD="align: center"]28[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]29[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

[TD="align: center"]30[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DDEBF7]#DDEBF7[/URL] , align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF2CC]#FFF2CC[/URL] , align: right"][/TD]

</tbody>

9 box

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J4[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J5[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J6[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J7[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J8[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J9[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J10[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J11[/TH]
[TD="align: left"]=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))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K4[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L4[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K5[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L5[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K6[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L6[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K7[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L7[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K8[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L8[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K9[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L9[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K10[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L10[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K11[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L11[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J12[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K12[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L12[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J14[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K14[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L14[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J15[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K15[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L15[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J16[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K16[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L16[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J17[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K17[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L17[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J18[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K18[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L18[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J19[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K19[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L19[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J20[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K20[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L20[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J21[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K21[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L21[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J22[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K22[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L22[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J23[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K23[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L23[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J24[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K24[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L24[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J25[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K25[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L25[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J27[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K27[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L27[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J28[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K28[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L28[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J29[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K29[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L29[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J30[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K30[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L30[/TH]
[TD="align: left"]{=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))}[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 1102"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

sandy666 · Nov 21, 2018

something like that?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#70AD47]Potential[/td][td=bgcolor:#70AD47]Low[/td][td=bgcolor:#70AD47]Medium[/td][td=bgcolor:#70AD47]High[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]High[/td][td=bgcolor:#E2EFDA]Ginger Pye[/td][td=bgcolor:#E2EFDA][/td][td=bgcolor:#E2EFDA]Winston Charles[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Medium[/td][td]Laila Serena[/td][td]Harper Shadow[/td][td]Isobel Eli[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Well Positioned[/td][td=bgcolor:#E2EFDA]Abigail Maragret[/td][td=bgcolor:#E2EFDA]Tilly Ina[/td][td=bgcolor:#E2EFDA]Hunter Murphy[/td][/tr]
[/table]

Edit:
Wrong, I missed error in blank cell

sandy666 · Nov 21, 2018

here is:

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#70AD47]Potential[/td][td=bgcolor:#70AD47]Low[/td][td=bgcolor:#70AD47]Medium[/td][td=bgcolor:#70AD47]High[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]High[/td][td=bgcolor:#E2EFDA]Ginger Pye[/td][td=bgcolor:#E2EFDA]Shadow Scruffy,Tucker Marshall[/td][td=bgcolor:#E2EFDA]Winston Charles[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Medium[/td][td]Laila Serena[/td][td]Harper Shadow[/td][td]Isobel Eli[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Well Positioned[/td][td=bgcolor:#E2EFDA]Abigail Maragret[/td][td=bgcolor:#E2EFDA]Tilly Ina[/td][td=bgcolor:#E2EFDA]Hunter Murphy[/td][/tr]
[/table]

bematthe · Nov 21, 2018

So my question would be, how did you adjust the formula so that the name(s) going in the "HighLow" box populated?

bematthe · Nov 21, 2018

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

Book1

A

B

C

D

E

F

G

H

I

J

K

L

1

Talent Review

Performance

2

Department/Group:

Potential

Low

Medium

High

3

Leader:

HighLow

HighMedium

HighHigh

4

High

0

Shadow Scruffy

Winston Charles

5

Rating

Employee Name

D Number

Current Employee Role

Current Manager

Potential

Performance

Tucker Marshall

6

HighLow

Ginger Pye

High

Low

7

HighMedium

Shadow Scruffy

High

Medium

8

HighHigh

Winston Charles

High

9

MediumLow

Laila Serena

Medium

Low

10

MediumMedium

Harper Shadow

Medium

11

MediumHigh

Isobel Eli

Medium

High

12

Well PositionedLow

Abigail Maragret

Well Positioned

Low

13

Well PositionedMedium

Tilly Ina

Well Positioned

Medium

(Hide)

MediumLow

MediumMedium

MediumHigh

14

Well PositionedHigh

Hunter Murphy

Well Positioned

High

Medium

15

Tucker Marshall

High

Medium

16

17

18

19

20

21

22

23

24

25

26

(Hide)

Well PositionedLow

Well PositionedMedium

Well PositionedHigh

27

Well Positioned

Abigail Maragret

Tilly Ina

Hunter Murphy

28

29

30

9 box

Cell Formulas
Range	Formula
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))
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
A7	=F7&G7
A8	=F8&G8
A9	=F9&G9
A10	=F10&G10
A11	=F11&G11
A12	=F12&G12
A13	=F13&G13
A14	=F14&G14
A15	=F15&G15
A20	=F20&G20
A21	=F21&G21
A22	=F22&G22
A23	=F23&G23
A24	=F24&G24
A25	=F25&G25
A26	=F26&G26
A27	=F27&G27
A28	=F28&G28
A29	=F29&G29
A30	=F30&G30
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
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))}
Press CTRL+SHIFT+ENTER to enter array formulas.

sandy666 · Nov 21, 2018

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]

Fluff · Nov 21, 2018

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

bematthe · Nov 21, 2018

Fluff said:
Your formula in J4 down should be an array formula like the others.

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 · Nov 21, 2018

You're welcome

Formulas for 9 box grid

bematthe

New Member

Excel Facts

sandy666

Banned - Rules violations

sandy666

Banned - Rules violations

bematthe

New Member

bematthe

New Member

sandy666

Banned - Rules violations

Fluff

MrExcel MVP, Moderator

bematthe

New Member

Fluff

MrExcel MVP, Moderator

Similar threads

Forum statistics

Share this page

Formulas for 9 box grid

New Member

Excel Facts

Banned - Rules violations

Banned - Rules violations

New Member

New Member

Banned - Rules violations

MrExcel MVP, Moderator

New Member

MrExcel MVP, Moderator

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock