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) 24
2) 24
3) 24
4) 24
5) 28
6) 28
7) 30
Month (Column B)
1) 11/1/2009
2) 11/1/2009
3) 11/1/2009
4) 12/1/2009
5) 11/1/2009
6) 12/1/2009
7) 12/1/2009
Answers
- 2 new clients in 11/1/2009 (customer 24 and 28)
- 1 new client in 12/1/2009 (customer 30)
Bookmarks