How do I count New Customers per month

stevebrooks01 · Sep 25, 2011

Column A = Order Number
Column B = Date Ordered
Column C = Customer #
Column D = Salesperson

I want to count how many new customers each salesperson got per month. The challenge I have is a new customer might buy more than once in the first month.

Thank you
Steve

stevebrooks01 · Nov 11, 2011

Hi Aladin,

Ideally a formula that would give a '1' if it was a new customer. Please note that only one salesperson can only ever own the company .e.g Frank can never have Pepsi as they are Marks.

The end goal is to be able to run a pivot table over this and show how many new Customers each salesperson got each month:

<table border="0" cellpadding="0" cellspacing="0" width="509"><col style="width: 105pt;" width="140"> <col style="width: 92pt;" width="123" span="2"> <col style="width: 92pt;" width="123"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 105pt;" width="140" height="20">Salesperson</td> <td class="xl66" style="width: 92pt;" width="123">Customer</td> <td class="xl66" style="width: 92pt;" width="123">Date</td> <td class="xl74" style="width: 92pt;" width="123">New customer?</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; width: 105pt;" width="140" height="20">Mark</td> <td class="xl71" style="width: 92pt;" width="123">Pepsi</td> <td class="xl73" style="width: 92pt;" width="123">Jul-11</td> <td class="xl75" style="border-top: medium none;">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt; width: 105pt;" width="140" height="20">Frank</td> <td class="xl68" style="width: 92pt;" width="123">Coke</td> <td class="xl73" style="width: 92pt;" width="123">Jul-11</td> <td class="xl75" style="border-top: medium none;">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt; width: 105pt;" width="140" height="20">Frank</td> <td class="xl68" style="width: 92pt;" width="123">Coke</td> <td class="xl73" style="width: 92pt;" width="123">Jul-11</td> <td class="xl75" style="border-top: medium none;">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; width: 105pt;" width="140" height="20">Mark</td> <td class="xl71" style="width: 92pt;" width="123">Pepsi</td> <td class="xl73" style="width: 92pt;" width="123">Jul-11</td> <td class="xl75" style="border-top: medium none;">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; width: 105pt;" width="140" height="20">Mark</td> <td class="xl68" style="width: 92pt;" width="123">Budwesier</td> <td class="xl69" style="width: 92pt;" width="123">Aug-11</td> <td class="xl75" style="border-top: medium none;">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; width: 105pt;" width="140" height="20">Mark</td> <td class="xl71" style="width: 92pt;" width="123">Pepsi</td> <td class="xl69" style="width: 92pt;" width="123">Aug-11</td> <td class="xl75" style="border-top: medium none;">0</td> </tr> </tbody></table>

THANKYOU
Steve

stevebrooks01 · Nov 11, 2011

Aladin, we need to count how many new customers each salesperson got per month? E.g. by assigning a [FONT=&quot]1 [/FONT]if is the first time they ever bought from us?

<table class="MsoNormalTable" style="width: 381pt; margin-left: -1.15pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="508"> <tbody><tr style="height: 15pt;"> <td style="width: 105pt; border: 1pt solid windowtext; padding: 0cm 5.4pt; height: 15pt;" width="140"> Salesperson
</td> <td style="width: 92pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0cm 5.4pt; height: 15pt;" width="123"> Customer
</td> <td style="width: 92pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0cm 5.4pt; height: 15pt;" width="123"> Date
</td> <td style="width: 92pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0cm 5.4pt; height: 15pt;" width="123">

New customer?

</td> </tr> <tr style="height: 15pt;"> <td style="width: 105pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0cm 5.4pt; height: 15pt;" width="140"> Mark
</td> <td style="width: 92pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 5.4pt; height: 15pt;" width="123"> Pepsi
</td> <td style="width: 92pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0cm 5.4pt; height: 15pt;" width="123">

Jul-11