1 Reply Latest reply on Oct 2, 2018 11:31 AM by tadd.wagner

    CNTD of Customers with a minimum order date in given time frame

    tadd.wagner

      Hi there,

       

      In the attached workbook, I have created "Min Order Date" to show the first date that each customer ever ordered from the given data. On my second worksheet, I can view total unique customers by year. However, I want to be able to view the total number of NEW customers by year, or by month, or by last week, etc... How can I do a count of all unique customers that had their first order in a given time frame? 11 customers would show up under 2018, for example (see bottom of the "Initial Data" sheet for these 11).

       

      Thank you.