Distinct Count Formula

[harinsh]

HI, I am looking for to get a distinct count formula in a given column. For example, I have a column which contains ID's (both text and number - String), I would like to get unique count...if one ID repeated twice then I should get only once in the formula.

Thank you,

 

[oldbrewer]

name

count

bill

tom

0

fred

zak

0

dave

jo

1

fred

fred

1

jo

bill

1

sam

sam

1

fred

bill

0 against tom got by

=IF(ISERROR(MATCH(F2,$A$2:$A$9,0)),0,1)

<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Fluff]

Have a look at this thread & see if it helps.
https://www.mrexcel.com/forum/excel-questions/1090284-sum-total-duplicated-items-list.html

 

[harinsh]

Thank you !! It works fine