Cell | Formula | C11 | {=IFERROR(INDEX($C2:$L2,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C2:$L2<>"",MATCH($C2:$L2,$C2:$L2,0)),COLUMN($C2:$L2)-COLUMN($C2)+1)),COLUMN($C2:$L2)-COLUMN($C2)+1),COLUMNS($C11:C11))),"")} | D11 | {=IFERROR(INDEX($C2:$L2,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C2:$L2<>"",MATCH($C2:$L2,$C2:$L2,0)),COLUMN($C2:$L2)-COLUMN($C2)+1)),COLUMN($C2:$L2)-COLUMN($C2)+1),COLUMNS($C11:D11))),"")} | E11 | {=IFERROR(INDEX($C2:$L2,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C2:$L2<>"",MATCH($C2:$L2,$C2:$L2,0)),COLUMN($C2:$L2)-COLUMN($C2)+1)),COLUMN($C2:$L2)-COLUMN($C2)+1),COLUMNS($C11:E11))),"")} | F11 | {=IFERROR(INDEX($C2:$L2,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C2:$L2<>"",MATCH($C2:$L2,$C2:$L2,0)),COLUMN($C2:$L2)-COLUMN($C2)+1)),COLUMN($C2:$L2)-COLUMN($C2)+1),COLUMNS($C11:F11))),"")} | G11 | {=IFERROR(INDEX($C2:$L2,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C2:$L2<>"",MATCH($C2:$L2,$C2:$L2,0)),COLUMN($C2:$L2)-COLUMN($C2)+1)),COLUMN($C2:$L2)-COLUMN($C2)+1),COLUMNS($C11:G11))),"")} | C12 | {=IFERROR(INDEX($C3:$L3,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C3:$L3<>"",MATCH($C3:$L3,$C3:$L3,0)),COLUMN($C3:$L3)-COLUMN($C3)+1)),COLUMN($C3:$L3)-COLUMN($C3)+1),COLUMNS($C12:C12))),"")} | D12 | {=IFERROR(INDEX($C3:$L3,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C3:$L3<>"",MATCH($C3:$L3,$C3:$L3,0)),COLUMN($C3:$L3)-COLUMN($C3)+1)),COLUMN($C3:$L3)-COLUMN($C3)+1),COLUMNS($C12:D12))),"")} | E12 | {=IFERROR(INDEX($C3:$L3,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C3:$L3<>"",MATCH($C3:$L3,$C3:$L3,0)),COLUMN($C3:$L3)-COLUMN($C3)+1)),COLUMN($C3:$L3)-COLUMN($C3)+1),COLUMNS($C12:E12))),"")} | F12 | {=IFERROR(INDEX($C3:$L3,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C3:$L3<>"",MATCH($C3:$L3,$C3:$L3,0)),COLUMN($C3:$L3)-COLUMN($C3)+1)),COLUMN($C3:$L3)-COLUMN($C3)+1),COLUMNS($C12:F12))),"")} | G12 | {=IFERROR(INDEX($C3:$L3,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C3:$L3<>"",MATCH($C3:$L3,$C3:$L3,0)),COLUMN($C3:$L3)-COLUMN($C3)+1)),COLUMN($C3:$L3)-COLUMN($C3)+1),COLUMNS($C12:G12))),"")} | C13 | {=IFERROR(INDEX($C4:$L4,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C4:$L4<>"",MATCH($C4:$L4,$C4:$L4,0)),COLUMN($C4:$L4)-COLUMN($C4)+1)),COLUMN($C4:$L4)-COLUMN($C4)+1),COLUMNS($C13:C13))),"")} | D13 | {=IFERROR(INDEX($C4:$L4,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C4:$L4<>"",MATCH($C4:$L4,$C4:$L4,0)),COLUMN($C4:$L4)-COLUMN($C4)+1)),COLUMN($C4:$L4)-COLUMN($C4)+1),COLUMNS($C13:D13))),"")} | E13 | {=IFERROR(INDEX($C4:$L4,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C4:$L4<>"",MATCH($C4:$L4,$C4:$L4,0)),COLUMN($C4:$L4)-COLUMN($C4)+1)),COLUMN($C4:$L4)-COLUMN($C4)+1),COLUMNS($C13:E13))),"")} | F13 | {=IFERROR(INDEX($C4:$L4,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C4:$L4<>"",MATCH($C4:$L4,$C4:$L4,0)),COLUMN($C4:$L4)-COLUMN($C4)+1)),COLUMN($C4:$L4)-COLUMN($C4)+1),COLUMNS($C13:F13))),"")} | G13 | {=IFERROR(INDEX($C4:$L4,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C4:$L4<>"",MATCH($C4:$L4,$C4:$L4,0)),COLUMN($C4:$L4)-COLUMN($C4)+1)),COLUMN($C4:$L4)-COLUMN($C4)+1),COLUMNS($C13:G13))),"")} | C14 | {=IFERROR(INDEX($C5:$L5,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C5:$L5<>"",MATCH($C5:$L5,$C5:$L5,0)),COLUMN($C5:$L5)-COLUMN($C5)+1)),COLUMN($C5:$L5)-COLUMN($C5)+1),COLUMNS($C14:C14))),"")} | D14 | {=IFERROR(INDEX($C5:$L5,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C5:$L5<>"",MATCH($C5:$L5,$C5:$L5,0)),COLUMN($C5:$L5)-COLUMN($C5)+1)),COLUMN($C5:$L5)-COLUMN($C5)+1),COLUMNS($C14:D14))),"")} | E14 | {=IFERROR(INDEX($C5:$L5,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C5:$L5<>"",MATCH($C5:$L5,$C5:$L5,0)),COLUMN($C5:$L5)-COLUMN($C5)+1)),COLUMN($C5:$L5)-COLUMN($C5)+1),COLUMNS($C14:E14))),"")} | F14 | {=IFERROR(INDEX($C5:$L5,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C5:$L5<>"",MATCH($C5:$L5,$C5:$L5,0)),COLUMN($C5:$L5)-COLUMN($C5)+1)),COLUMN($C5:$L5)-COLUMN($C5)+1),COLUMNS($C14:F14))),"")} | G14 | {=IFERROR(INDEX($C5:$L5,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C5:$L5<>"",MATCH($C5:$L5,$C5:$L5,0)),COLUMN($C5:$L5)-COLUMN($C5)+1)),COLUMN($C5:$L5)-COLUMN($C5)+1),COLUMNS($C14:G14))),"")} | C15 | {=IFERROR(INDEX($C6:$L6,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C6:$L6<>"",MATCH($C6:$L6,$C6:$L6,0)),COLUMN($C6:$L6)-COLUMN($C6)+1)),COLUMN($C6:$L6)-COLUMN($C6)+1),COLUMNS($C15:C15))),"")} | D15 | {=IFERROR(INDEX($C6:$L6,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C6:$L6<>"",MATCH($C6:$L6,$C6:$L6,0)),COLUMN($C6:$L6)-COLUMN($C6)+1)),COLUMN($C6:$L6)-COLUMN($C6)+1),COLUMNS($C15:D15))),"")} | E15 | {=IFERROR(INDEX($C6:$L6,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C6:$L6<>"",MATCH($C6:$L6,$C6:$L6,0)),COLUMN($C6:$L6)-COLUMN($C6)+1)),COLUMN($C6:$L6)-COLUMN($C6)+1),COLUMNS($C15:E15))),"")} | F15 | {=IFERROR(INDEX($C6:$L6,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C6:$L6<>"",MATCH($C6:$L6,$C6:$L6,0)),COLUMN($C6:$L6)-COLUMN($C6)+1)),COLUMN($C6:$L6)-COLUMN($C6)+1),COLUMNS($C15:F15))),"")} | G15 | {=IFERROR(INDEX($C6:$L6,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C6:$L6<>"",MATCH($C6:$L6,$C6:$L6,0)),COLUMN($C6:$L6)-COLUMN($C6)+1)),COLUMN($C6:$L6)-COLUMN($C6)+1),COLUMNS($C15:G15))),"")} | C16 | {=IFERROR(INDEX($C7:$L7,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C7:$L7<>"",MATCH($C7:$L7,$C7:$L7,0)),COLUMN($C7:$L7)-COLUMN($C7)+1)),COLUMN($C7:$L7)-COLUMN($C7)+1),COLUMNS($C16:C16))),"")} | D16 | {=IFERROR(INDEX($C7:$L7,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C7:$L7<>"",MATCH($C7:$L7,$C7:$L7,0)),COLUMN($C7:$L7)-COLUMN($C7)+1)),COLUMN($C7:$L7)-COLUMN($C7)+1),COLUMNS($C16:D16))),"")} | E16 | {=IFERROR(INDEX($C7:$L7,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C7:$L7<>"",MATCH($C7:$L7,$C7:$L7,0)),COLUMN($C7:$L7)-COLUMN($C7)+1)),COLUMN($C7:$L7)-COLUMN($C7)+1),COLUMNS($C16:E16))),"")} | F16 | {=IFERROR(INDEX($C7:$L7,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C7:$L7<>"",MATCH($C7:$L7,$C7:$L7,0)),COLUMN($C7:$L7)-COLUMN($C7)+1)),COLUMN($C7:$L7)-COLUMN($C7)+1),COLUMNS($C16:F16))),"")} | G16 | {=IFERROR(INDEX($C7:$L7,SMALL(IF(TRANSPOSE(FREQUENCY(IF($C7:$L7<>"",MATCH($C7:$L7,$C7:$L7,0)),COLUMN($C7:$L7)-COLUMN($C7)+1)),COLUMN($C7:$L7)-COLUMN($C7)+1),COLUMNS($C16:G16))),"")} |
<TBODY>
</TBODY> |