## Count unique distinct values

Excel » Count values » Count unique distinct values »

Count unique distinct values based on a condition

The following article demonstrates how to construct a formula that counts unique distinct values based on a condition. The image […]

Count unique distinct values that meet multiple criteria

This post demonstrates how to build an array formula that counts unique distinct values based on criteria. What's on this […]

Count unique distinct values within same week, month or year

The array formula in cell E3 counts unique distinct items for all dates within the same week. Example, week 2 […]

Count unique distinct months

The formula in cell D18 counts unique distinct months in cell range B3:B16. Formula in D18: =SUMPRODUCT((FREQUENCY(DATE(YEAR(\$B\$3:\$B\$16), MONTH(\$B\$3:\$B\$16), 1), DATE(YEAR(\$B\$3:\$B\$16), […]

Count unique distinct values in two columns

Formula in C12: =SUM(1/COUNTIF(\$B\$3:\$B\$8, \$B\$3:\$B\$8))+SUM(IF(COUNTIF(\$B\$3:\$B\$8, \$D\$3:\$D\$8)=0, 1/COUNTIF(\$D\$3:\$D\$8, \$D\$3:\$D\$8), 0)) How to create an array formula Double click on cell C12 […]

Count unique distinct values

This article describes how to count unique distinct values. What are unique distinct values? They are all values but duplicates are […]