Select unique concatenated valued based on a crititerion

Joined
Aug 28, 2009
Messages
9
I have data in excel that looks like the below…there are additional columns but for this question I will use the abbreviate one below
<TABLE style="MARGIN: auto auto auto 4.65pt; WIDTH: 345.15pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 5.4pt 0in 5.4pt" class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0 width=460><TBODY><TR style="HEIGHT: 15pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap>Division<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48.15pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap>Dept<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 1.05in; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=101 noWrap>Name<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 29.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=39 noWrap>month<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap>Qtr<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap>Year<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap>counts<o:p></o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 1"><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: silver 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: silver 1pt solid; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>12345<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48.15pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: silver 1pt solid; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>ZZ815ZZ0<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 1.05in; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: silver 1pt solid; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=101 noWrap>Daffey Duck 1<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 29.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: silver 1pt solid; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=39 noWrap>200601<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: silver 1pt solid; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2006Q1<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: silver 1pt solid; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2006<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: silver 1pt solid; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-top-alt: solid silver .5pt; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>
3053<o:p></o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 2"><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: silver 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>12345<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48.15pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>ZZ815ZZ0<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 1.05in; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=101 noWrap>Daffey Duck 1<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 29.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=39 noWrap>200601<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2006Q1<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2006<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>
3053<o:p></o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 3"><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: silver 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>12345<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48.15pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>ZZ881643<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 1.05in; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=101 noWrap>Daffey Duck 2<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 29.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=39 noWrap>200601<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2006Q1<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2006<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>
276<o:p></o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 4"><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: silver 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>12345<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48.15pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>ZZ881643<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 1.05in; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=101 noWrap>Daffey Duck 2<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 29.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=39 noWrap>200701<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2007Q1<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2007<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>
493<o:p></o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 5"><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: silver 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>12345<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48.15pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>ZZ885590<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 1.05in; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=101 noWrap>Daffey Duck 3<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 29.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=39 noWrap>200601<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2006Q1<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2006<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>
83350<o:p></o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 6"><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: silver 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>12345<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48.15pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>ZZ885590<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 1.05in; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=101 noWrap>Daffey Duck 3<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 29.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=39 noWrap>200601<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2006Q1<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2006<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>
83350<o:p></o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 7"><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: silver 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>45678<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48.15pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>ZZ885590<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 1.05in; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=101 noWrap>Aladin <o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 29.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=39 noWrap>200601<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2006Q1<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2006<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>
83350<o:p></o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 8"><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: silver 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>45678<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48.15pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>ZZ885598<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 1.05in; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=101 noWrap>Aladin2<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 29.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=39 noWrap>200701<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2007Q1<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2007<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>
86348<o:p></o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 9"><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: silver 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>45679<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48.15pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>ZZ885590<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 1.05in; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=101 noWrap>Aladin<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 29.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=39 noWrap>200701<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2007Q1<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2007<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>
86348<o:p></o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 10"><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: silver 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>78910<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48.15pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>ZZ885591<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 1.05in; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=101 noWrap>Homer Simpson<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 29.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=39 noWrap>200601<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2006Q1<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2006<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>
44353<o:p></o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 11"><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: silver 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>78910<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48.15pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>ZZ885591<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 1.05in; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=101 noWrap>Homer Simpson<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 29.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=39 noWrap>200601<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2006Q1<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2006<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>
44353<o:p></o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 12"><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: silver 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>78910<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48.15pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>ZZ8855W<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 1.05in; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=101 noWrap>Homer Simpson2<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 29.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=39 noWrap>200601<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2006Q1<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2006<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>
44353<o:p></o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 13"><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: silver 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>111213<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48.15pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>ZZ88559S<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 1.05in; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=101 noWrap>Barney Rubbles<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 29.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=39 noWrap>200701<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2007Q1<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2007<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>
45807<o:p></o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 14"><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: silver 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>111213<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48.15pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>ZZ88559S<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 1.05in; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=101 noWrap>Barney Rubbles<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 29.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=39 noWrap>200701<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2007Q1<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2007<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>
45807<o:p></o:p>
</TD></TR><TR style="HEIGHT: 15pt; mso-yfti-irow: 15; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: silver 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>12345<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48.15pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>ZZ88559J<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 1.05in; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=101 noWrap>Daffey Duck<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 29.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=39 noWrap>200701<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2007Q1<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>2007<o:p></o:p>
</TD><TD style="BORDER-BOTTOM: silver 1pt solid; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: silver 1pt solid; PADDING-TOP: 0in; mso-border-bottom-alt: solid silver .5pt; mso-border-right-alt: solid silver .5pt" vAlign=bottom width=64 noWrap>
45807<o:p></o:p>
</TD></TR></TBODY></TABLE>
<o:p> </o:p>
I need a formula that when I give it a criterion from the first column it will return unique concatenated values of column B and C… so if the criterion is 12345 it will return a list like:
<o:p> </o:p>
ZZ815ZZ0 -Daffey Duck1
ZZ881643 - Daffey Duck2<o:p></o:p>
ZZ885590 - Daffey Duck3
ZZ88559J - Daffey Duck
<o:p> </o:p>
If the criterion is 45678 it will return a list like:
ZZ885590 - Aladin <o:p></o:p>
ZZ885598 - Aladin2
<o:p> </o:p>
If the criterion is 78910 it will return a list like:
ZZ885591 - Homer Simpson<o:p></o:p>
ZZ8855W - Homer Simpson2
<o:p> </o:p>
If the criterion is 111213 it will return a list like:
ZZ88559S - Barney Rubbles
<o:p> </o:p>
Need to use formulas as this is going into a reporting tool where the data will change from time to time and I need it to dynamically change as the data changes. I tried several formulas but I am only able to get the first set to work…for the others it either return the first set or it repeats the first value
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

