Have Questions? 
Excel Ninja Pro
All Access

September 9, 2022

How To Get A Unique List in Excel Instantly

Did you know in Excel, you can now instantly get a unique list of items from a larger data set with almost zero work?

This formula (available in Excel 2021, Microsoft 365 for PC/Mac, Excel Online) makes the magic work for you:

=UNIQUE(array,[by_col], [exactly_once])

See below:


New Excel Formula Gets Unique List instantly! This is absolutely bananas and a game changer! #xlninjadan #exceltips #excelformula #exceltricks #excelninja #microsoftexcel

♬ FEEL THE GROOVE - Queens Road, Fabian Graetz

Here's how it works:

  1. Type =UNIQUE(
  2. Select a group of cells that may have duplicates where you only want distinct items, press comma
  3. the second parameter is whether you search by rows or by columns. Default is Rows, so False, but you can use True to use it by columns.
  4. The third parameter is whether you want only things that appear one time (which would NOT include items that have multiple instances) or just grab one of each item which is False. The default is false and is what most people want (Distinct). Some people may only want to show items that are not duplicates (Unique) and they should put True in that parameter.

Excel VBA Is Fun

We believe Excel is one of the most versatile programs out there - and learning to program and automate it makes you very valuable!

You can prevent wasted time and errors, speed up tasks and become indispensable to your organization. 

See how our trainees have gotten raises, promotions and bonuses using their Excel Automation skills while building real problem-solving programs in Excel!
Copyright © 2024 ExcelVbaIsFun

Forgot Password?

Join Us

    Your Cart
    Your cart is emptyReturn to Shop
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram