Data Validation

M

Mohammed Abu Hawash

New Member
Joined
Dec 15, 2010
Messages
26
<TABLE style="WIDTH: 384pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=512><COLGROUP><COL style="WIDTH: 48pt" span=8 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 96pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: colspan" class=xl65 height=20 width=128 colSpan=2>Good Day All</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=64></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=64></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=64></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=64></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=64></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=64></TD></TR><TR style="HEIGHT: 15pt; mso-height-source: userset" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=20></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: colspan" class=xl65 height=20 colSpan=8>please I need to know whether my request highlighted with red font is possible to achieve.</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=20></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #b8cce4; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl66 height=20 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl67 width=64>A</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl67 width=64>B</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl67 width=64>C</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl67 width=64>D</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl67 width=64>E</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl67 width=64>F</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl67 width=64>G</TD></TR><TR style="HEIGHT: 105pt; mso-height-source: userset" height=140><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 105pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=140 width=64 align=right>1</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69 width=64>State1</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69 width=64>State1</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>State1</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl71 rowSpan=14 width=64>Drop Down List Only Showing The Cities "Reflecting In Column A" Of The Selected State In Cell E1 "E1 Has A Drop Down List Containing The Cities"</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>2</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City1</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69 width=64>State2</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>3</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City2</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69 width=64>State3</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>4</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City3</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69 width=64>State4</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>5</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69 width=64>State2</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69 width=64>State5</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>6</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City1</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69 width=64>State6</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>7</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City2</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69 width=64>State7</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>8</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City3</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>9</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69 width=64>State3</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>10</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City1</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>11</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City2</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>12</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City3</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>13</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69 width=64>State4</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>14</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City1</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>15</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City2</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>16</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City3</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>17</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69 width=64>State5</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>18</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City1</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>19</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City2</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>20</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City3</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>21</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69 width=64>State6</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>22</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City1</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>23</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City2</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>24</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City3</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>25</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69 width=64>State7</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>26</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City1</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>27</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City2</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 height=20 width=64 align=right>28</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64>City3</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70 width=64> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=20></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: colspan" class=xl65 height=20 colSpan=6>I'm Using Microshoft Office 2007 on Windows 7.</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=20></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: colspan" class=xl65 height=20 colSpan=4>Thanks for the anticipated help.</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=20></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: colspan" class=xl65 height=20 colSpan=2>Kind Regards,</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: colspan" class=xl65 height=20 colSpan=3>Mohammed Abu Hawash</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR></TBODY></TABLE>
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Sort by date Sort by votes
If you highlight A2:A4 and then give that range a name that matches the State1 name, then you can use an INDIRECT() function in E1's DV source to grab that name range as a list source:

Allow: List
Source: =INDIRECT(C1)

Create additional named ranges for each of the city groups naming them for state name.

You are not allowed to use two-word name as named ranged, so New Hampshire and New York would be a problem, you would need to name those ranges New_Hampshire and New-York, then adjust your INDIRECT() formula to make those same changes, like so:

Allow: List
Source: =INDIRECT(SUBSTITUTE(C1, " ", "_"))
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
623
smozgur
smozgur
C
  • Question Question
Macro Help - Transposing Some Data from Columns to Rows, Accounting for Duplicate Data
Replies
1
Views
127
Kaper
Kaper
E
  • Question Question
VBA code clean up
Replies
9
Views
583
mumps
mumps
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
L
  • Question Question
Searchable data validation list problem
Replies
0
Views
52
Lschuman
L

Forum statistics

Threads
1,224,597
Messages
6,179,808
Members
452,944
Latest member
2558216095

Share this page

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