UNIQUE of Rectangular Range Using MAKEARRAY in Excel

Microsoft Excel Tips and Tricks

Another new LAMBDA helper function in Excel is MAKEARRAY. This video shows a simple example, and then tackles the problem from episode 2317 of how to unwind a rectangular range into a single column so you can pass it to UNIQUE and SORT.

Credit MrExcel.com