Counting Unique Numeric Values or Unique Data in a List in Microsoft Excel

In this article, we will learn how to count the unique numeric values or unique data in a list. We can use two types of combinations of formulas in Mi...

How to use COUNTA function in Microsoft Excel

To count the number of cells containing data in a range in Microsoft Excel we will use COUNTA function. COUNTA:This function is used for count the no...

Counting Values that Appear Only Once in

Problem: Counting the number of values in List1 (column A) that appear only once within the list. Solution: Use the SUM, IF, and COUNTIF func...

Counting the Number of Times a Specified Substring Appears within a Range of Strings

Problem: Counting the total number of times each of the substrings listed in column B appears within any of the strings in column A. Solution: ...

Counting Rows of Even Numbers in Two Parallel Ranges

In this article, we are going to learn how to count rows of even numbers in two parallel ranges in Microsoft Excel. To solve this problem, we will us...

Counting the Number of Players According to Their Score in a Particular Quarter

Problem: Finding the number of players (column A) who scored over 3 points (column C) in the first quarter (column B). Solution: Use the SUMP...

Count of uniques among duplicates

If you have a sheet containing duplicate numbers and you want the count of unique numbers, try this formula = =SUM(SIGN(FREQUENCY(A1:A7,A1:A7))) ...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.