Hello All,

Good Day!

Hoping to get the function or formula for this one. We have a promo for a certain products that if you buy both Candy1(FRES CANDY under the "SUBBRANDNAME" on Excel file) and Candy2(KOPIKO CANDY under the "SUBBRANDNAME" on Excel file) you will get a discount. So I would just like to count or have a result of 1/avail per invoice.

I already removed the duplicates on the Sheet2.


Thank you.

Attached Files

Forum.xlsx (15.0 KB, 4 views)