Skip to main content
AmigoFish

The Missing Piece To Dynamic Spilled Array Formulas: Cell Lists & Arrays & FLATTEN. EMT 1931

From excelisfun · · 3 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.

If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.

Watch on YouTube

Not rated yet

Description

Download Excel File: https://excelisfun.net/files/EMT1931.xlsx Mike excelisfun Girvin Excel books: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ref=sr_ntt_srch_lnk_1&ccs_id=5f0ec91c-7a28-4a2b-9c87-04a7ee3159e6

Learn about the Options Setting Workbook Compatibility 3, and how Cell Lists & the FLATTEN function are the missing piece that allows Dynamic Spilled Array Formulas to spill in all directions.

This video has subtitles or audio track in these 86 languages: Afrikaans, Arabic, Armenian, Bambara, Bangla, Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Chinese, Croatian, Czech, Danish, Dutch, Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (France), Georgian, German, German (Germany), Greek, Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latin, Latvian, Lithuanian, Macedonian, Maithili, Malagasy, Malay, Malayalam, Mongolian, Nepali, Norwegian, Papiamento, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Punjabi, Romanian, Russian, Samoan, Sanskrit, Scottish Gaelic, Serbian, Sicilian, Sinhala, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (United States), Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Turkish, Turkmen, Ukrainian, Urdu, Vietnamese, Welsh, Western Frisian, Zulu

#excelformulas #excel365 #excelisfun #mikegirvin #freeexcellessons #excelformulas #excelfunctions #dynamicspilledarrayformulas #arrays #flatten #celllists #cellarray #arrayformulas

Back to excelisfun · Report a problem