Excel Magic Trick 1444 Part 2

Count Customer Names for 8 Sales Coupon Groups

DESCRIPTION

See how to use Excel Formulas to analyze a group of customers who have been given coupons to three stores. Our goal is to count how many customers used coupons in one of eight coupon groups (all combinations of the three store coupons) and then extract the customer names in each group. The data and goals are:
1) Each customer was given coupons to go to Wegmans, Publix, Trader Joe’s.
2) We have a list of Stores names.
3) We have a list of transactions for the coupon redemption’s that lists purchases, customer name and store
4) Goal 1: Count Customers who visited a given set of stores.
This Part 02 Video is an alternative method for counting from Tobias de Greeuw from the Netherlands. This alternative version we use the functions COUNTIFS, IF and TRANSPOSE. This alternative eliminates the need for eight separate Logical Formulas and simplifies the process by using an Array Formula.

WORKBOOKS

Download “Excel Magic Trick 1441-1448” Excel-Magic-Trick-1441-1448.zip – Downloaded 68 times – 3 MB







Be the first to comment

Leave a Reply