Deprecated: Creation of dynamic property CF\WordPress\DataStore::$logger is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php on line 23
Deprecated: Creation of dynamic property CF\WordPress\Proxy::$pluginAPI is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/Proxy.php on line 31
Deprecated: file_get_contents(): Passing null to parameter #2 ($use_include_path) of type bool is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/codelights-shortcodes-and-widgets/codelights.php on line 20
Warning: session_start(): Session cannot be started after headers have already been sent in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/wordpress/src/class/wordpress.php on line 53
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
{"id":310,"date":"2017-07-02T10:49:26","date_gmt":"2017-07-02T17:49:26","guid":{"rendered":"https:\/\/bonbonsguide.com\/wp\/?p=310"},"modified":"2017-07-02T10:49:26","modified_gmt":"2017-07-02T17:49:26","slug":"excel-magic-trick-1445-single-cell-array-formula-count-customer-names-for-8-sales-coupon-groups","status":"publish","type":"post","link":"https:\/\/bonbonsguide.com\/wp\/blog\/2017\/07\/excel-magic-trick-1445-single-cell-array-formula-count-customer-names-for-8-sales-coupon-groups\/","title":{"rendered":"Excel Magic Trick 1445: Single Cell Array Formula: Count Customer Names for 8 Sales Coupon Groups"},"content":{"rendered":"See how to use Excel Formulas to analyze a group of customers who have been given coupons to three stores. Our goal is to create a single cell Array Formula that counts how many customers used coupons in one of eight coupon groups (all combinations of the three store coupons). See the Excel Spreadsheet Functions: SUM, MMULT, ROW, COUNTIFS and ISTEXT. Learn about how Array Formulas Work. Outline:
\n1) Each customer was given coupons to go to Wegmans, Publix, Trader Joe’s.
\n2) We have a list of Stores names.
\n3) We have a list of transactions for the coupon redemptions that lists purchases, customer name and store
\n4) Goal 1: Count Customers who visited a given set of stores.
\nDownload File: http:\/\/ift.tt\/2tvSeEE
\nEntire page with all Excel Files for All Videos: http:\/\/ift.tt\/1kSFWvs
\nTopics in Video:<\/p>\n
Related Videos:
\nExcel Magic Trick 1444: Logical Formulas: Count & Extract Customer Names for 8 Sales Coupon Groups
\nExcel Magic Trick 1444 Part 2: Count Customer Names for 8 Sales Coupon Groups
\nExcel Magic Trick 1445: Single Cell Array Formula: Count Customer Names for 8 Sales Coupon Groups
\nExcel Magic Trick 1446: Power Query Count & Extract Customer Names for 8 Sales Coupon Groups
\nExcel Magic Trick 1447: DAX Formulas to Count Customers in 8 Sales Coupon Groups & List Store Names<\/p>\n