Excel UNIQUE Function | Excel One Minute Functions Explained смотреть онлайн

Excel's UNIQUE function returns a list of unique values in a list or range. If you have a column in Excel for "County" 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 https://www.youtube.com/watch?v=9Hr7cGMDVkw
UNIQUE Function - New dynamic array function https://youtu.be/P5QQPvDeFoo
Excel: Combine the awesome UNIQUE and SORT functions in Excel https://youtu.be/LG4ZKZur3Uk

#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!