List by Character matching

jalal

New Member
Joined
Aug 24, 2010
Messages
6
Hi! I'm a new member of this forum. Presently i tried to work on Bangladesh Stock Market Analysis n stuck in creating some list. Before going to the problem I've given my Table Structure below:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
<o:p></o:p>
Column 1: Industry<o:p></o:p>
Column 2: Company<o:p></o:p>
Column 3: Lot Size<o:p></o:p>
Column 4: Authorized Capital<o:p></o:p>
Column 5: Paid Up Capital<o:p></o:p>
<o:p></o:p>
Industry Company Lot Size Authorized Capital Paid-Up Capital<o:p></o:p>
Mutual Funds 1STBSRS 1 10000 5000<o:p></o:p>
Mutual Funds 1STICB 2 20000 8000<o:p></o:p>
Mutual Funds 1STPRIMFMF 3 30000 11000<o:p></o:p>
Mutual Funds 2NDICB 4 40000 14000<o:p></o:p>
Mutual Funds 3RDICB 5 50000 17000<o:p></o:p>
Mutual Funds 4THICB 6 60000 20000<o:p></o:p>
Mutual Funds 5THICB 7 70000 23000<o:p></o:p>
Mutual Funds 6THICB 8 80000 26000<o:p></o:p>
Mutual Funds 7THICB 9 90000 29000<o:p></o:p>
Mutual Funds 8THICB 10 100000 32000<o:p></o:p>
Bank ABBANK 11 110000 35000<o:p></o:p>
Pharmaceuticals & Chemicals ACI 12 120000 38000<o:p></o:p>
Pharmaceuticals & Chemicals ACIFORMULA 13 130000 41000<o:p></o:p>
Bond ACIZCBOND 14 140000 44000<o:p></o:p>
Engineering AFTABAUTO 15 150000 47000<o:p></o:p>
IT Sector AGNISYSL 16 160000 50000<o:p></o:p>
Insurance AGRANINS 17 170000 53000<o:p></o:p>
Mutual Funds AIMS1STMF 18 180000 56000<o:p></o:p>
Bank ALARABANK 20 200000 62000<o:p></o:p>
Textile AL-HAJTEX 19 190000 59000<o:p></o:p>
<o:p></o:p>
Now I need the below two list from this table:<o:p></o:p>
<o:p></o:p>
List 1: A list will be generated based on the instrument's initail character entered by someone<o:p></o:p>
<o:p></o:p>
<TABLE class=MsoNormalTable style="WIDTH: 326pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 0in 0in 0in" cellSpacing=0 cellPadding=0 width=435 border=0><TBODY><TR style="HEIGHT: 11.25pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes"><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 115pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt" width=153>Input instrument name<o:p></o:p>

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 0in; BACKGROUND: #fcd5b4; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 41pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 11.25pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" width=55>A<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 93pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=124>Input Cell<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=103></TD></TR></TBODY></TABLE>
<o:p></o:p>
Then all instruments starting with A will be displayed from the above table<o:p></o:p>
<o:p></o:p>
Company Lot Size Authorized Capital Paid-Up Capital<o:p></o:p>
ABBANK <o:p></o:p>
ACI <o:p></o:p>
ACIFORMULA <o:p></o:p>
ACIZCBOND <o:p></o:p>
AFTABAUTO <o:p></o:p>
AGNISYSL <o:p></o:p>
AGRANINS <o:p></o:p>
AIMS1STMF <o:p></o:p>
ALARABANK <o:p></o:p>
AL-HAJTEX <o:p></o:p>
ALLTEX <o:p></o:p>
ALPHATOBA <o:p></o:p>
<o:p></o:p>
List 2: A list will be generated based on the selecting industry name from a drop down box<o:p></o:p>
<o:p></o:p>
<TABLE class=MsoNormalTable style="WIDTH: 325pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 0in 0in 0in" cellSpacing=0 cellPadding=0 width=433 border=0><TBODY><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes"><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 74pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt" width=99>Industry Name<o:p></o:p>

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 0in; BACKGROUND: #fde9d9; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 81pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" width=108>IT Sector<o:p></o:p>

</TD><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 170pt; PADDING-TOP: 0in; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=227>Input Field (Drop-down)<o:p></o:p>

