All
Search
Images
Videos
Maps
News
More
Shopping
Flights
Travel
Notebook
Report an inappropriate content
Please select one of the options below.
Not Relevant
Offensive
Adult
Child Sexual Abuse
Length
All
Short (less than 5 minutes)
Medium (5-20 minutes)
Long (more than 20 minutes)
Date
All
Past 24 hours
Past week
Past month
Past year
Resolution
All
Lower than 360p
360p or higher
480p or higher
720p or higher
1080p or higher
Source
All
Dailymotion
Vimeo
Metacafe
Hulu
VEVO
Myspace
MTV
CBS
Fox
CNN
MSN
Price
All
Free
Paid
Clear filters
SafeSearch:
Moderate
Strict
Moderate (default)
Off
Filter
exceljet.net
Count unique numeric values with criteria
To count unique numeric values in a range, you can use a formula based on the FREQUENCY, SUM, and IF functions. In the example shown, employee numbers appear in the range B5:B14. The formula in G6 is: =SUM(--(FREQUENCY(IF(C5:C14="A",B5:B14),B5:B14)>0)) which returns 2, since there are 2 unique employee ids in building A. Note: this is an array ...
Oct 12, 2023
Excel Tutorial Videos
26:26
How to use Formulas and Functions in Microsoft Excel
YouTube
Teacher's Tech
462.1K views
Apr 19, 2021
11:47
Advanced Pivot Table Techniques (to achieve more in Excel)
YouTube
Leila Gharani
2.3M views
Apr 8, 2021
7:57
Microsoft Excel Tutorial for Beginners #4 - Functions (Formulas)
YouTube
MotionTraining
1.3M views
Apr 28, 2008
Top videos
Count unique numeric values in a range
exceljet.net
Oct 25, 2023
Count missing values
exceljet.net
Apr 30, 2023
Count unique values with criteria
exceljet.net
2 months ago
How to Use Countifs Function
5:31
COUNTIFS function
Microsoft
May 20, 2014
COUNTIFS Function
exceljet.net
7 months ago
COUNTIF Function
exceljet.net
Apr 1, 2024
Count unique numeric values in a range
Oct 25, 2023
exceljet.net
Count missing values
Apr 30, 2023
exceljet.net
Count unique values with criteria
2 months ago
exceljet.net
Count Cells that are Not Blank (Non-Empty) (COUNTIF-COUNTIFS)
Sep 30, 2024
excelchamps.com
COUNTIF with non-contiguous range
Oct 26, 2022
exceljet.net
Count non-blank cells by category
Aug 21, 2022
exceljet.net
COUNTA Function
Oct 25, 2022
exceljet.net
Filter exclude blank values
Aug 23, 2023
exceljet.net
Count cells with #N/A error - Excel | Exceldome
Sep 24, 2022
exceldome.com
Count cells that contain numbers
Aug 17, 2022
exceljet.net
Count cells between two numbers
Aug 15, 2022
exceljet.net
Count cells not equal to
Oct 26, 2022
exceljet.net
Count cells that are not blank
Sep 25, 2023
exceljet.net
Count cells not between two numbers
Aug 17, 2022
exceljet.net
Count cells that do not contain
11 months ago
exceljet.net
How to Count Cells in Microsoft Excel
Nov 22, 2021
howtogeek.com
Count cells that do not contain many strings
Aug 21, 2022
exceljet.net
How to Count Cells with Text in Excel? 3 Different Use Cases
Jul 5, 2022
simonsezit.com
Separate Text and Numbers in Excel (4 Easy Ways)
Mar 3, 2022
trumpexcel.com
Most frequently occurring text
Apr 25, 2022
exceljet.net
Sum if not blank
8 months ago
exceljet.net
1:45
Ways to count values in a worksheet
May 20, 2014
Microsoft
Only calculate if not blank
Oct 26, 2022
exceljet.net
1:28
COUNT function
May 20, 2014
Microsoft
8:58
3 SIMPLE STEPS to Solve Non-Numeric Data Error in Excel Statis
…
120 views
1 month ago
YouTube
Research Pedia
0:26
Exel serial number shortcuts | exel basic shortcuts #exel
534 views
1 week ago
YouTube
Ditwithumar
1:46
#shorts Excel COUNT & COUNTA Explained | Beginner Excel Day 9
…
2 views
1 week ago
YouTube
ExcelLearn
1:33
How to Count Non-Numeric Cells in Excel Based on Criteria in Anothe
…
3 months ago
YouTube
vlogize
Excel Solution - Facebook Working with Non-numeric, blank, and zer
…
1.8K views
Sep 14, 2019
YouTube
Prof. John Gallaugher
See more videos
More like this
Feedback
Feedback