dscg

Active Member
Joined
Apr 28, 2004
Messages
367
Seems long to me, but this seems to work:

Let I1 be the cell that lookup number is entered into:

I3: =COUNTIF(A2:A16,I1)

I4: =IF(ROWS($I$3:I3)<=$I$2,INDEX($A$2:$B$16,SMALL(IF($A$2:$A$16=$I$1,ROW($A$2:$A$16)-ROW($A$2)+1),ROWS(B$3:$I3)),2),"") & " " & IF(ROWS($I$3:I3)<=$I$2,INDEX($A$2:$C$16,SMALL(IF($A$2:$A$16=$I$1,ROW($A$2:$A$16)-ROW($A$2)+1),ROWS(B$3:$I3)),3),"")
confirmed with ctrl + shift + enter, then copied down
Excel Workbook
ABCDEFGHI
1DivisionDeptNamemonthQtrYearcounts12345
212345ZZ815ZZ0Daffey Duck 12006012006Q1200630537
312345ZZ815ZZ0Daffey Duck 12006012006Q120063053ZZ815ZZ0 Daffey Duck 1
412345ZZ881643Daffey Duck 22006012006Q12006276ZZ815ZZ0 Daffey Duck 1
512345ZZ881643Daffey Duck 22007012007Q12007493ZZ881643 Daffey Duck 2
612345ZZ885590Daffey Duck 32006012006Q1200683350ZZ881643 Daffey Duck 2
712345ZZ885590Daffey Duck 32006012006Q1200683350ZZ885590 Daffey Duck 3
845678ZZ885590Aladin2006012006Q1200683350ZZ885590 Daffey Duck 3
945678ZZ885598Aladin22007012007Q1200786348ZZ88559J Daffey Duck
1045679ZZ885590Aladin2007012007Q1200786348
1178910ZZ885591Homer Simpson2006012006Q1200644353
1278910ZZ885591Homer Simpson2006012006Q1200644353
1378910ZZ8855WHomer Simpson22006012006Q1200644353
14111213ZZ88559SBarney Rubbles2007012007Q1200745807
15111213ZZ88559SBarney Rubbles2007012007Q1200745807
1612345ZZ88559JDaffey Duck2007012007Q1200745807
Sheet1
Excel 2003
Cell Formulas
RangeFormula
I2=COUNTIF(A2:A16,I1)
#VALUE!
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

