UNIQUE on Rectangular Range in Excel - Episode 2317

У вашего броузера проблема в совместимости с HTML5

Extremely tricky problem today: How can you use UNIQUE to get all unique individual cells from A1:D12? The solutions are all pretty complex. Do you have something better?
Vote for a SPLIT function at
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/33712939-add-new-split-formula
Vote for changing UNIQUE at https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/39668899-allow-unique-to-operate-on-a-rectangular-range
Follow Brad Yundt on Quora: https://www.quora.com/profile/Brad-Yundt
Information on Fast Excel V4 from Charles Williams: https://mrx.cl/speedv4
Cool stuff in this video:
Ingeborg Hawighorst using TEXTJOIN to turn a rectangular range into a single cell.
Fairwinds splitting that cell into a row of cells
Charles Williams add-in with SLICES, VSTACK, and UNPIVOT
Brad Yundt with a 3-line SPLITTER UDF for the win.