Excel - Combine the SORT, UNIQUE, and COUNT functions

Posted on:  01/27/2023
Excel - Combine the SORT, UNIQUE, and COUNT functions

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.

SORT and UNIQUE Functions combined

SORT and UNIQUE Functions combined

YouTube Video

Excel Function used in this video

The following functions are used in the video:

  1. Unique
  2. Sort
  3. Count
  4. CountA
  5. Text

Unique Function

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

UNIQUE Function in Excel

UNIQUE Function in Excel

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. 

  1. Range
  2. Sort priority - 2nd column in the example
  3. Ascenting - 1
SORT Function in Excel

SORT Function in Excel

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.

 

COUNT and COUNTA Functions

COUNT and COUNTA Functions

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. 

TEXT Function in Excel

TEXT Function in Excel

Online Microsoft Teams Training with Chris Menard

50% off coupon

Just some of the topics covered

  1. Navigation Teams
  2. Using private Chat
  3. Using group Chat
  4. 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
  5. Working with Teams and Channels
    1. Conversations
    2. Files
    3. Wiki and OneNote
  6. Using Outlook and Teams
  7. 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 - 3 Calendar features the desktop version doesn't have

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

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

Copilot for Excel - Is it Accurate? 11 Tests Performed

Copilot for Excel - Is it Accurate? 11 Tests Performed

March 14, 2024 - Beginner’s Guide to Microsoft Copilot

March 14, 2024 - Beginner’s Guide to Microsoft Copilot

Microsoft Word to Adobe Acrobat with Bookmarks

Microsoft Word to Adobe Acrobat with Bookmarks

Dictate Feature Updates in Word, Outlook, PowerPoint, and OneNote

Dictate Feature Updates in Word, Outlook, PowerPoint, and OneNote

Categories