Thread: count duplicates
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
Posts: 1,045
Default count duplicates
On Mon, 9 Apr 2012 18:20:37 -0700 (PDT), john taiariol wrote:

sorry but it doesn't seem to work, maybe i need to reword it, i would
like to count the number of unique entries....


=SUM(--(FREQUENCY(A:A,A:A)0))

Reply With QuoteReply With Quote