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
Please support our Sponsors here :