Counting Unique Records and displaying in alternate cells

[Seeby]

Good Afternoon folks, new member here, so please bear with me.

I am undertaking a parking survey in which the last three digits of a registration plate are recorded hourly. I have been able to count the unique entries, however I need to be able to calculate the number of times each entry appears in the row and relate it to how many hours the vehicle was in the space...

The data is thus:

<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=427
style='width:320.0pt;margin-left:4.65pt;border-collapse:collapse;mso-yfti-tbllook:
1184;mso-padding-alt:0cm 5.4pt 0cm 5.4pt'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;height:12.75pt'>
<td width=27 nowrap style='width:20.0pt;border:solid windowtext 1.0pt;
mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><a name="_GoBack"></a><span
style='font-size:10.0pt;mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:
Arial;color:black;mso-fareast-language:EN-GB'>A<o></o></span></p>
</td>
<td width=40 nowrap style='width:30.0pt;border:solid windowtext 1.0pt;
border-left:none;mso-border-top-alt:solid windowtext .5pt;mso-border-bottom-alt:
solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
0cm 5.4pt 0cm 5.4pt;height:12.75pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>B<o></o></span></p>
</td>
<td width=40 nowrap style='width:30.0pt;border:solid windowtext 1.0pt;
border-left:none;mso-border-top-alt:solid windowtext .5pt;mso-border-bottom-alt:
solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
0cm 5.4pt 0cm 5.4pt;height:12.75pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>C<o></o></span></p>
</td>
<td width=40 nowrap style='width:30.0pt;border:solid windowtext 1.0pt;
border-left:none;mso-border-top-alt:solid windowtext .5pt;mso-border-bottom-alt:
solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
0cm 5.4pt 0cm 5.4pt;height:12.75pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>D<o></o></span></p>
</td>
<td width=40 nowrap style='width:30.0pt;border:solid windowtext 1.0pt;
border-left:none;mso-border-top-alt:solid windowtext .5pt;mso-border-bottom-alt:
solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
0cm 5.4pt 0cm 5.4pt;height:12.75pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>E<o></o></span></p>
</td>
<td width=40 nowrap style='width:30.0pt;border:solid windowtext 1.0pt;
border-left:none;mso-border-top-alt:solid windowtext .5pt;mso-border-bottom-alt:
solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
0cm 5.4pt 0cm 5.4pt;height:12.75pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>F<o></o></span></p>
</td>
<td width=40 nowrap style='width:30.0pt;border:solid windowtext 1.0pt;
border-left:none;mso-border-top-alt:solid windowtext .5pt;mso-border-bottom-alt:
solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
0cm 5.4pt 0cm 5.4pt;height:12.75pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>G<o></o></span></p>
</td>
<td width=40 nowrap style='width:30.0pt;border:solid windowtext 1.0pt;
border-left:none;mso-border-top-alt:solid windowtext .5pt;mso-border-bottom-alt:
solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
0cm 5.4pt 0cm 5.4pt;height:12.75pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>H<o></o></span></p>
</td>
<td width=40 nowrap style='width:30.0pt;border:solid windowtext 1.0pt;
border-left:none;mso-border-top-alt:solid windowtext .5pt;mso-border-bottom-alt:
solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
0cm 5.4pt 0cm 5.4pt;height:12.75pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><span class=SpellE><span
style='font-size:10.0pt;mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:
Arial;color:black;mso-fareast-language:EN-GB'>i</span></span><span
style='font-size:10.0pt;mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:
Arial;color:black;mso-fareast-language:EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap style='width:30.0pt;border:solid windowtext 1.0pt;
border-left:none;mso-border-top-alt:solid windowtext .5pt;mso-border-bottom-alt:
solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
0cm 5.4pt 0cm 5.4pt;height:12.75pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>J<o></o></span></p>
</td>
<td width=40 nowrap style='width:30.0pt;border:solid windowtext 1.0pt;
border-left:none;mso-border-top-alt:solid windowtext .5pt;mso-border-bottom-alt:
solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
0cm 5.4pt 0cm 5.4pt;height:12.75pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>K<o></o></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:1;height:61.5pt'>
<td width=27 nowrap style='width:20.0pt;border:solid windowtext 1.0pt;
border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
0cm 5.4pt 0cm 5.4pt;mso-rotate:90;height:61.5pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><b><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>Space<o></o></span></b></p>
</td>
<td width=40 nowrap style='width:30.0pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;mso-rotate:90;height:61.5pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><b><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>07:30<o></o></span></b></p>
</td>
<td width=40 nowrap style='width:30.0pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;mso-rotate:90;height:61.5pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><b><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>08:30<o></o></span></b></p>
</td>
<td width=40 nowrap style='width:30.0pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;mso-rotate:90;height:61.5pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><b><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>09:30<o></o></span></b></p>
</td>
<td width=40 nowrap style='width:30.0pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;mso-rotate:90;height:61.5pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><b><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>10:30<o></o></span></b></p>
</td>
<td width=40 nowrap style='width:30.0pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;mso-rotate:90;height:61.5pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><b><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>11:30<o></o></span></b></p>
</td>
<td width=40 nowrap style='width:30.0pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;mso-rotate:90;height:61.5pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><b><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>12:30<o></o></span></b></p>
</td>
<td width=40 nowrap style='width:30.0pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;mso-rotate:90;height:61.5pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><b><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>13:30<o></o></span></b></p>
</td>
<td width=40 nowrap style='width:30.0pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;mso-rotate:90;height:61.5pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><b><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>14:30<o></o></span></b></p>
</td>
<td width=40 nowrap style='width:30.0pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;mso-rotate:90;height:61.5pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><b><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>15:30<o></o></span></b></p>
</td>
<td width=40 nowrap style='width:30.0pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;mso-rotate:90;height:61.5pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><b><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>16:30<o></o></span></b></p>
</td>
</tr>
<tr style='mso-yfti-irow:2;height:15.0pt'>
<td width=27 nowrap style='width:20.0pt;border:solid windowtext 1.0pt;
border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><b><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>1<o></o></span></b></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>abc</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>abc</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>abc</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>123<o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>123<o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>123<o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>klm</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>klm</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>klm</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>klm</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:3;height:15.0pt'>
<td width=27 nowrap style='width:20.0pt;border:solid windowtext 1.0pt;
border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><b><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>2<o></o></span></b></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>abc</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>abc</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>abc</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>123<o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>123<o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>123<o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>123<o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>123<o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>klm</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>klm</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:4;height:15.0pt'>
<td width=27 nowrap style='width:20.0pt;border:solid windowtext 1.0pt;
border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><b><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>3<o></o></span></b></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>abc</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>abc</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>abc</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>123<o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>123<o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>klm</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>klm</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>klm</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>klm</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>klm</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:5;height:15.0pt'>
<td width=27 nowrap style='width:20.0pt;border:solid windowtext 1.0pt;
border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><b><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>4<o></o></span></b></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>456<o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>456<o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>abc</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>abc</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>abc</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>abc</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>klm</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>klm</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>klm</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>klm</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:6;mso-yfti-lastrow:yes;height:15.0pt'>
<td width=27 nowrap style='width:20.0pt;border:solid windowtext 1.0pt;
border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=center style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:center;line-height:normal'><b><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>5<o></o></span></b></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span style='font-size:10.0pt;mso-fareast-font-family:"Times New Roman";
mso-bidi-font-family:Arial;color:black;mso-fareast-language:EN-GB'>POL<o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>abc</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>abc</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>123<o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>123<o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>123<o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>456<o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal align=right style='margin-bottom:0cm;margin-bottom:.0001pt;
text-align:right;line-height:normal'><span style='font-size:10.0pt;
mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial;
color:black;mso-fareast-language:EN-GB'>456<o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>QWE</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
<td width=40 nowrap valign=bottom style='width:30.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:15.0pt'>
<p class=MsoNormal style='margin-bottom:0cm;margin-bottom:.0001pt;line-height:
normal'><span class=SpellE><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'>QWE</span></span><span style='font-size:10.0pt;mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:Arial;color:black;mso-fareast-language:
EN-GB'><o></o></span></p>
</td>
</tr>
</table>

