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>
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,192
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:

jalal

New Member
Joined
Aug 24, 2010
Messages
6
Thank you very much brother. I'll let you know after trying the model.
Thanx agin really.
 

jalal

New Member
Joined
Aug 24, 2010
Messages
6
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:

jalal

New Member
Joined
Aug 24, 2010
Messages
6
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:

jalal

New Member
Joined
Aug 24, 2010
Messages
6

ADVERTISEMENT

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
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,192
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.
 

jalal

New Member
Joined
Aug 24, 2010
Messages
6
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)),"")
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,192
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...
 

Watch MrExcel Video

Forum statistics

Threads
1,108,732
Messages
5,524,512
Members
409,583
Latest member
RedHelp

This Week's Hot Topics

Top