Calculating list data based on multiple criteria

[squigman]

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!

[Richard Buttrey]

Hi,

There may be a simpler option but for the moment
F5:

Please Login or Register  to view this content.

G5:

Please Login or Register  to view this content.

Both copied down