Excel's UNIQUE function returns a list of unique values in a list or range. If you have a column in Excel for "Country" and listed are USA, USA, France, France, Belgium, Spain, Belgium, and France, the UNIQUE function will return USA, France, Belgium, and Spain. The UNIQUE function can return distinct values or unique values.
Syntax of Unique
=UNIQUE(array,[by_col],[exactly_once])
Who has the UNIQUE function? Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 202, Excel 2021, for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones.
Other Youtube videos on Unique function by Chris Menard
Unique function for Excel web • UNIQUE Function using Excel for the w...
UNIQUE Function New dynamic array function • Excel: UNIQUE Function New dynamic ...
Excel: Combine the awesome UNIQUE and SORT functions in Excel • Excel: Combine the awesome UNIQUE and...
#excel #excelfunctions #chrismenard #chrismenardtraining #microsoft #microsoftexcel
And make sure you subscribe to my channel!
EQUIPMENT USED
○ My camera – https://amzn.to/3vdgF5E
○ Microphone https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights https://amzn.to/3vaxyy5
○ Dual monitor mount stand https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount https://amzn.to/3g96FGj
○ Boom Arm https://amzn.to/3g8cNi6
SOFTWARE USED
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!