Completed
) 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 ) Introduction to Problem
- 2 ) Count number of coupons each customer redeemed for each store. See the COUNTIFS Function.
- 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 ) Count Customers in each of the eight coupon groups using COUNTIFS Function.
- 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 ) Conclusion