Skip to main content
AmigoFish

New Excel Cell Lists & Arrays & FLATTEN Change Everything. Model Building’s New Frontier. EMT 1926

From excelisfun · · 12 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/EMT1926.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 New Eight Features in Excel, released in Beta on Friday, September 25, 2026: 1) Lists in Single Cells, 2) Tables in Single Cells, 3) Arrays within an Array, the 4 new worksheet functions: 4) FLATTEN, 5) HAS, 6) HASANY, and 7) HASALL, and 8) new filtering capabilities. Topics: 1. (00:00) Introduction 2. (00:15) New Featured In Excel 3. (01:02) Lists in a Single Cell, including INDEX and CHOOSECOLS functions 4. (03:28) Arrays in a Single Cell, Including a Lookup Table in Single Cell and XLOOKUP, VLOOKUP, and LOOKUP functions. 5. (07:06) Arrays within Array in a Single Cell 6. (08:03) FLATTEN function 7. (08:38) HAS Function 8. (08:59) HASANY Function 9. (09:35) HASALL Function 10. (09:58) Filtering with Lists in a Table 11. (10:04) Power Query ???? 12. (10:22) Filter by Item From A List (List Items) 13. (11:05) Filter By List (Displayed Items) 14. (11:21) Excel Features that do not allow lists and arrays in single cells: Spell Check, PivotTables, Find & Replace, Conditional Formatting, COUNTIFS and the like range arguments, Power Query, Charts 15. (11:58) Summary 16. (12:16) Closing

Video has subtitles and/or audio in these languages: Abkhazian, Afar, Afrikaans, Akan, Albanian, Arabic, Armenian, Azerbaijani, Bambara, Bangla, Bashkir, Basque, Belarusian, Bosnian, Breton, Bulgarian, Burmese, Cantonese, Chinese, Chinese (Hong Kong), Chinese (Taiwan), Croatian, Czech, Danish, Dutch, Dutch (Belgium), Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (Belgium), French (Canada), French (France), French (Switzerland), German, German (Germany), Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malayalam, Maltese, Mongolian, Nepali, Norwegian, Papiamento, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Punjabi, Romanian, Russian, Samoan, Sanskrit, Santali, Scottish Gaelic, Serbian, Serbian (Latin), Sicilian, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Tigrinya, Tongan, Tsonga, Tswana, Turkish, Turkmen, Ukrainian, Urdu, Uyghur, Uzbek, Vietnamese, Welsh, Western Frisian, Zulu

#excel #microsoft #excelisfun #Hasfunction #hasany function #hasall function #Lists #Arrays #ArraysInArray #newmicrosoftfeatures #microsoft #microsoftExcel #FLATTEN

Back to excelisfun · Report a problem