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 redemptions 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.
Download File: http://ift.tt/2t6hC34
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
Related Videos:
Excel Magic Trick 1444: Logical Formulas: Count & Extract Customer Names for 8 Sales Coupon Groups
Excel Magic Trick 1444 Part 2: Count Customer Names for 8 Sales Coupon Groups
Excel Magic Trick 1445: Single Cell Array Formula: Count Customer Names for 8 Sales Coupon Groups
Excel Magic Trick 1446: Power Query Count & Extract Customer Names for 8 Sales Coupon Groups
Excel Magic Trick 1447: DAX Formulas to Count Customers in 8 Sales Coupon Groups & List Store Names