Extract unique values from a list in excel with the UNIQUE function

In this beginners tutorial we learn how to use the dynamic function UNIQUE in Microsoft Excel. This is used to extract unique values from a list, from a column or from a row using one simple function. I think this might be one of the most useful functions in excel. Learn all the basics of the UNIQUE function as you watch in our easy tutorial for beginners. The excel unique function can also be combined with the SORT function to sort the results. Learn how to extract unique values in excel in this quick tutorial. You can also learn how to extract values that appear only ones. Finding and extracting unique values is now a simple task in excel and is the first step to creating advanced drop down lists or data validation in excel - check out our other videos below.

Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!

What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)

PS. I'm was a little husky when I recorded this - so enjoy the rugged voice!