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":746,"date":"2018-09-04T03:24:26","date_gmt":"2018-09-04T10:24:26","guid":{"rendered":"https:\/\/bonbonsguide.com\/wp\/?p=746"},"modified":"2018-09-04T03:24:26","modified_gmt":"2018-09-04T10:24:26","slug":"max-consecutive-wins-for-best-city-array-formula-lookup-3-d-model-excel-hash-competition","status":"publish","type":"post","link":"https:\/\/bonbonsguide.com\/wp\/blog\/2018\/09\/max-consecutive-wins-for-best-city-array-formula-lookup-3-d-model-excel-hash-competition\/","title":{"rendered":"Max Consecutive Wins for Best City: Array Formula, Lookup 3-D Model – Excel Hash Competition"},"content":{"rendered":"

Excel Hash is a project created by Oz at Excel On Fire At YouTube and sponsored by Microsoft.
\nGoal of Excel Solution: Calculate the Max Consecutive Wins for Best City, then lookup the correct 3-D Model icon for the city with the most wins and have the solution dynamically update when new data arrives.
\nDownload Files:
\n Excel Start File: https:\/\/ift.tt\/2Nh9yqY
\n Data Source File: https:\/\/ift.tt\/2PvqhnY
\n Excel Finished File: https:\/\/ift.tt\/2NfGjEX<\/p>\n

Playlist with competitor videos at:
\n <\/iframe><\/span> \nVote here: \n https:\/\/ift.tt\/2MOYPoA<\/p>\n6 Excel YouTubers: \n excelisfun: https:\/\/www.youtube.com\/user\/ExcelIsFun \n Bill from MrExcel: https:\/\/www.youtube.com\/user\/bjele123 \n Leila Gharani: https:\/\/www.youtube.com\/channel\/UCJtUOos_MwJa_Ewii-R3cJA \n Mynda Treacy from My Online Training Hub: https:\/\/www.youtube.com\/user\/MyOnlineTrainingHub \n Oz from Excel on Fire: https:\/\/www.youtube.com\/user\/WalrusCandy \n Excel Campus: https:\/\/www.youtube.com\/user\/ExcelCampus<\/p>\nTopics in Video: \n1. (00:01) Introduction and preview of finished Excel Solution \n2. (02:30) Power Query to Import Data \n3. (03:43) What does FREQUENCY Function do? \n4. (06:04) Array Formula with MAX & FREQUENCY to calculate Max Consecutive Occurrences \n5. (10:07) Lookup Formula to Lookup 3D Model \n6. (11:11) What is a 3D Model? \n7. (14:33) Form button and Macro to Update Data Source \n8. (15:55) Refresh Data and see if Everything Updates \n9. (16:09) Summary<\/p>\n<div style=\"width: 480px;height: 270px;overflow: hidden\"><iframe loading=\"lazy\" class=\"youtube-player\" width=\"480\" height=\"270\" src=\"https:\/\/www.youtube.com\/embed\/2FcgJSgyVuE?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span><\/div>\n<a href=\"https:\/\/youtu.be\/2FcgJSgyVuE\">View on YouTube<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"Excel Hash is a project created by Oz at Excel On Fire At YouTube and sponsored by Microsoft. Goal of Excel Solution: Calculate the Max Consecutive Wins for Best City, then lookup the correct 3-D Model icon for the city with the most wins and have the solution dynamically update when new data arrives. Download […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[21,51,41],"tags":[20,115,22,109,105],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-c2","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/746"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=746"}],"version-history":[{"count":1,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/746\/revisions"}],"predecessor-version":[{"id":747,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/746\/revisions\/747"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=746"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=746"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=746"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}