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 - New dynamic array function [ Ссылка ]
Excel: Combine the awesome UNIQUE and SORT functions in Excel [ Ссылка ]
#excel #excelfunctions #chrismenard #chrismenardtraining #microsoft #microsoftexcel
And make sure you subscribe to my channel!
-- EQUIPMENT USED ---------------------------------
○ My camera – [ Ссылка ]
○ Microphone - [ Ссылка ]
○ Camera tripod – [ Ссылка ]
○ Studio lights - [ Ссылка ]
○ Dual monitor mount stand - [ Ссылка ]
○ Web camera – [ Ссылка ]
○ Shock mount - [ Ссылка ]
○ Boom Arm - [ Ссылка ]
-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – [ Ссылка ]
○ Screenshots – Snagit – [ Ссылка ]
○ YouTube keyword search – TubeBuddy – [ Ссылка ]
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!
