Hello Is it possible to have a piece of analysis for counting how many references fall between the dates 01/01/2013 to 31/01/2013. Then 01/02/2013 to 29/02/2013?
I have 2 columns as you can see below and have approx 5000 rows of data.
January should total up to 6 from my example below and february should total up to 3.
This is from sheet one and im trying to calculate this on sheet 2 if possible?
Thanking you in advance for any help anyone can give to me.
<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><TBODY>
</TBODY>
I have 2 columns as you can see below and have approx 5000 rows of data.
January should total up to 6 from my example below and february should total up to 3.
This is from sheet one and im trying to calculate this on sheet 2 if possible?
Thanking you in advance for any help anyone can give to me.
Ref | Date |
PP0001 | 01/01/2013 |
PP0002 | 01/01/2013 |
PP0003 | 09/01/2013 |
PP0004 | 28/01/2013 |
PP0005 | 20/02/2013 |
PP0006 | |
PP0007 | 19/01/2013 |
PP0008 | 23/02/2013 |
PP0009 | |
PP0010 | 04/02/2013 |
PP0011 | 03/01/2013 |
<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><TBODY>
</TBODY>