1 2 Previous Next 17 Replies Latest reply on Aug 24, 2016 8:45 PM by deepesh.moad

    Need help in finding 1st purchase,2nd purchase..... of a customer!

    deepesh.moad

      Hi Guys,

       

      I need help in finding 1st purchase,2ndpurchase,3rd purchase......till more than 6th purchase of unique customers.
      I need something like below table structure.

       

       

      sample.PNG

       

      I am trying with the help of index function but unable to create a count of customers.

       

      I am attaching the workbook with the sample data.

       

      Additional information:

      A Customer might buy the selected product more than once per week. If a customer buys a product 2 times in the same week and never before it should be counted only

      as his 2nd purchase in this week and not as his 1st purchase.

       

      Thanks a ton !

       

      Deepesh

        1 2 Previous Next