</TD></TR></TBODY></TABLE>
<o:p></o:p>
Then all the instruments under IT Sector will be displayed.<o:p></o:p>
<o:p></o:p>
<TABLE class=MsoNormalTable style="WIDTH: 325pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 0in 0in 0in" cellSpacing=0 cellPadding=0 width=433 border=0><TBODY><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 74pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt" width=99>Company<o:p></o:p>

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 81pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" width=108>Lot Size<o:p></o:p>

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 93pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" width=124>Authorized Capital<o:p></o:p>

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 77pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" width=103>Paid-Up Capital<o:p></o:p>

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 1"><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt">AGNISYSL<o:p></o:p>

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt"><o:p></o:p>

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 2"><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt">BDCOM<o:p></o:p>

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt"><o:p></o:p>

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 3"><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt">DAFODILCOM<o:p></o:p>

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt"><o:p></o:p>

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 4"><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt">INTECH<o:p></o:p>

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt"><o:p></o:p>

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 5; mso-yfti-lastrow: yes"><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt">ISNLTD<o:p></o:p>

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt"><o:p></o:p>

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #ece9d8; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt"><o:p></o:p>

</TD></TR></TBODY></TABLE>
<o:p></o:p>
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Let A1:E21 house the sample of data you posted, the headers included.

<TABLE style="WIDTH: 297pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=398><COLGROUP><COL style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3328" width=94><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 97pt; mso-width-source: userset; mso-width-alt: 4608" width=130><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3896" width=110><TBODY><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 70pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" id=td_post_2421303 class=xl66 height=19 width=94>Company</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=64>Lot Size</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 97pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=130>Authorized Capital</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 82pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=110>Paid Up Capital</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>1STBSRS</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>10000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>5000</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>1STICB</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>20000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>8000</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>1STPRIMFMF</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>30000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>11000</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>2NDICB</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>40000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>14000</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>3RDICB</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>50000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>17000</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>4THICB</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>60000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>20000</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>5THICB</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>70000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>23000</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>6THICB</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>8</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>80000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>26000</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>7THICB</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>90000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>29000</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>8THICB</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>100000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>32000</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>ABBANK</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>110000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>35000</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>ACI</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>120000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>38000</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>ACIFORMULA</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>13</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>130000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>41000</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>ACIZCBOND</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>14</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>140000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>44000</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>AFTABAUTO</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>15</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>150000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>47000</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>AGNISYSL</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>16</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>160000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>50000</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>AGRANINS</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>17</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>170000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>53000</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>AIMS1STMF</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>18</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>180000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>56000</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>ALARABANK</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>20</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>200000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>62000</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>AL-HAJTEX</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>19</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>190000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>59000</TD></TR></TBODY></TABLE>
Processing takes place in H:L...

<TABLE style="WIDTH: 469pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=625><COLGROUP><COL style="WIDTH: 154pt; mso-width-source: userset; mso-width-alt: 7310" width=206><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3043" width=86><COL style="WIDTH: 95pt; mso-width-source: userset; mso-width-alt: 4494" width=126><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3868" width=109><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3498" width=98><TBODY><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 154pt; HEIGHT: 14.4pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" id=td_post_2421303 class=xl68 height=19 width=206>Instrument Name Begins With</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #fcd5b4; WIDTH: 64pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=86>A</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 95pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=126 align=right>10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 82pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=109></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 74pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=98></TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=19>Company</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>Lot Size</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>Authorized Capital</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>Paid Up Capital</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>Idx</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>ABBANK</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>110000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>35000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>11</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>ACI</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>120000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>38000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>12</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>ACIFORMULA</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>13</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>130000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>41000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>13</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>ACIZCBOND</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>14</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>140000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>44000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>14</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>AFTABAUTO</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>15</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>150000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>47000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>15</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>AGNISYSL</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>16</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>160000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>50000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>16</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>AGRANINS</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>17</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>170000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>53000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>17</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>AIMS1STMF</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>18</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>180000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>56000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>18</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>ALARABANK</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>20</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>200000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>62000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>19</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19>AL-HAJTEX</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>19</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>190000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>59000</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>20</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=19></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65></TD></TR></TBODY></TABLE>

I1: A

J1, just enter:
Code:
=COUNTIF(B2:B21,I1&"*")

H3, just enter, copy across to K3, and then down:
Code:
=IF(N($L3),INDEX($A$2:$E$21,$L3,MATCH(H$2,$A$1:$E$1,0)),"")

