35 Views • Aug 26, 2024 • Click to toggle off description
Here I show you how to use Excel 365 UNIQUE Function fast by taking advantage of the defaults for the second and third arguments so you don't need to type it in saving you time and simplifying your formulas.
Excel UNIQUE function Syntax:
UNIQUE(array, [by_col], [exactly_once])
Array (required) - the range or array from which to return unique values.
By_col (optional) - a logical value indicating how to compare data:
TRUE - compares data across columns.
FALSE or omitted (DEFAULT) - compares data across rows.
Exactly_once (optional) - a logical value that defines what values are considered unique:
TRUE - returns values that occur only once, which is the database notion of unique.
FALSE or omitted (default) - returns all distinct (different) values in the range or array.
Note. Currently the UNIQUE function is only available in Excel for Microsoft 365 and Excel 2021. Excel 2019, 2016 and earlier do not support dynamic array formulas, so the UNIQUE function is not available in these versions.
LIKE - SUBSCRIBE - COMMENT - SHARE - ENJOY!
Metadata And Engagement
Views : 35
Genre: Science & Technology
Uploaded At Aug 26, 2024 ^^
warning: returnyoutubedislikes may not be accurate, this is just an estiment ehe :3
Rating : 5 (0/3 LTDR)
100.00% of the users lieked the video!!
0.00% of the users dislieked the video!!
User score: 100.00- Masterpiece Video
RYD date created : 2024-08-27T00:47:31.110546Z
See in json
Tags
0 Comments
Top Comments of this video!! :3