Remove Duplicate Values From a List Using the UNIQUE Function in Excel
Learn how to master the UNIQUE function in Excel! The UNIQUE function lets you make a copy of a list but without duplicate entries - a common every-day requirement for many Excel users that, until now, has been time-consuming and fraught with errors.
The UNIQUE function not only speeds up and automates the process, it contains some useful options too such as the ability to choose between row-based and column-based lists, the ability to detect duplicates across a multi-column or multi-row range and it can even, with a simple additional parameter, return values that occur only once within the list.
Check it out in this comprehensive video
NOTE: The UNIQUE function is currently available in Excel 365 and Excel 2021 only.
For full details see the timestamps below:
⏱ Timestamps
00:00:00 Introduction
00:00:53 UNIQUE Function - Basic Example
00:01:44 Dynamic Array Functions - an Explanation
00:03:03 Using the COUNTA Function and the Hash Symbol with UNIQUE
00:04:07 Using UNIQUE with a Table
00:05:41 Using UNIQUE with Multiple Columns
00:07:02 The ByCol Parameter
00:08:44 The Exactly_Once Parameter
🗒 Notes and Resources
Download a copy of the file used in this video: https://share.getcloudapp.com/DOudmyl8
The formulas that I used in the demos:
=UNIQUE(A2:A13)
=COUNTA(G2#)
=UNIQUE(Vehicles[Registration])
=UNIQUE(Vehicles1[[First Name]:[Surname]])
=UNIQUE(B3:Q3,TRUE)
=TRANSPOSE(UNIQUE(B3:Q3,TRUE))
=UNIQUE(A2:A13,,TRUE)
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #unique #duplicates