How to use unique function in excel.
This #shorts demonstrate the use of #unique function to find out unique list from given data in excel.
Excel's UNIQUE function returns a list of unique values in a list or range. The UNIQUE function can return distinct values or unique values.
Syntax of Unique
=UNIQUE(array,[by_col],[exactly_once])
Unique function is applicable for following versions of #excel :
Excel for Microsoft 365
Excel for Microsoft 365 for Mac
Excel for the web
Excel 2021 Excel 2021 for Mac
Excel for iPad
Excel for iPhone
Excel for Android tablets
Excel for Android phones
Please like the video and subscribe the channel to get notification on more such videos.
Ещё видео!