Hi all,
I have a list of purchases made by an individual and want to see if their first purchase was a "coupon purchase" followed by a "noncoupon purchase" at anytime thereafter. Ideally (but less important), I would like to calculate the total value of purchases made after the initial purchase for those determined above.
I have attached and excel sheet where I am trying to find formulas to calculate the green cells explained above.
Thanks for any possible help or ideas!
Bookmarks