How To Use Excel’s UNIQUE Function
The UNIQUE function in Excel extracts a list of unique values from a range or array. This can be handy for pulling out unique email addresses, product SKUs, or anything else you need to keep track of. In this blog post, we will explore UNIQUE in more detail and see how we can put it to use in our own Excel spreadsheets!
What Does The UNIQUE Function Do?
The UNIQUE function in Excel extracts a list of unique values from a range or array. The result is a dynamic array of unique values. If this array is the final result (i.e. not handed off to another function), array values will “spill” onto the worksheet into a range that automatically updates when new uniques values are added or removed from the source range.
Where To Find It?
Option 1:
You can find the UNIQUE function in the Formulas tab of Excel under Lookup & Reference
Option 2:
You can use Formula Builder to walk you through the formula step by step.
Option 3:
You can manually type the formula into any cell.
The SORTBY Formula
=UNIQUE (array, [by_col], [exactly_once])
- array (required) – Range or array from which to extract unique values
- by_col (optional) – How to compare and extract. By row = FALSE (default); by column = TRUE
- exactly_once (optional) – TRUE = values that occur once, FALSE= all unique values (default)
Let’s Take a Look at an Example
Excel Workbook
Coming Soon
Example
Coming Soon
Tips and Tricks
Not Too Sensitive
The UNIQUE function is not case-sensitive. UNIQUE will treat “F9FINANCE, “f9Finance”, and “f9finance” as the same text.
Office 365
This is a new function that is only available with Excel 365.
Let’s Recap
The UNIQUE function in Excel is a handy tool for extracting unique values from a range or array. It can be used for a variety of purposes, such as extracting unique email addresses, product SKUs, or anything else you need to keep track of. In this blog post, we explored the UNIQUE function in more detail and saw how we can put it to use in our own Excel spreadsheets! Thanks for reading!
Do you have any tips or tricks for using the UNIQUE function? Let us know in the comments below!
Have any questions? Are there other topics you would like us to cover? Leave a comment below and let us know! Make sure to subscribe to our News