Textsplit function workaround(Part 2) - REDUCE Function
Textsplit function is unable to spill a 2-D array i.e spill into multiple row and multiple column. The video shows a workaround to TEXTSPLIT and making it spill using the REDUCE function
00:00 Introduction
00:15 Understanding the challenge
02:30 SCAN Introduction
04:45 REDUCE Function Introduction
05:47 Solution with REDUCE function
07:40 DROP and IFNA for finesse
09:10 Concluding Remarks
Link to Excel workbook:
https://docs.google.com/spreadsheets/...
On this page of the site you can watch the video online Textsplit function workaround(Part 2) - REDUCE Function with a duration of hours minute second in good quality, which was uploaded by the user ExcelMoments 01 January 1970, share the link with friends and acquaintances, this video has already been watched 1,616 times on youtube and it was liked by 83 viewers. Enjoy your viewing!
