Count Values with/ without Duplicates in EXCEL

Count the Unique values with one or two conditions.

are counting unique text values in a cell range.

Task of counting unique rows can be reduced to the problem of counting unique values in a one-column list.

To count unique rows in a table you can use the Advanced filter.

Having a list with duplicate values, you can enumerate the iterations of these values.

Find the number of unique numeric values in the specified multi-column range.

Find the number of non-repeating numeric values in the specified multi-column range.

are counting unique non-recurring text values not in the list, but only in a user-defined range.

are counting Text values that have duplicates.

will Produce a count of all duplicate values in a list containing duplicates. The range can contain text values and numbers.

are counting distinct values in a list containing duplicates. The range can contain text values and numbers.

Count the number of consecutive values in the column. Consider a non-repeating series of values (111222234444...) and repetitive (110111000010 and 110221010112).

are counting all repetitions in the lists of Numeric and Text values.

are counting Numeric values that have duplicates.

are counting unique numeric values. The range may contain blanks.