Hi,
I did a search before resorting to post this query but unfortunately the results from the search (sumproduct / frequency / countif) seemed to be confusing to me.. and therefore this post
I have sample monthly data for sales in one sheet as below..
<tbody>
</tbody>
I have one more summary sheet which has a small table with Month in col A & Unique count in col B.. I need to arrive at the unique count of invoice nos against each month with a formula in the unique count column
<tbody>
</tbody>
Can somebody help?
I did a search before resorting to post this query but unfortunately the results from the search (sumproduct / frequency / countif) seemed to be confusing to me.. and therefore this post
I have sample monthly data for sales in one sheet as below..
Month | Inv No. |
Apr-13 | 743 |
Apr-13 | 759 |
Apr-13 | 760 |
Apr-13 | 760 |
May-13 | 777 |
May-13 | 822 |
May-13 | 823 |
May-13 | 823 |
May-13 | 825 |
Jun-13 | 1087 |
Jun-13 | 1088 |
Jun-13 | 1092 |
Jun-13 | 1027 |
Jun-13 | 1091 |
Jun-13 | 1124 |
Jun-13 | 1124 |
Jun-13 | 1133 |
Jun-13 | 1133 |
Jun-13 | 1135 |
Jul-13 | 1266 |
Jul-13 | 1265 |
Jul-13 | 1265 |
Jul-13 | 1265 |
Jul-13 | 1347 |
<tbody>
</tbody>
I have one more summary sheet which has a small table with Month in col A & Unique count in col B.. I need to arrive at the unique count of invoice nos against each month with a formula in the unique count column
Month | Unique Inv Count |
Apr-13 | 3 |
May-13 | 4 |
Jun-13 | 8 |
Jul-13 | 3 |
<tbody>
</tbody>
Can somebody help?