And speaking of Aladin, I have to give credit to him for these amazing formulas. This is one his applied and perhaps he knows a better way.

http://www.mrexcel.com/forum/showthread.php?t=231882
 

shift-del

Well-known Member
Joined
Aug 28, 2009
Messages
516
Office Version
  1. 365
Platform
  1. Windows
Hello

What about this?
Copy formulas down from row 3.
<table valign="middle" colspan="13" style="font-family: Calibri; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 11px; font-weight: normal; font-style: normal;" border="1" cellpadding="2" cellspacing="0"><colgroup><col width="28"><col width="42"><col width="54"><col width="91"><col width="41"><col width="44"><col width="29"><col width="36"><col width="60"><col width="42"><col width="53"><col width="73"><col width="120"></colgroup><tbody><tr style="background-color: rgb(250, 250, 250);"><td colspan="13" align="middle">Arbeitsblatt mit dem Namen 'Tabelle1'</td></tr><tr style="background-color: rgb(202, 202, 202);"><td>
</td><td align="middle">A</td><td align="middle">B</td><td align="middle">C</td><td align="middle">D</td><td align="middle">E</td><td align="middle">F</td><td align="middle">G</td><td align="middle">H</td><td align="middle">I</td><td align="middle">J</td><td align="middle">K</td><td align="middle">L</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">1</td><td align="left">Division</td><td align="left">Dept</td><td align="left">Name</td><td align="left">month</td><td align="left">Qtr</td><td align="left">Year</td><td align="left">counts</td><td align="right">
</td><td align="left">Division</td><td align="right">
</td><td align="right">
</td><td align="right">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">2</td><td style="font-family: Arial;" align="right">12345</td><td style="font-family: Arial;" align="left">ZZ815ZZ0</td><td style="font-family: Arial;" align="left">Daffey Duck 1</td><td style="font-family: Arial;" align="right">200601</td><td style="font-family: Arial;" align="left">2006Q1</td><td style="font-family: Arial;" align="right">2006</td><td style="font-family: Arial;" align="right">3053</td><td align="right">
</td><td style="font-family: Arial;" align="right">12345</td><td style="font-size: 12px;" align="left">ZZ815ZZ0</td><td style="font-size: 12px;" align="left">Daffey Duck 1</td><td align="left">ZZ815ZZ0 - Daffey Duck 1</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">3</td><td style="font-family: Arial;" align="right">12345</td><td style="font-family: Arial;" align="left">ZZ815ZZ0</td><td style="font-family: Arial;" align="left">Daffey Duck 1</td><td style="font-family: Arial;" align="right">200601</td><td style="font-family: Arial;" align="left">2006Q1</td><td style="font-family: Arial;" align="right">2006</td><td style="font-family: Arial;" align="right">3053</td><td align="right">
</td><td align="right">
</td><td style="font-size: 12px;" align="left">ZZ881643</td><td style="font-size: 12px;" align="left">Daffey Duck 2</td><td align="left">ZZ881643 - Daffey Duck 2</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">4</td><td style="font-family: Arial;" align="right">12345</td><td style="font-family: Arial;" align="left">ZZ881643</td><td style="font-family: Arial;" align="left">Daffey Duck 2</td><td style="font-family: Arial;" align="right">200601</td><td style="font-family: Arial;" align="left">2006Q1</td><td style="font-family: Arial;" align="right">2006</td><td style="font-family: Arial;" align="right">276</td><td align="right">
</td><td align="right">
</td><td style="font-size: 12px;" align="left">ZZ885590</td><td style="font-size: 12px;" align="left">Daffey Duck 3</td><td align="left">ZZ885590 - Daffey Duck 3</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">5</td><td style="font-family: Arial;" align="right">12345</td><td style="font-family: Arial;" align="left">ZZ881643</td><td style="font-family: Arial;" align="left">Daffey Duck 2</td><td style="font-family: Arial;" align="right">200701</td><td style="font-family: Arial;" align="left">2007Q1</td><td style="font-family: Arial;" align="right">2007</td><td style="font-family: Arial;" align="right">493</td><td align="right">
</td><td align="right">
</td><td style="font-size: 12px;" align="left">ZZ88559J</td><td style="font-size: 12px;" align="left">Daffey Duck</td><td align="left">ZZ88559J - Daffey Duck</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">6</td><td style="font-family: Arial;" align="right">12345</td><td style="font-family: Arial;" align="left">ZZ885590</td><td style="font-family: Arial;" align="left">Daffey Duck 3</td><td style="font-family: Arial;" align="right">200601</td><td style="font-family: Arial;" align="left">2006Q1</td><td style="font-family: Arial;" align="right">2006</td><td style="font-family: Arial;" align="right">83350</td><td align="right">
</td><td align="right">
</td><td style="font-size: 12px;" align="left">
</td><td style="font-size: 12px;" align="left">
</td><td align="left">-</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">7</td><td style="font-family: Arial;" align="right">12345</td><td style="font-family: Arial;" align="left">ZZ885590</td><td style="font-family: Arial;" align="left">Daffey Duck 3</td><td style="font-family: Arial;" align="right">200601</td><td style="font-family: Arial;" align="left">2006Q1</td><td style="font-family: Arial;" align="right">2006</td><td style="font-family: Arial;" align="right">83350</td><td align="right">
</td><td align="right">
</td><td style="font-size: 12px;" align="left">
</td><td style="font-size: 12px;" align="left">
</td><td align="left">-</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">8</td><td style="font-family: Arial;" align="right">45678</td><td style="font-family: Arial;" align="left">ZZ885590</td><td style="font-family: Arial;" align="left">Aladin</td><td style="font-family: Arial;" align="right">200601</td><td style="font-family: Arial;" align="left">2006Q1</td><td style="font-family: Arial;" align="right">2006</td><td style="font-family: Arial;" align="right">83350</td><td align="right">
</td><td align="right">
</td><td style="font-size: 12px;" align="left">
</td><td style="font-size: 12px;" align="left">
</td><td align="left">-</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">9</td><td style="font-family: Arial;" align="right">45678</td><td style="font-family: Arial;" align="left">ZZ885598</td><td style="font-family: Arial;" align="left">Aladin2</td><td style="font-family: Arial;" align="right">200701</td><td style="font-family: Arial;" align="left">2007Q1</td><td style="font-family: Arial;" align="right">2007</td><td style="font-family: Arial;" align="right">86348</td><td align="right">
</td><td align="right">
</td><td style="font-size: 12px;" align="left">
</td><td style="font-size: 12px;" align="left">
</td><td align="left">-</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">10</td><td style="font-family: Arial;" align="right">45679</td><td style="font-family: Arial;" align="left">ZZ885590</td><td style="font-family: Arial;" align="left">Aladin</td><td style="font-family: Arial;" align="right">200701</td><td style="font-family: Arial;" align="left">2007Q1</td><td style="font-family: Arial;" align="right">2007</td><td style="font-family: Arial;" align="right">86348</td><td align="right">
</td><td align="right">
</td><td style="font-size: 12px;" align="left">
</td><td style="font-size: 12px;" align="left">
</td><td align="left">-</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">11</td><td style="font-family: Arial;" align="right">78910</td><td style="font-family: Arial;" align="left">ZZ885591</td><td style="font-family: Arial;" align="left">Homer Simpson</td><td style="font-family: Arial;" align="right">200601</td><td style="font-family: Arial;" align="left">2006Q1</td><td style="font-family: Arial;" align="right">2006</td><td style="font-family: Arial;" align="right">44353</td><td align="right">
</td><td align="right">
</td><td style="font-size: 12px;" align="left">
</td><td style="font-size: 12px;" align="left">
</td><td align="left">-</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">12</td><td style="font-family: Arial;" align="right">78910</td><td style="font-family: Arial;" align="left">ZZ885591</td><td style="font-family: Arial;" align="left">Homer Simpson</td><td style="font-family: Arial;" align="right">200601</td><td style="font-family: Arial;" align="left">2006Q1</td><td style="font-family: Arial;" align="right">2006</td><td style="font-family: Arial;" align="right">44353</td><td align="right">
</td><td align="right">
</td><td style="font-size: 12px;" align="left">
</td><td style="font-size: 12px;" align="left">
</td><td align="left">-</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">13</td><td style="font-family: Arial;" align="right">78910</td><td style="font-family: Arial;" align="left">ZZ8855W</td><td style="font-family: Arial;" align="left">Homer Simpson2</td><td style="font-family: Arial;" align="right">200601</td><td style="font-family: Arial;" align="left">2006Q1</td><td style="font-family: Arial;" align="right">2006</td><td style="font-family: Arial;" align="right">44353</td><td align="right">
</td><td align="right">
</td><td style="font-size: 12px;" align="left">
</td><td style="font-size: 12px;" align="left">
</td><td align="left">-</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">14</td><td style="font-family: Arial;" align="right">111213</td><td style="font-family: Arial;" align="left">ZZ88559S</td><td style="font-family: Arial;" align="left">Barney Rubbles</td><td style="font-family: Arial;" align="right">200701</td><td style="font-family: Arial;" align="left">2007Q1</td><td style="font-family: Arial;" align="right">2007</td><td style="font-family: Arial;" align="right">45807</td><td align="right">
</td><td align="right">
</td><td style="font-size: 12px;" align="left">
</td><td style="font-size: 12px;" align="left">
</td><td align="left">-</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">15</td><td style="font-family: Arial;" align="right">111213</td><td style="font-family: Arial;" align="left">ZZ88559S</td><td style="font-family: Arial;" align="left">Barney Rubbles</td><td style="font-family: Arial;" align="right">200701</td><td style="font-family: Arial;" align="left">2007Q1</td><td style="font-family: Arial;" align="right">2007</td><td style="font-family: Arial;" align="right">45807</td><td align="right">
</td><td align="right">
</td><td style="font-size: 12px;" align="left">
</td><td style="font-size: 12px;" align="left">
</td><td align="left">-</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">16</td><td style="font-family: Arial;" align="right">12345</td><td style="font-family: Arial;" align="left">ZZ88559J</td><td style="font-family: Arial;" align="left">Daffey Duck</td><td style="font-family: Arial;" align="right">200701</td><td style="font-family: Arial;" align="left">2007Q1</td><td style="font-family: Arial;" align="right">2007</td><td style="font-family: Arial;" align="right">45807</td><td align="right">
</td><td align="right">
</td><td style="font-size: 12px;" align="left">
</td><td style="font-size: 12px;" align="left">
</td><td align="left">-</td></tr></tbody></table>
<table valign="middle" colspan="2" style="table-layout: auto; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri; font-size: 10px;" border="3" cellpadding="2" cellspacing="0"><colgroup><col width="40"><col></colgroup><tbody><tr style="background-color: rgb(238, 170, 170);"><td>Zelle</td><td>Formel</td></tr><tr><td>J2</td><td>=INDEX(B:B,MATCH($I$2,$A:$A,))</td></tr><tr><td>K2</td><td>=INDEX(C:C,MATCH($I$2,$A:$A,))</td></tr><tr><td>L2</td><td>=J2&" - "&K2</td></tr><tr><td>J3</td><td>{=IF(MAX(ISNA(MATCH(B$2:B$16,J$2:J2,))*($A$2:$A$16=$I$2))=0,"",INDEX(B:B,MIN(IF(ISNA(MATCH(B$2:B$16,J$2:J2,))*($A$2:$A$16=$I$2),ROW($2:$16)))))}</td></tr><tr><td>K3</td><td>{=IF(MAX(ISNA(MATCH(C$2:C$16,K$2:K2,))*($A$2:$A$16=$I$2))=0,"",INDEX(C:C,MIN(IF(ISNA(MATCH(C$2:C$16,K$2:K2,))*($A$2:$A$16=$I$2),ROW($2:$16)))))}</td></tr><tr><td>L3</td><td>=J3&" - "&K3</td></tr></tbody></table><table style="font-family: Arial; font-size: 8pt; background-color: rgb(255, 255, 255);"><tbody><tr><td style="font-weight: bold;">Achtung, Matrixformel enthalten!</td></tr><tr><td>Die geschweiften Klammern{} werden nicht eingegeben.</td></tr><tr><td>Verlassen Sie den Zelleneditor mit Strg+Shift + Enter, statt Enter alleine.</td></tr></tbody></table>

