Count unique values with criteria
exceljet.net
Count unique values with criteria
To count unique values with one or more conditions, you can use a formula based on UNIQUE, LEN, and FILTER. In the example shown, the formula in H7 is: =SUM(--(LEN(UNIQUE(FILTER(B6:B15,C6:C15=H6,"")))>0)) which returns 3, since there are three unique names in B6:B15 associated with Omega. Note: this formula requires Dynamic Array Formulas ...
3 months ago
Microsoft Excel Excel Tips and Tricks
34K views · 517 reactions | Convert Excel into PDF | Microsoft Excel | Tips and tricks of Excel | Subscribe Youtube Channel for more videos https://youtube.com/@excelexpert7 #Excel #exceltips #exceltricks #excelexpert #excelprofessional #learnexcel #foryou #foryourpage #exceltraining #exceltutorial | Excel Expert | Facebook
0:34
34K views · 517 reactions | Convert Excel into PDF | Microsoft Excel | Tips and tricks of Excel | Subscribe Youtube Channel for more videos https://youtube.com/@excelexpert7 #Excel #exceltips #exceltricks #excelexpert #excelprofessional #learnexcel #foryou #foryourpage #exceltraining #exceltutorial | Excel Expert | Facebook
FacebookExcel Expert
16.5K views1 week ago
330K views · 14K reactions | 10 Awesome Microsoft #Excel Tips & Tricks | Excel Basement | Facebook
4:09
330K views · 14K reactions | 10 Awesome Microsoft #Excel Tips & Tricks | Excel Basement | Facebook
FacebookExcel Basement
330.5K views4 weeks ago
21 Excel Tips and Tricks to Make You a PRO in 2024 (Free PDF)
21 Excel Tips and Tricks to Make You a PRO in 2024 (Free PDF)
excelchamps.com
Jul 24, 2024
Top videos
Count unique values in a range with COUNTIF
Count unique values in a range with COUNTIF
exceljet.net
Aug 21, 2022
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
Count unique values
Count unique values
exceljet.net
Jan 6, 2025
Microsoft Excel Excel Formulas
101 Advanced Excel Formulas & Functions Examples
101 Advanced Excel Formulas & Functions Examples
myexcelonline.com
127K viewsMar 3, 2021
Bring AI to your formulas with the COPILOT function in Excel
Bring AI to your formulas with the COPILOT function in Excel
Microsoft BlogsCatherine_Pidgeon
6 months ago
Subtraction in Microsoft Excel
0:42
Subtraction in Microsoft Excel
YouTubeMicrosoft 365
510K viewsOct 3, 2019
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 Values in Excel with the UNIQUE Function
How to Count Unique Values in Excel with the UNIQUE Function
Feb 21, 2021
goskills.com
Count unique values
Count unique values
Jan 6, 2025
exceljet.net
Unique values with multiple criteria
Unique values with multiple criteria
Aug 2, 2022
exceljet.net
How to Count Unique Values in a Pivot Table
How to Count Unique Values in a Pivot Table
1 week ago
contextures.com
UNIQUE Function
UNIQUE Function
Aug 17, 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
Count unique numeric values with criteria
Oct 12, 2023
exceljet.net
How to count duplicates and unique values in Excel - TechRepublic
Jul 2, 2014
techrepublic.com
Count unique dates
Jul 11, 2022
exceljet.net
Count unique text values in a range
May 13, 2024
exceljet.net
2 Ways to Calculate Distinct Count with Pivot Tables - Excel Campus
Sep 9, 2020
excelcampus.com
2:29
How To Count Unique Values With Multiple Criteria In Excel?
2.1K viewsMar 30, 2022
YouTubeExtendOffice
0:36
How to Find and Count Unique Values in Excel with One Simple F…
14.5K viewsMay 27, 2023
YouTubeDestination2Future
4:39
Calculating the Number of Unique Numbers and Unique Values in a …
2K viewsJan 6, 2017
YouTubeDr. Todd Grande
5:11
How to get a distinct count of unique values in Excel
18.5K viewsSep 22, 2022
YouTubeNate Chamberlain
5:23
How to Use the UNIQUE Function in Exel - Tutorial
9.7K viewsMar 3, 2022
YouTubeY. Acosta Excel Tutorials
4:18
How to Count Unique Values (Distinct Count) in a Pivot Table i…
32.7K viewsJul 17, 2022
YouTubeMike Thomas
4:55
3 Easy Methods to Count Unique Values in Microsoft Excel
2.6K viewsNov 23, 2023
YouTubeMyExcelOnline.com
0:48
How to Count Only Unique Values Excluding Duplicates in Excel
52.3K viewsApr 12, 2023
YouTubeExcelHow Tech
2:34
How To Count Unique Items In Pivot Table In Excel
2.6K viewsMay 17, 2023
YouTubedptutorials
12:40
UNIQUE Function in Excel | DYNAMIC Unique Lists (7 Examples)
6.7K viewsMar 23, 2023
YouTubeComputergaga
1:20
How to Count Unique Values in Excel | How to Use the COUNTA a…
79.9K viewsSep 14, 2022
YouTubeExcel, Word and PowerPoint Tutorials from Ho…
15:34
How to Count Unique Values with Multiple Condition in Excel
66.7K viewsMay 8, 2021
YouTubeExcel Universe
2:31
2 ways to count unique values in Excel | First method is easy
211 viewsOct 24, 2022
YouTubeKundan Bhattarai
3:16
How to Count Number of Unique Values with criteria in Excel | Micr…
14.9K viewsOct 15, 2017
YouTubeMITutorials
3:18
Excel Trick - How To Count Unique Values In A Range With COUNTIF I…
30K viewsMar 17, 2018
YouTubedptutorials
3:55
How To Get Unique Values From Two Columns In Excel || Excel Tip…
107K viewsNov 8, 2019
YouTubedptutorials
0:26
How to count unique values Excel
239.9K viewsJul 24, 2018
YouTubeSpreadsheetWeb
See more videos
Static thumbnail place holder