Excel Magic Trick 1444 Part 2: Count Customer Names for 8 Sales Coupon Groups

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.

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 & Data Model PivotTable to Count & List Stores Customers Visited

[barttitulaerexcelbart]

That's what I like so much in the online learning community, always people who see a different / better solution or part of the model that can be improved. Thanks Tobias for your contribution!

[evanlog]

This here is busan in korea.

Very nice excel

[entertainmentgalaxy]

One thing more, can we get list of excel magic trick series from 1 to 1445 or (as on today) with subject of video you shared.
It will help us a lot to find what we are looking for on your channel within a few clicks.

Once again thanks for your great effort to teach us what actually excel is, and how much we can use it in our daily life.

[javadkhalilarjmandi]

really tnx, now I love excel, you are a great teacher,

[zaighamuddinfarooqui]

Comparatively good solution. Thanks :}

[mohamedchakroun]

Thanks for the alternative :-) and thanks to tobbias

[entertainmentgalaxy]

Super duper solution and explanation.... Thanks for sharing. i wonder and looking forward to see how to to create 8 sales coupon group automatically...

[AdiCristea]

Hey Mike, thanks for creating a part 2 video. One question, I'm having trouble understanding something: in the first part, whilst I was following along, I, at some point, tried to "go rogue" and use my own solution. I wanted to use the ISBLANK function. However, even though TRANSPOSE works, ISBLANK is returning FALSE for P6, Q5 etc. If I went in, selected the cell, hit F2, then ENTER, the ISBLANK would then return TRUE.

Can you explain this behaviour?

Cheers.
Adi

Edit: it seems I forgot to add a word couple of times. Therefore putting it at the end: "please".

Even later edit: viewed 1445 video in which I see you've used ISTEXT. Tried that too, would return TRUE for the empty cells in 1444 files.