Given the data set:
Name Date Amount
Steve Jan 1 $5
Phil Jan 1 $7
Phil Feb 1 $5
John Feb 1 $3
I want to determine new customers on a monthly basis. So In January I should have 2 new customers Steve and Phil but in February I should only have one new customer John.
January February
2 1
I've tried using a frequency match array formula but the problem is when I narrow the data set by month, the match statement is only looking at February rows so it thinks Phil is a unique (new) customer.
Any help is appreciated!!
Name Date Amount
Steve Jan 1 $5
Phil Jan 1 $7
Phil Feb 1 $5
John Feb 1 $3
I want to determine new customers on a monthly basis. So In January I should have 2 new customers Steve and Phil but in February I should only have one new customer John.
January February
2 1
I've tried using a frequency match array formula but the problem is when I narrow the data set by month, the match statement is only looking at February rows so it thinks Phil is a unique (new) customer.
Any help is appreciated!!