★ Want to automate Excel? Check out our training academy ★ ★ Download the example file:★ ★ About this video ★ I can’t even begin to count the number of times I have created a unique list in Excel, all of which used various manual methods. When Microsoft announced dynamic arrays in September 2018, they also announced a host of new functions, one of which is UNIQUE. UNIQUE is a new function which returns the distinct or unique values from a range or array. This is triggered by the normal calculation process, so is completely automated. Through 6 examples, you will learn how to master this new function. ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ ★ Where to find Excel Off The Grid ★ Blog: Twitter: #MsExcel #ExcelOffTheGrid