Skip to main content
AmigoFish

FLATTEN Function & Cell Lists To Spill TEXTSPLIT Results Into Rectangular Range. EMT 1929

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/EMT1927and1928and1929.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 how to use the new Cell Lists & FLATTEN function to solve the "Spill Array of Arrays" problem. See how to use the TEXTSPLIT function to spill an array formula vertically and horizontally into a rectangular range.

The subtitle or audio button below the video offers these 66 languages: Afrikaans, Arabic, Armenian, Bambara, Bangla, Bulgarian, Burmese, Cantonese, Dutch (Netherlands), French (France), German (Germany), Greek, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Italian, Japanese, Khmer, Korean, Latvian, Malagasy, Malayalam, Nepali, Polish, Portuguese, Portuguese (Brazil), Punjabi, Russian, Sanskrit, Sicilian, Somali, Spanish, Spanish (United States), Swahili, Tamil, Telugu, Thai, Tibetan, Ukrainian, Urdu, Vietnamese, Zulu.

#excel #excel365 #excelisfun #mikegirvin #freeexcellessons #excelformulas #excelfunctions #spillarayofarrays #dynamicspilledarrays #excelarrays #flatten #lists #arrays

Back to excelisfun · Report a problem