clalculate SLA Late times by "group"

M

m-s.oinas

New Member
Joined
Apr 4, 2011
Messages
1
<TABLE style="WIDTH: 100%; mso-cellspacing: 0cm; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm" class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 1.5pt; BACKGROUND-COLOR: transparent; PADDING-LEFT: 1.5pt; PADDING-RIGHT: 1.5pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 1.5pt">Hello All

I have tried to clalculate SLA Late times by "group"

I have Case data in sheet 1 (in real life more than 1200 rows / 12 sheets) and i need find how can i count late times (NOK) to sheet 2 By group
Please see below Short clip from my Sheets 1 & 2<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<TABLE style="WIDTH: 503pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm" class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0 width=671><TBODY><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 48pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" width=64>SHEET 1<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 61pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" width=81>A <o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 81pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" width=108>B<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 47pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" width=63>C<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 59pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" width=79>D<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 83pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" width=111>E<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 81pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" width=108>F<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 43pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" width=57>G<o:p></o:p>

</TD></TR><TR style="HEIGHT: 28.5pt; mso-yfti-irow: 1"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; HEIGHT: 28.5pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm">1<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: red 1pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 61pt; PADDING-RIGHT: 0cm; HEIGHT: 28.5pt; BORDER-TOP: red 1pt solid; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-alt: solid red .5pt" width=81>SLA Code 1<o:p></o:p>

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

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 47pt; PADDING-RIGHT: 0cm; HEIGHT: 28.5pt; BORDER-TOP: red 1pt solid; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-top-alt: solid red .5pt; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=63>SLA Code2<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 59pt; PADDING-RIGHT: 0cm; HEIGHT: 28.5pt; BORDER-TOP: red 1pt solid; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-top-alt: solid red .5pt; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=79>SLA Time 2<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 83pt; PADDING-RIGHT: 0cm; HEIGHT: 28.5pt; BORDER-TOP: red 1pt solid; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-top-alt: solid red .5pt; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=111>Start <o:p></o:p>

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

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 43pt; PADDING-RIGHT: 0cm; HEIGHT: 28.5pt; BORDER-TOP: red 1pt solid; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-top-alt: solid red .5pt; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=57>On-time<o:p></o:p>

</TD></TR><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 2"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm">2<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: red 1pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 61pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt; mso-border-left-alt: solid red .5pt" width=81>Start at <o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 81pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=108>
09.01.2011 14:00<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 47pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=63><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 59pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=79><o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 83pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=111>
14.01.2011 14:00<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 81pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=108>
14.01.2011 14:27<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 43pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=57>NOK<o:p></o:p>

</TD></TR><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 3"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm">3<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: red 1pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 61pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt; mso-border-left-alt: solid red .5pt" width=81>Start at <o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 81pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=108>
04.01.2011 16:30<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 47pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=63><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 59pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=79><o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 83pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=111>
04.01.2011 14:17<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 81pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=108>
11.01.2011 13:50<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 43pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=57>OK<o:p></o:p>

</TD></TR><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 4"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm">4<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: red 1pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 61pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt; mso-border-left-alt: solid red .5pt" width=81>Start at <o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 81pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=108>
22.01.2011 13:32<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 47pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=63><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 59pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=79><o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 83pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=111>
22.01.2011 17:09<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 81pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=108>
22.01.2011 18:09<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 43pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=57>NOK<o:p></o:p>

</TD></TR><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 5"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm">5<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: red 1pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 61pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt; mso-border-left-alt: solid red .5pt" width=81>Start at <o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 81pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=108>
29.01.2011 7:00<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 47pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=63><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 59pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=79><o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 83pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=111>
30.01.2011 18:00<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 81pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=108>
30.01.2011 19:00<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 43pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=57>NOK<o:p></o:p>

</TD></TR><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 6"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm">6<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: red 1pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 61pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt; mso-border-left-alt: solid red .5pt" width=81>Start at <o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 81pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=108>
13.01.2011 8:00<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 47pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=63><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 59pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=79><o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 83pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=111>
15.01.2011 11:38<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 81pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=108>
15.01.2011 15:57<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 43pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=57>NOK<o:p></o:p>

</TD></TR><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 7; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm">7<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: red 1pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 61pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt; mso-border-left-alt: solid red .5pt" width=81>Start at <o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 81pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=108>
20.01.2011 12:06<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 47pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=63><o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 59pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=79><o:p></o:p>
​
</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 83pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=111>
18.01.2011 12:09<o:p></o:p>

​
</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 81pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=108>
18.01.2011 12:56<o:p></o:p>​


</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 43pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=57>OK<o:p></o:p>

</TD></TR></TBODY></TABLE><o:p></o:p>
<TABLE style="WIDTH: 201pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm" class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0 width=268><TBODY><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 51pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" width=68>SHEET 2<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 69pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" width=92>A<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 81pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" width=108>B<o:p></o:p>

</TD></TR><TR style="HEIGHT: 28.5pt; mso-yfti-irow: 1"><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: red 1pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 51pt; PADDING-RIGHT: 0cm; HEIGHT: 28.5pt; BORDER-TOP: red 1pt solid; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-alt: solid red .5pt" width=68>1<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 69pt; PADDING-RIGHT: 0cm; HEIGHT: 28.5pt; BORDER-TOP: red 1pt solid; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-top-alt: solid red .5pt; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=92>Late Group<o:p></o:p>

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

</TD></TR><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 2"><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: red 1pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 51pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt; mso-border-left-alt: solid red .5pt" width=68>2<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 69pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=92>4 -> days late<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 81pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=108>QTY<o:p></o:p>

</TD></TR><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 3"><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: red 1pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 51pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt; mso-border-left-alt: solid red .5pt" width=68>3<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 69pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=92>OK<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 81pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=108>QTY<o:p></o:p>

</TD></TR><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 4"><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: red 1pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 51pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt; mso-border-left-alt: solid red .5pt" width=68>4<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 69pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=92>> one day<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 81pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=108>QTY<o:p></o:p>

</TD></TR><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 5"><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: red 1pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 51pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt; mso-border-left-alt: solid red .5pt" width=68>5<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 69pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=92>> 2 days<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 81pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=108>QTY<o:p></o:p>

</TD></TR><TR style="HEIGHT: 18.75pt; mso-yfti-irow: 6; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: red 1pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 51pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt; mso-border-left-alt: solid red .5pt" width=68>6<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 69pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=92>2-3 Days<o:p></o:p>

</TD><TD style="BORDER-BOTTOM: red 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0cm; WIDTH: 81pt; PADDING-RIGHT: 0cm; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: red 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid red .5pt; mso-border-right-alt: solid red .5pt" width=108>QTY<o:p></o:p>

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

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

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Sort by date Sort by votes
Have a calculation column in Sheet1 that gives a result of what group the row should be counted in. Then summarise Sheet1 in a PivotTable to count occurences in each group.
 
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
617
smozgur
smozgur
V
  • Solved
How to put a space in this table in VBA?
Replies
1
Views
501
VBAEXCELNew
V
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
E
  • Question Question
Adding a custom message.
Replies
1
Views
659
Micron
M

Forum statistics

Threads
1,224,521
Messages
6,179,286
Members
452,902
Latest member
Knuddeluff

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