Question: what is the difference between count and distinct count in excel?
Answer: Count unique and distinct rows in Excel Counting unique / distinct rows in Excel is akin to counting unique and distinct values, with the only difference that you use the COUNTIFS function instead of COUNTIF, which lets you specify several columns to check for unique values.