Try:

=SUM(1/COUNTIF(C2:C13,C2:C13))

Enter as an array formula (Ctrl/Shift/Enter)

Don


"shafali" wrote in message
...
I want to count the number of persons who have done transactions in a
particular range where one person has done many transactions