PS: It's not my original idea. Credit goes to http://www.excelformeln.de
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
A1:G16 houses the data as shown in your exhibit, including the headers.

Define Rvec by means of Insert|Name|Define as referring to:

=ROW(Sheet1!$A$2:$A$16)-ROW(Sheet1!$A$2)+1

<TABLE style="WIDTH: 119pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=159 x:str><COLGROUP><COL style="WIDTH: 119pt; mso-width-source: userset; mso-width-alt: 5814" width=159><TBODY><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 119pt; HEIGHT: 12.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl22 height=17 width=159 align=right x:num>12345</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 1" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl22 height=17 align=right x:num>4</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 2" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl22 height=17>ZZ815ZZ0 - Daffey Duck 1</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 3" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl22 height=17>ZZ881643 - Daffey Duck 2</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 4" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl22 height=17>ZZ885590 - Daffey Duck 3</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 5" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl22 height=17>ZZ88559J - Daffey Duck</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 6" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl22 height=17 x:str=""> </TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 7" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl22 height=17> </TD></TR></TBODY></TABLE>

J1: 12345

which is a division condition of interest.

J2:

Control+shift+enter, not just enter...

=SUM(IF(FREQUENCY(IF(A2:A16=J1,MATCH("~"&B2:B16&" - "&C2:C16,B2:B16&" - "&C2:C16,0)),Rvec),1))

