Logical Formulas - Count & Extract Customer Names for 8 Sales Coupon Groups

Logical Formulas - Count & Extract Customer Names for 8 Sales Coupon Groups

ExcelIsFun via YouTube Direct link

) Introduction to Problem

1 of 6

1 of 6

) Introduction to Problem

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Logical Formulas - Count & Extract Customer Names for 8 Sales Coupon Groups

Automatically move to the next video in the Classroom when playback concludes

  1. 1 ) Introduction to Problem
  2. 2 ) Count number of coupons each customer redeemed for each store. See the COUNTIFS Function.
  3. 3 ) Logical formulas for determining which customers fall into each of the eight coupon groups. Learn about AND Logical Tests, OR Logical Tests, and a NONE Logical Test (None are TRUE, or All are FALSE…
  4. 4 ) Count Customers in each of the eight coupon groups using COUNTIFS Function.
  5. 5 ) Formula to Extract Customer Names for each of the eight coupon groups. Learn about Array Formulas to looks an item and Return Multiple Items. Learn about the Excel Spreadsheet functions: ROW, AGGRE…
  6. 6 ) Conclusion

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.