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!


      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.





      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 !



        1 2 Previous Next