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 ...
6 months ago
Excel Formulas Tutorial
Top Excel Formulas With Examples (Free Cheat Sheet)
Top Excel Formulas With Examples (Free Cheat Sheet)
simplilearn.com
Sep 24, 2020
30 Excel Formulas Every Beginner Must Know | Excel Formulas Tutorial
15:36
30 Excel Formulas Every Beginner Must Know | Excel Formulas Tutorial
YouTubeVedakarna
1.8K views2 months ago
Basic Excel Formulas and Functions | Basic Excel For Beginners Tutorial | Basic MS Excel Formulas
11:06
Basic Excel Formulas and Functions | Basic Excel For Beginners Tutorial | Basic MS Excel Formulas
YouTubeComrevo
5.3K viewsJan 14, 2021
Top videos
✅ 22 Basic Excel Formula’s in Microsoft Excel! Learn the most useful Excel formulas every beginner must know! 📊✨ From calculations to text functions — these 22 formulas will make your work faster and smarter. 🚀 --- 📘 Description: Master the 22 most essential Excel formulas used in offices, schools, and businesses. Whether you’re a student, accountant, or data entry operator, these formulas will help you save time and improve accuracy. Perfect for boosting your Excel skills and working like a
0:15
✅ 22 Basic Excel Formula’s in Microsoft Excel! Learn the most useful Excel formulas every beginner must know! 📊✨ From calculations to text functions — these 22 formulas will make your work faster and smarter. 🚀 --- 📘 Description: Master the 22 most essential Excel formulas used in offices, schools, and businesses. Whether you’re a student, accountant, or data entry operator, these formulas will help you save time and improve accuracy. Perfect for boosting your Excel skills and working like a
Facebooklearn Excel with Bapi Sardar
26.8K views5 months ago
Learn Basic Formulas for Excel
Learn Basic Formulas for Excel
corporatefinanceinstitute.com
Mar 6, 2025
Value exists in a range
Value exists in a range
exceljet.net
May 11, 2024
Excel Tips and Tricks
I'll Make You a Spreadsheet Pro. Try My 50 Favorite Excel Tricks
I'll Make You a Spreadsheet Pro. Try My 50 Favorite Excel Tricks
pcmag.com
1 month ago
10 Excel Tricks and Tips | Learn Ms-Excel Shortcuts and Formulas
10:31
10 Excel Tricks and Tips | Learn Ms-Excel Shortcuts and Formulas
YouTubeShort and Clear Excel
99.6K viewsAug 14, 2023
Top 100 Excel Tips and Tricks to Make You Productive in 2026
Top 100 Excel Tips and Tricks to Make You Productive in 2026
excelchamps.com
Jul 24, 2024
✅ 22 Basic Excel Formula’s in Microsoft Excel! Learn the most useful Excel formulas every beginner must know! 📊✨ From calculations to text functions — these 22 formulas will make your work faster and smarter. 🚀 --- 📘 Description: Master the 22 most essential Excel formulas used in offices, schools, and businesses. Whether you’re a student, accountant, or data entry operator, these formulas will help you save time and improve accuracy. Perfect for boosting your Excel skills and working like a
0:15
✅ 22 Basic Excel Formula’s in Microsoft Excel! Learn the most u…
26.8K views5 months ago
Facebooklearn Excel with Bapi Sardar
Learn Basic Formulas for Excel
Learn Basic Formulas for Excel
Mar 6, 2025
corporatefinanceinstitute.com
Value exists in a range
Value exists in a range
May 11, 2024
exceljet.net
Learn basic formulas and functions of Excel in 5 minutes
8:23
Learn basic formulas and functions of Excel in 5 minutes
36.4K viewsJan 22, 2025
humix.com
Use Excel as your calculator
0:28
Use Excel as your calculator
May 20, 2014
Microsoft
Ways to count values in a worksheet
1:45
Ways to count values in a worksheet
May 20, 2014
Microsoft
Subtraction in Microsoft Excel
0:42
Subtraction in Microsoft Excel
522.6K viewsOct 3, 2019
YouTubeMicrosoft 365
14:56
How to Use SUMPRODUCT in Excel
832.8K viewsApr 13, 2016
YouTubeLeila Gharani
2:58
How to use the VLOOKUP function in Excel
5M viewsSep 28, 2018
YouTubeTechOnTheNet
3:13
Excel 2013: Simple Formulas
252.1K viewsJun 10, 2013
YouTubeLearnFree
0:38
How to use the SUM function in Microsoft Excel
3M viewsDec 4, 2019
YouTubeMicrosoft 365
3:47
Excel 2010: Simple Formulas
498.8K viewsNov 18, 2010
YouTubeLearnFree
5:41
Finance Basics 1 - Simple Interest in Excel
139.8K viewsNov 21, 2009
YouTubeTeachExcel
4:07
Sum the Top 5 Values - Excel Formula
62.1K viewsJan 7, 2018
YouTubeComputergaga
31:35
Excel Tables - Formulas, Basic to Advanced
44.5K viewsJun 29, 2020
YouTubeLearn Google Sheets & Excel Spreadsheets
7:43
Sum Values by Weekday in Excel
27.3K viewsOct 15, 2018
YouTubeComputergaga
8:48
Beginner's Guide to Excel Functions and Formulas
135K viewsMay 11, 2020
YouTubeTechnology for Teachers and Students
5:53
Excel Basics - Linear Regression - Finding Slope & Y Intercept
1.2M viewsMay 29, 2018
YouTubeThe Organic Chemistry Tutor
7:53
Excel SUM and SUMIF Formula in Excel
410.3K viewsDec 11, 2019
YouTubeKevin Stratvert
14:36
How to use COUNTIF and COUNTIFS in Microsoft Excel
1M viewsJan 27, 2020
YouTubeKevin Stratvert
21:57
15 IF Statement Examples in Excel - Simple to Advanced - Workbook I…
656.6K viewsFeb 21, 2018
YouTubeTeachExcel
4:45
Excel Formulas and Basic Functions (Beginner Tutorial)
3.1K viewsMar 11, 2019
YouTubeExcel with Business
7:01
Excel Dynamic Arrays (How they will change EVERYTHING!)
787.3K viewsOct 18, 2018
YouTubeLeila Gharani
26:26
How to use Formulas and Functions in Microsoft Excel
475.2K viewsApr 19, 2021
YouTubeTeacher's Tech
1:48
Find First Value greater than zero in a MS Excel list
14.3K viewsFeb 20, 2020
YouTubeAuditExcel Advanced Excel and Financial Mode…
5:24
Count duplicate values in excel | Using Formulas
222.1K viewsJan 8, 2021
YouTubeExcelTips
10:47
Excel Formulas and Functions You NEED to KNOW!
951.9K viewsFeb 11, 2021
YouTubeLeila Gharani
5:46
How To Create A Random Sample In Excel (2 Methods!)
144.1K viewsJul 14, 2021
YouTubeSteven Bradburn
12:40
Excel FILTER Function Explained (7 Examples) | Filter and Extract Dat…
127.8K viewsFeb 13, 2020
YouTubeTrumpExcel
See more videos
Static thumbnail place holder