Excel - Combine the SORT, UNIQUE, and COUNT functions

Posted on: 01/27/2023

Excel has dynamic array functions. Two of the dynamic array function are SORT and UNIQUE. I will combine SORT and UNIQUE and also combine them with COUNT and the COUNTA functions. This came from a user that asked how many unique zip codes were in a spreadsheet.

YouTube Video

Excel Function used in this video

The following functions are used in the video:

Unique
Sort
Count
CountA
Text

Unique Function

The UNIQUE function returns a list of unique values in a list or range.

SORT Function in Excel

The SORT function sorts the contents of a range or array.

In the SORT screenshot below, we are sorting the range by the second column in ascending order.

Range
Sort priority - 2nd column in the example
Ascenting - 1

COUNT and COUNTA Functions in Excel

The COUNT and COUNTA functions are very similar. The COUNT function counts the number of cells that contain numbers.COUNT will not include cells that contain text. COUNTA will count cells that contain any data, including errors. COUNTA will not count blanks.

TEXT Function

The TEXT Function converts numbers to text and has two required arguments. Use the TEXT function when you have zip codes and the leading zero is dropped with a number.

Online Microsoft Teams Training with Chris Menard

50% off coupon

Just some of the topics covered

Navigation Teams
Using private Chat
Using group Chat
Teams Meetings
1. Scheduling Meetings
2. Meeting controls
3. Roles in a meeting
4. Sharing resources
5. PowerPoint in a meeting
6. Scheduling Team meetings from Outlook
Working with Teams and Channels
1. Conversations
2. Files
3. Wiki and OneNote
Using Outlook and Teams
Using apps in Teams

Lifetime access to Teams Course Beginner to Pro with coupon

Recent Articles

Outlook on the web - 3 Calendar features the desktop version doesn't have

Outlook on the web has many features that Outlook desktop doesn't have. I'll cover three calendar features that Outlook on the web has that Outlook desktop doesn't provide.

Outlook - Manage your Inbox using Ignore, Archive, Block, Delete, and Clean Up

Your inbox in Microsoft Outlook can become overwhelming to manage. The average office worker receives around 121 emails every workday. Microsoft Outlook has some easy commands located on the Home tab to help manage your inbox.

Excel - Advanced Filters

Excel filters are great for seeing just a subset of your data. You can use filters for text, numbers, and dates, but also by color. You can use font color or fill color (the paint can). You can also use Advanced Filters. You Advanced Filters when you are looking at multiple fields but for different criteria. For example, I want to filter and only see people in Georgia and New York. That is easy to do and can be done with the drop-down filter. But, for Georgia, I want to see people who are Single, and for New York, I want to see Family. That requires an Advanced Filter.

Excel 3D Reference - easily reference data on another worksheet