J3:

Control+shift+enter, not just enter...
Code:
=IF(ROWS($J$3:J3)<=$J$2,INDEX($B$2:$B$16&" - "&$C$2:$C$16,
    SMALL(IF(FREQUENCY(IF($A$2:$A$16=$J$1,
      MATCH("~"&$B$2:$B$16&" - "&$C$2:$C$16,
        $B$2:$B$16&" - "&$C$2:$C$16,0)),Rvec),Rvec),ROWS($J$3:J3))),"")
and copy down.
 
Joined
Aug 28, 2009
Messages
9
Thanks for all the quick and timely responses. I had acutally tried some like formulas but tried to force the row count into the formula and it ran rather slowly and retuned unexpected results as indicated before. All responses separated into a different cell which i never even considered doing. I believe all posetd should work as I know the reasom why it was not working was it was not accurately selecting the row counts for the subsequent records ...only did it correctly on the first. Thanks you all so much ...greatly appreciate the responses.... will post back and let you know how it worked out for me.:biggrin:
 
Joined
Aug 28, 2009
Messages
9
YEAH!!!
I used Aladin's formula and it worked...my my project is near complete ..just a few costmetic touches and i am done. I will save all the formulas for future use. Appreciated everyone contribution to this resolution.

Thank You, Thank you, Thank You!! ...I cannot thank everyone enough.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,366
Messages
5,601,204
Members
414,434
Latest member
Riyen

We've detected that you are using an adblocker.

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

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

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

Disable uBlock

Follow these easy steps to disable uBlock

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