Hi - I have the following set of data:
<!--StartFragment--> <colgroup><col width="65" span="5" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>
I want to be able to look at how many unique customers bought charts in month 1? In the above table it would be 1 - thanks
A | B | C | D | |
1 | Product | Month | Customer | Value |
2 | ||||
3 | Charts | 1 | AAA | £20 |
4 | Publications | 1 | BBB | £25 |
5 | Flags | 1 | AAA | £33 |
6 | Charts | 1 | AAA | £10 |
7 | Flags | 2 | BBB | £15 |
8 | Charts | 2 | AAA | £16 |
<!--StartFragment--> <colgroup><col width="65" span="5" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>
I want to be able to look at how many unique customers bought charts in month 1? In the above table it would be 1 - thanks