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
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
How to Count Unique Rows with Power Query - Excel Campus
How to Count Unique Rows with Power Query - Excel Campus
excelcampus.com
Sep 16, 2020
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
0:27
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
FacebookExcel Basement
12.1K views9 months ago
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 in a range with COUNTIF
Count unique values in a range with COUNTIF
exceljet.net
Aug 21, 2022
Count unique values with criteria
Count unique values with criteria
exceljet.net
4 months ago
Excel Unique Values
Unique values with criteria
Unique values with criteria
exceljet.net
Aug 26, 2022
Unique values with multiple criteria
Unique values with multiple criteria
exceljet.net
Aug 2, 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 in a range with COUNTIF
Count unique values in a range with COUNTIF
Aug 21, 2022
exceljet.net
Count unique values with criteria
Count unique values with criteria
4 months ago
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
Count Unique Values by Group in R (3 Examples) | Distinct Numbers
Count Unique Values by Group in R (3 Examples) | Distinct Numbers
Mar 18, 2022
statisticsglobe.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
How to Count Unique Values in a Pivot Table
1 month ago
contextures.com
Count of Unique Values (DistinctCount) in Power BI Throu…
Feb 26, 2020
radacad.com
4:57
Count Distinct Values in Excel
15.1K viewsMay 10, 2020
YouTubeWareData
5:07
Count & CountD functions in Tableau
36.1K viewsFeb 11, 2021
YouTubeData with Tableau Tim
3:56
Power BI DISTINCT table or column function
8.6K viewsAug 3, 2020
YouTubeLife of Business Analyst
12:18
DAX Fridays #12: SUM of distinct values
73K viewsOct 28, 2016
YouTubeCurbal
0:26
How to count unique values Excel
242.4K viewsJul 24, 2018
YouTubeSpreadsheetWeb
5:24
Count duplicate values in excel | Using Formulas
220.6K viewsJan 8, 2021
YouTubeExcelTips
3:27
How to add unique count to a pivot table
91K viewsJan 17, 2019
YouTubeExceljet
1:38
How to Count Unique Records in a Microsoft Access Database : Micr…
80.9K viewsOct 26, 2013
YouTubeeHowTech
7:46
How To Use Count Distinct In An Excel Pivot Table Tutorial
940 viewsJan 31, 2020
YouTubeExcel Better
6:10
Excel COUNTIF | Multiple Criteria | Greater than or Less Than
247.8K viewsFeb 18, 2020
YouTubeWork Smarter Not Harder
9:07
How to COUNT in Power BI // COUNT, COUNTA, DISTINCTCOUN…
128.1K viewsNov 4, 2020
YouTubeFernan | Power BI
2:36
Tableau - Number of Records or Count Rows
79.2K viewsJul 10, 2019
YouTubeJalayer Academy
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.9K viewsApr 11, 2021
YouTubeMrExcel.com
2:24
Power BI: DAX How to Count the Total Rows of a Table
64.1K viewsSep 8, 2020
YouTubeSimon Sez IT
1:46
SQL SELECT DISTINCT statement (return different values) | SQL Tut…
20.8K viewsJun 14, 2021
YouTubeAmit Thinks
5:56
Access: create summary queries with the count option
85.5K viewsMar 1, 2017
YouTubeSmyth Academy
7:42
How to Count Unique Rows with Power Query
50.4K viewsSep 17, 2020
YouTubeExcel Campus - Jon
4:59
Excel Basics: How to count the number of values in rows and colu…
25.2K viewsAug 23, 2017
YouTubeMaths and Stats
1:13
Excel Magic Trick 1115: PivotTable to Count How Many of Each Item T…
92.3K viewsMay 17, 2014
YouTubeexcelisfun
See more videos
Static thumbnail place holder