Skip to content
Sheets Help

Tips, tutorials, and training

  • Basics
  • Tutorials
  • Functions

unique

Conditionally Count Unique Values in Google Sheets

December 31, 2022December 19, 2022 by Adam Steinfurth

Three techniques to count unique values based on specified criteria.

Categories Tutorials Tags array, count, countuniqueifs, function, query, unique Leave a comment

COUNTUNIQUEIFS Function – Google Sheets

January 5, 2023December 14, 2022 by Adam Steinfurth

Count unique values based on multiple criteria.

Categories Math Tags conditional count, count, COUNTIF, countuniqueifs, IF, unique Leave a comment

UNIQUE Function – Google Sheets

December 3, 2022 by Adam Steinfurth

Remove duplicate lines from a table of data

Categories Filter Tags array, duplicates, filter, unique 2 Comments

Count Unique Values Regardless of Capitalization – Sheets

November 11, 2022June 29, 2022 by Adam Steinfurth

Count unique values in a spreadsheet while ignoring capitalization.

Categories Tutorials Tags arrayformula, case insensitive, case sensitive, count, proper, unique Leave a comment

COUNTUNIQUE Function – Google Sheets

December 19, 2022June 21, 2022 by Adam Steinfurth

Counts the number of unique values in a data set.

Categories Math Tags count, countunique, unique Leave a comment
Older posts
Page1 Page2 Next →

Makers of:

Insert Special Characters Add-On Icon Insert Special Characters

TripTally Logo TripTally

Google Sheets Basics – Create, Design, and Share

See the course
  • Home
  • Basics
  • Functions
  • Tutorials
  • About
  • Contact
© 2023 Sheets Help • Built with GeneratePress