Home
Project Management
Project Management Skills
Methodologies
Agile
Waterfall
Hybrid
Comparison
Agile Frameworks
Scrum
Kanban
Other Frameworks
Prince2
Project Tools
Project v Program Mgt
Excel
Excel Skills
Excel Functions
Excel Shortcuts
Automations
VBA Projects
VBA Functions
Contact Us
UNIQUE function
Category:
Lookup and reference
Introduced:
Excel 2021
Summary
Returns a list of unique values in a list or range
Syntax
UNIQUE(array,[by_col],[exactly_once])
Example
=SORT(UNIQUE(B2:B12&" "&A2:A12))
Microsoft Support Page
https://support.microsoft.com/en-us/office/unique-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e
Back to Functions