Forum Discussion
Solved
Frequency of Unique phone numbers (11 digits)
I have a list of 708 rows of phone numbers with many duplicates. How do I determine how many unique phone numbers there are? In other words, how many different phone numbers texted me?
=SUMPRODUCT(1/COUNTIF(A2:A17,A2:A17))
This returns the count of unique numbers in my example.
=SUMPRODUCT(1/COUNTIF(A2:A17,A2:A17))
This returns the count of unique numbers in my example.