Thursday, November 13, 2014

yogi_Compute Number Of Unique Customers Who Purchased In All Periods Except The Specified Period

                 Google Spreadsheet   Post  #1831
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-13-2014
post by  Joram030:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/pj5VX6XzkeE)
Calculate customer churn
Hi,

I've got a dataset that looks like this:

CustomerPeriod
a1
b1
b1
c1
d1
a2
b2
d2
e2
d2

I'd like to calculate the number of unique customers that made a purchase in Period 1 but Not in Period 2.

Hope anyone can help!

Many thanks!
----------------------------------------------------------------------------------------------------------------------------