Please help, I'm at a complete loss.

Many thanks

Oli

 

[Seeby]

Counting Unique Records and displaying in altetnate cells

Good Afternoon folks, new member here, so please bear with me.

I am undertaking a parking survey in which the last three digits of a registration plate are recorded hourly. I have been able to count the unique entries, however I need to be able to calculate the number of times each entry appears in the row and relate it to how many hours the vehicle was in the space...

The data is thus:

A B C D E F G H I J K
Space 07:30 08:30 09:30 10:30 11:30 12:30 13:30 14:30 15:30 16:30
1 abc abc abc 123 123 123 klm klm klm klm
2 abc abc abc 123 123 123 123 123 klm klm



Please help, I'm at a complete loss.

Many thanks

Oli

 

[Oeldere]

Re: Counting Unique Records and displaying in altetnate cells

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
30	A	B	C	D	E	F	G	H	I	J
31	07:30	08:30	09:30	10:30	11:30	12:30	13:30	14:30	15:30	16:30		abc	123	klm
32	abc	abc	abc	123	123	123	klm	klm	klm	klm		3	3	4
33	abc	abc	abc	123	123	123	123	123	klm	klm		3	5	2
sheet1

Cell Formulas
Range	Formula
L32	=COUNTIF($A32:$J32,L$31)
M32	=COUNTIF($A32:$J32,M$31)
N32	=COUNTIF($A32:$J32,N$31)

 

[lrobbo314]

Re: Cnounting Unique Records and displaying in altetnate cells

I have a table. From A13:A15, is a unique list of the last 3 of the plate numbers that you have in your post. Going across the top from B12:F12, I have the space numbers, 1-5.

Then in A13 I entered this formula.

=SUMPRODUCT(($A$2:$A$6=B$12)*($B$2:$K$6=$A13))

Drag the formula down then over.

Obviously, you will need to change the references to wherever you decide to put your table.

 

[Seeby]

Re: Counting Unique Records and displaying in altetnate cells

Oledere, thank you.

But I need excel to identify the entries itself, rather them my having you type in each 3 letter reference in the formula. Is this possible?

Thanks again

 

[Oeldere]

Re: Counting Unique Records and displaying in altetnate cells

You are willing to change the format of the data in a verticaly way?

In that case you can use pivot table to analyse the data.

 

[Aladin Akyurek]

Re: Counting Unique Records and displaying in altetnate cells

Good Afternoon folks, new member here, so please bear with me.

I am undertaking a parking survey in which the last three digits of a registration plate are recorded hourly. I have been able to count the unique entries, however I need to be able to calculate the number of times each entry appears in the row and relate it to how many hours the vehicle was in the space...

The data is thus:

A B C D E F G H I J K
Space 07:30 08:30 09:30 10:30 11:30 12:30 13:30 14:30 15:30 16:30
1 abc abc abc 123 123 123 klm klm klm klm
2 abc abc abc 123 123 123 123 123 klm klm



Please help, I'm at a complete loss.

Many thanks

Oli

Given this, that is, care to post the exact output layout you want?