L3, control+shift+enter, not just enter, and copy down:
Code:
=IF(ROWS($L$3:L3)<=$J$1,SMALL(IF(LEFT($B$2:$B$21,1)=$I$1,
    ROW($B$2:$B$21)-ROW($B$2)+1),ROWS($L$3:L3)),"")

I trust you can model the processing for the second list after the above scheme.
 
Last edited:
Upvote 0
Thank you very much brother. I'll let you know after trying the model.
Thanx agin really.
 
Upvote 0
Hi Brother,
Thnx for your support. Bt after giving all the inputs i received the below error. Hope you will fix the problem again. Thnx really brother:
<TABLE style="WIDTH: 546pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=724 border=0><COLGROUP><COL style="WIDTH: 16pt; mso-width-source: userset; mso-width-alt: 768" width=21><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852" width=78><COL style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1792" width=49><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" width=77><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2998" width=82><COL style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 804" width=22><COL style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 841" width=23><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" span=2 width=86><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3181" width=87><COL style="WIDTH: 22pt; mso-width-source: userset; mso-width-alt: 1060" width=29><TBODY><TR style="HEIGHT: 22.5pt" height=30><TD class=xl65 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8 0.5pt solid; BORDER-LEFT: #d8d8d8 0.5pt solid; WIDTH: 16pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; HEIGHT: 22.5pt; BACKGROUND-COLOR: transparent" width=21 height=30>SL</TD><TD class=xl68 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8 0.5pt solid; BORDER-LEFT: #d8d8d8; WIDTH: 59pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=78>Company

</TD><TD class=xl68 id=td_post_2421303 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8 0.5pt solid; BORDER-LEFT: #d8d8d8; WIDTH: 37pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=49>Lot Size</TD><TD class=xl68 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8 0.5pt solid; BORDER-LEFT: #d8d8d8; WIDTH: 58pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=77>Authorized Capital</TD><TD class=xl68 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8 0.5pt solid; BORDER-LEFT: #d8d8d8; WIDTH: 62pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=82>Paid Up Capital</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8 0.5pt solid; BORDER-LEFT: #d8d8d8; WIDTH: 17pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" width=22> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8 0.5pt solid; BORDER-LEFT: #d8d8d8; WIDTH: 17pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" width=23> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8 0.5pt solid; BORDER-LEFT: #d8d8d8; WIDTH: 63pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" width=84> </TD><TD class=xl66 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8 0.5pt solid; BORDER-LEFT: #d8d8d8; WIDTH: 65pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" width=86>A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8 0.5pt solid; BORDER-LEFT: #d8d8d8; WIDTH: 65pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=right width=86>5</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8 0.5pt solid; BORDER-LEFT: #d8d8d8; WIDTH: 65pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" width=87> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8 0.5pt solid; BORDER-LEFT: #d8d8d8; WIDTH: 22pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" width=29> </TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl65 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8 0.5pt solid; BORDER-BOTTOM: #d8d8d8 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" align=right height=15>1</TD><TD class=xl70 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 59pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=78>1STBSRS</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 37pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=49>1</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 58pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=77>10000</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 62pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=82>5000</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl65 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8 0.5pt solid; BORDER-BOTTOM: #d8d8d8 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" align=right height=15>2</TD><TD class=xl70 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 59pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=78>8THICB</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 37pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=49>10</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 58pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=77>100000</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 62pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=82>32000</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=middle>#N/A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=middle>#N/A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=middle>#N/A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=middle>#N/A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=right>3</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl65 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8 0.5pt solid; BORDER-BOTTOM: #d8d8d8 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" align=right height=15>3</TD><TD class=xl70 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 59pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=78>ABBANK</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 37pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=49>11</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 58pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=77>110000</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 62pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=82>35000</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=middle>#N/A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=middle>#N/A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=middle>#N/A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=middle>#N/A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=right>4</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl65 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8 0.5pt solid; BORDER-BOTTOM: #d8d8d8 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" align=right height=15>4</TD><TD class=xl70 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 59pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=78>ACI</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 37pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=49>12</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 58pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=77>120000</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 62pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=82>38000</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=middle>#N/A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=middle>#N/A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=middle>#N/A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=middle>#N/A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=right>5</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl65 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8 0.5pt solid; BORDER-BOTTOM: #d8d8d8 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" align=right height=15>5</TD><TD class=xl70 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 59pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=78>ACIFORMULA</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 37pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=49>13</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 58pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=77>130000</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 62pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=82>41000</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=middle>#N/A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=middle>#N/A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=middle>#N/A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=middle>#N/A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=right>6</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl65 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8 0.5pt solid; BORDER-BOTTOM: #d8d8d8 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" align=right height=15>6</TD><TD class=xl70 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 59pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=78>ALARABANK</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 37pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=49>20</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 58pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=77>200000</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 62pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=82>62000</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=middle>#N/A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=middle>#N/A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=middle>#N/A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=middle>#N/A</TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent" align=right>7</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl65 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8 0.5pt solid; BORDER-BOTTOM: #d8d8d8 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" align=right height=15>7</TD><TD class=xl70 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 59pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=78>AL-HAJTEX</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 37pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=49>19</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 58pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=77>190000</TD><TD class=xl71 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; WIDTH: 62pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #efefef" width=82>59000

