UNIQUE function in Excel (with 6 examples) | Remove duplicates with a function | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy


★ Download the example file:★
https://exceloffthegrid.com/unique-fu...


★ 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 ★
https://exceloffthegrid.com/


★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter:   / exceloffthegrid  

#MsExcel #ExcelOffTheGrid