Hello,
I am trying to get to a new client count by month. So I have two columns (Customer ID and Customer Start Date) with duplicate records. Thank you so much in advance!
Data Provided
Customer ID (Column A)
1) 23
2) 24
3) 25
4) 24
5) 28
6) 28
7) 30
Month (Column B)
1) 11/1/2009
2) 11/1/2009
3) 12/1/2009
4) 13/1/2009
5) 14/1/2009
6) 12/2/2009
7) 13/2/2009
Answers
- 4 clients in JAN (customer 23, 24, 25 and 28)
- 2 clients in FEB (customer 28 and 30)
Bookmarks