</TD><TD class=xl69 id=td_post_2421323 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl69 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8; BORDER-LEFT: #d8d8d8; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD></TR><TR style="HEIGHT: 42.75pt; mso-height-source: userset" height=57><TD class=xl73 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8 0.5pt solid; BORDER-LEFT: #d8d8d8 0.5pt solid; WIDTH: 232pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; HEIGHT: 42.75pt; BACKGROUND-COLOR: #bfbfbf" width=307 colSpan=5 height=57>formula for H3 n copied to K3'
=IF(N($L3),INDEX($A$2:$E$21,$L3,MATCH(H$2,$A$1:$E$1,0)),"")
</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl72 style="BORDER-RIGHT: #d8d8d8 0.5pt solid; BORDER-TOP: #d8d8d8 0.5pt solid; BORDER-LEFT: #d8d8d8 0.5pt solid; WIDTH: 258pt; BORDER-BOTTOM: #d8d8d8 0.5pt solid; BACKGROUND-COLOR: #d8d8d8" width=343 colSpan=4>formula for L3'
=IF(ROWS($L$3:L3)<=$J$1,SMALL(IF(LEFT($B$2:$B$21,1)=$I$1,
ROW($B$2:$B$21)-ROW($B$2)+1),ROWS($L$3:L3)),"")
</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>
 
Last edited:
Upvote 0
Thank you so much brother. I solved the problem by putting the header column.

Now when I try to input first 2 character then it shows #NUM! error from H3 to L3 cells.

Sorry for repeating bothering brother. If possible and you don't have any problem please provide your email through Private Message.

Best Regards,
-Jalal
 
Last edited:
Upvote 0
Thank you so much brother. I solved the problem by putting the header column.

Now when I try to input first 2 character then it shows #NUM! error from H3 to L3 cells.

Sorry for repeating bothering brother. If possible and you don't have any problem please provide your email through Private Message.

Best Regards,
-Jalal
 
Upvote 0
Thank you so much brother. I solved the problem by putting the header column.

Now when I try to input first 2 character then it shows #NUM! error from H3 to L3 cells.

Sorry for repeating bothering brother. If possible and you don't have any problem please provide your email through Private Message.

Best Regards,
-Jalal

Try to repeat the logic of the set up...

If you doi it correctly, you only need to adjust the LEFT($B$2:$B$21,1) bit, where 1 becomes 2.
 
Upvote 0
Thnx brother proble is smoothly solved. I add another formula to find LEN in K1 cell of I1 cell and re-write the formula

=IF(ROWS($L$3:L3)<=$J$1,SMALL(IF(LEFT($B$2:$B$21,$K$1)=$I$1,
ROW($B$2:$B$21)-ROW($B$2)+1),ROWS($L$3:L3)),"")
 
Upvote 0
Thnx brother proble is smoothly solved. I add another formula to find LEN in K1 cell of I1 cell and re-write the formula

=IF(ROWS($L$3:L3)<=$J$1,SMALL(IF(LEFT($B$2:$B$21,$K$1)=$I$1,
ROW($B$2:$B$21)-ROW($B$2)+1),ROWS($L$3:L3)),"")

Good idea...
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,998
Members
448,541
Latest member
iparraguirre89

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
Back
Top