I finally figured out how to use Jeanie. I hope this may be helpful
Mike Szczesny
Sheet1
<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD>a</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">100</TD><TD> </TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">20</TD><TD style="TEXT-ALIGN: right">30</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD>a</TD><TD style="TEXT-ALIGN: right">20</TD><TD style="TEXT-ALIGN: right">200</TD><TD>a</TD><TD style="TEXT-ALIGN: right">100</TD><TD style="TEXT-ALIGN: right">200</TD><TD style="TEXT-ALIGN: right">300</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD>a</TD><TD style="TEXT-ALIGN: right">30</TD><TD style="TEXT-ALIGN: right">300</TD><TD>b</TD><TD style="TEXT-ALIGN: right">450</TD><TD style="TEXT-ALIGN: right">500</TD><TD style="TEXT-ALIGN: right">550</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD>b</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">450</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD>b</TD><TD style="TEXT-ALIGN: right">20</TD><TD style="TEXT-ALIGN: right">500</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD>b</TD><TD style="TEXT-ALIGN: right">30</TD><TD style="TEXT-ALIGN: right">550</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>G5</TD><TD>{=INDEX($D$5:$D$10,SMALL(IF(FREQUENCY($D$5:$D$10,$D$5:$D$10)>0,ROW($D$5:$D$10)-ROW($D$5)+1),COLUMNS($G$5:G5)))}</TD></TR><TR><TD>H5</TD><TD>{=INDEX($D$5:$D$10,SMALL(IF(FREQUENCY($D$5:$D$10,$D$5:$D$10)>0,ROW($D$5:$D$10)-ROW($D$5)+1),COLUMNS($G$5:H5)))}</TD></TR><TR><TD>I5</TD><TD>{=INDEX($D$5:$D$10,SMALL(IF(FREQUENCY($D$5:$D$10,$D$5:$D$10)>0,ROW($D$5:$D$10)-ROW($D$5)+1),COLUMNS($G$5:I5)))}</TD></TR><TR><TD>F6</TD><TD>{=INDEX($C$5:$C$10,SMALL(IF(FREQUENCY(IF($C$5:$C$10<>"",MATCH($C$5:$C$10,$C$5:$C$10,0)),ROW($C$5:$C$10)-ROW($C$5)+1),ROW($C$5:$C$10)-ROW($C$5)+1),ROWS($F$6:F6)))}</TD></TR><TR><TD>G6</TD><TD>{=INDEX($E$5:$E$10,SMALL(IF($C$5:$C$10=$F6,ROW($E$5:$E$10)-ROW($E$5)+1),COLUMNS($G$6:G6)))}</TD></TR><TR><TD>H6</TD><TD>{=INDEX($E$5:$E$10,SMALL(IF($C$5:$C$10=$F6,ROW($E$5:$E$10)-ROW($E$5)+1),COLUMNS($G$6:H6)))}</TD></TR><TR><TD>I6</TD><TD>{=INDEX($E$5:$E$10,SMALL(IF($C$5:$C$10=$F6,ROW($E$5:$E$10)-ROW($E$5)+1),COLUMNS($G$6:I6)))}</TD></TR><TR><TD>F7</TD><TD>{=INDEX($C$5:$C$10,SMALL(IF(FREQUENCY(IF($C$5:$C$10<>"",MATCH($C$5:$C$10,$C$5:$C$10,0)),ROW($C$5:$C$10)-ROW($C$5)+1),ROW($C$5:$C$10)-ROW($C$5)+1),ROWS($F$6:F7)))}</TD></TR><TR><TD>G7</TD><TD>{=INDEX($E$5:$E$10,SMALL(IF($C$5:$C$10=$F7,ROW($E$5:$E$10)-ROW($E$5)+1),COLUMNS($G$6:G7)))}</TD></TR><TR><TD>H7</TD><TD>{=INDEX($E$5:$E$10,SMALL(IF($C$5:$C$10=$F7,ROW($E$5:$E$10)-ROW($E$5)+1),COLUMNS($G$6:H7)))}</TD></TR><TR><TD>I7</TD><TD>{=INDEX($E$5:$E$10,SMALL(IF($C$5:$C$10=$F7,ROW($E$5:$E$10)-ROW($E$5)+1),COLUMNS($G$6:I7)))}</TD></TR></TBODY></TABLE></TD></TR><TR><TD>Formula Array:
Produce enclosing { } by entering
formula with CTRL+SHIFT+ENTER!</TD></TR></TBODY></TABLE>