See how you can use the UNIQUE function in Excel to get a list of unique values from your data. The UNIQUE function has to be one of the easiest ways to find unique values in your data!
Currently only available to Office 365 users, this function works by returning a list of unique values from your data. It should be available in newer versions of Excel too.
Click here to read our step-by-step article on this: https://yacostasolutions.com/unique-f...
00:00 About the UNIQUE Function in Excel
00:37 Default / Basic Use of the UNIQUE Function
01:14 How to Use UNIQUE When Data is in Columns or Rows
03:05 Use UNIQUE to Return Only Items that Appear One Time in Your Data
04:14 How to Use the UNIQUE Function on Multiple, Adjacent Columns or Rows
04:45 Nesting the UNIQUE Function with Other Excel Functions to Customize Results
If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: https://yacostasolutions.com/newsletter/
*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: https://yacostasolutions.com/MS365
The screen recording + editing was done using Techsmith Camtasia. You can check it out here: https://yacostasolutions.com/camtasia
Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊
To catch our Excel tutorials as they come out, subscribe to this channel by clicking: https://yacostasolutions.com/youtube
Thanks!
*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!
#YAcostaTutorials