Count unique values
exceljet.net
Count unique values
To count unique values in a set of data, you can use the UNIQUE function together with the COUNTA function. In the example shown, the formula in F5 is: =COUNTA(UNIQUE(B5:B16)) which returns 7, since there are seven unique colors in B5:B16.
Jan 6, 2025
Excel Distinct Count
43K views · 190 reactions | How to Find Count of Distinct & Unique Values in Microsoft #Excel 365 DISTINCT | Different Values, including Duplicates. =COUNTA(UNIQUE(Data[Names],,FALSE)) UNIQUE | Values that appear only once. =COUNTA(UNIQUE(Data[Names],,TRUE)) | Excel Basement | Facebook
0:27
43K views · 190 reactions | How to Find Count of Distinct & Unique Values in Microsoft #Excel 365 DISTINCT | Different Values, including Duplicates. =COUNTA(UNIQUE(Data[Names],,FALSE)) UNIQUE | Values that appear only once. =COUNTA(UNIQUE(Data[Names],,TRUE)) | Excel Basement | Facebook
FacebookExcel Basement
12.1K views1 week ago
How to Count Distinct Values In Excel #exceltutorial #exceltips #exceltricks #excel | Time to Office
0:13
How to Count Distinct Values In Excel #exceltutorial #exceltips #exceltricks #excel | Time to Office
FacebookTime to Office
7.3K viewsJan 19, 2025
Pivot table unique count
Pivot table unique count
exceljet.net
Oct 27, 2022
Top videos
2 Ways to Calculate Distinct Count with Pivot Tables - Excel Campus
2 Ways to Calculate Distinct Count with Pivot Tables - Excel Campus
excelcampus.com
Sep 9, 2020
Count unique values with criteria
Count unique values with criteria
exceljet.net
2 months ago
Count unique values in a range with COUNTIF
Count unique values in a range with COUNTIF
exceljet.net
Aug 21, 2022
Excel Unique Values
How to Count Unique Values in Excel with the UNIQUE Function
How to Count Unique Values in Excel with the UNIQUE Function
goskills.com
Feb 21, 2021
UNIQUE Function
UNIQUE Function
exceljet.net
Aug 17, 2022
SUMIF & UNIQUE Function in Excel Comment your requests & questions for next tutorials! Follow for more!!! #SumIf #SumIfFunction #unique #UniqueFunction #CountIf #CountIfFunction#filterfunction #filter #excelformulas #excelfunctions #excelforbeginners #excelformula #exceltricks #excel_learning #exceltutoriales #excelpro #excelchallenge #excel #microsoftexcel #cursodeexcel #microsoft #office #msexcel #data #exceltips #aprenderexcel #microsoftoffice #powerbi #datascience #dataanalytics
1:14
SUMIF & UNIQUE Function in Excel Comment your requests & questions for next tutorials! Follow for more!!! #SumIf #SumIfFunction #unique #UniqueFunction #CountIf #CountIfFunction#filterfunction #filter #excelformulas #excelfunctions #excelforbeginners #excelformula #exceltricks #excel_learning #exceltutoriales #excelpro #excelchallenge #excel #microsoftexcel #cursodeexcel #microsoft #office #msexcel #data #exceltips #aprenderexcel #microsoftoffice #powerbi #datascience #dataanalytics
TikTokexcelwithnhel
228.1K viewsMay 21, 2023
2 Ways to Calculate Distinct Count with Pivot Tables - Excel Campus
2 Ways to Calculate Distinct Count with Pivot Tables - Excel Campus
Sep 9, 2020
excelcampus.com
Count unique values with criteria
Count unique values with criteria
2 months ago
exceljet.net
Count unique values in a range with COUNTIF
Count unique values in a range with COUNTIF
Aug 21, 2022
exceljet.net
How to Count Unique Rows with Power Query - Excel Campus
How to Count Unique Rows with Power Query - Excel Campus
Sep 16, 2020
excelcampus.com
Show Distinct Count in Excel Pivot Table
Show Distinct Count in Excel Pivot Table
Dec 15, 2020
pivot-table.com
How to count duplicates and unique values in Excel - TechRepublic
How to count duplicates and unique values in Excel - TechRepublic
Jul 2, 2014
techrepublic.com
Excel Pivot Tables Count Unique Items
Excel Pivot Tables Count Unique Items
Oct 8, 2020
contextures.com
1:45
Ways to count values in a worksheet
May 20, 2014
Microsoft
1:26
Mastering SQL: How to Count Records Only On Unique Column
3 months ago
YouTubevlogize
1:54
How to Count Unique Values in Multiple Columns of SQL Tables
4 months ago
YouTubevlogize
1:38
How to Get the Distinct Count of a Column in MySQL
4 months ago
YouTubevlogize
1:32
Count Distinct Values from Multiple Tables in Power BI with Ease!
4 months ago
YouTubevlogize
How to Count Distinct Values Across Multiple Columns in SQL
8 views9 months ago
YouTubevlogize
4:57
Count Distinct Values in Excel
15.1K viewsMay 10, 2020
YouTubeWareData
3:56
Power BI DISTINCT table or column function
8.5K viewsAug 3, 2020
YouTubeLife of Business Analyst
14:36
How to use COUNTIF and COUNTIFS in Microsoft Excel
1M viewsJan 27, 2020
YouTubeKevin Stratvert
0:26
How to count unique values Excel
238.2K viewsJul 24, 2018
YouTubeSpreadsheetWeb
5:24
Count duplicate values in excel | Using Formulas
218K viewsJan 8, 2021
YouTubeExcelTips
7:46
How To Use Count Distinct In An Excel Pivot Table Tutorial
938 viewsJan 31, 2020
YouTubeExcel Better
3:31
Distinct Count in Multiple Columns in Power BI
5.1K viewsAug 19, 2020
YouTubeRitesh Sharma
9:07
How to COUNT in Power BI // COUNT, COUNTA, DISTINCTCOUN…
126.4K viewsNov 4, 2020
YouTubeFernan | Power BI
2:36
Tableau - Number of Records or Count Rows
79.2K viewsJul 10, 2019
YouTubeJalayer Academy
3:47
How to count duplicate values in a column in Excel
5.7K viewsAug 26, 2020
YouTubeTheWindowsClub
3:23
SQL DISTINCT Statement | How to get unique values from a column i…
15.3K viewsOct 8, 2020
YouTubeThe Data Millennials
2:49
Excel Unique Count of Visible Rows - Episode 2399
24.4K viewsApr 11, 2021
YouTubeMrExcel.com
0:55
How to Count how many times do each value appear in a column in …
26.5K viewsMay 25, 2019
YouTubeVishap TVplus
7:42
How to Count Unique Rows with Power Query
49.7K viewsSep 17, 2020
YouTubeExcel Campus - Jon
4:59
Excel Basics: How to count the number of values in rows and colu…
25.1K viewsAug 23, 2017
YouTubeMaths and Stats
1:13
Excel Magic Trick 1115: PivotTable to Count How Many of Each Item T…
90.6K viewsMay 17, 2014
YouTubeexcelisfun
See more videos
Static thumbnail place holder