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
-
Scheduling Meetings
-
Meeting controls
-
Roles in a meeting
-
Sharing resources
-
PowerPoint in a meeting
-
Scheduling Team meetings from Outlook
-
Working with Teams and Channels
-
Conversations
-
Files
-
Wiki and OneNote
-
Using Outlook and Teams
-
Using apps in Teams
Recent Articles
Mastering Excel Slicers: A Comprehensive Guide
Excel slicers are powerful tools that enhance data filtering in Microsoft Excel, making it easier to visualize and analyze your data. In this blog, we will explore how to create and effectively use slicers, as well as their advantages and limitations in comparison to traditional filters.
Microsoft Word to Adobe Acrobat with Bookmarks
We don't usually want to email, or share are Word files. Frequently, we make our Word documents PDF files. If you lay out your Word document correctly, it is easy to make bookmarks in the PDF.
Categories