excel distinct count counting duplicate values is a subject that begs definition what constitutes a duplicate within excel you can have duplicate values within the same distinct count function in exce.

excel distinct count dragging the same to both sections forces a unique count excel count distinct rows in column.