I need to be able to chart volumes of post received in arrearsarrearsan excel spreadsheet. The sheet has is structured so we can enter multiple types of post for the same date:
<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 95px"><COL style="WIDTH: 143px"><COL style="WIDTH: 53px"><COL style="WIDTH: 47px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD>*</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">55</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Arrears</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">151</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">20</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">56</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Arrears</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">152</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">20</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">57</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Urgent</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">153</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">6</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">58</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Dec'd</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">154</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">4</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">59</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Mtg's & Chq's</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">155</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">6</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">60</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">BKR & IVA</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">156</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">17</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">61</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">62</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">63</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">64</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">65</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">66</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">67</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">68</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">69</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">70</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">71</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">72</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">73</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">74</TD>
</TR></TBODY></TABLE>
Dates follow this style:
01/03/09 Arrears Post 21
01/03/09 Arrears Post 25
01/03/09 IVA Post 21
01/03/09 IVA Post 18
02/03/09
02/03/09
02/03/09
02/03/09
Whats the best way to chart this so I can see on 01/03/09 we had 46 pieces of arrears post etc..
<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 95px"><COL style="WIDTH: 143px"><COL style="WIDTH: 53px"><COL style="WIDTH: 47px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD>*</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">55</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Arrears</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">151</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">20</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">56</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Arrears</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">152</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">20</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">57</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Urgent</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">153</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">6</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">58</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Dec'd</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">154</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">4</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">59</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">Mtg's & Chq's</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">155</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">6</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">60</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">BKR & IVA</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">156</TD><TD style="FONT-FAMILY: Arial; TEXT-ALIGN: left">17</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">61</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">62</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">63</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">64</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">65</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">66</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">67</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">68</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">69</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">70</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">71</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">72</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">73</TD><TD style="FONT-FAMILY: Arial; BACKGROUND-COLOR: #99ccff; TEXT-ALIGN: left">3/3/09</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD><TD style="FONT-FAMILY: Arial">*</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">74</TD>
</TR></TBODY></TABLE>
Dates follow this style:
01/03/09 Arrears Post 21
01/03/09 Arrears Post 25
01/03/09 IVA Post 21
01/03/09 IVA Post 18
02/03/09
02/03/09
02/03/09
02/03/09
Whats the best way to chart this so I can see on 01/03/09 we had 46 pieces of arrears post etc..