View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DOUG ECKERT[_2_] DOUG ECKERT[_2_] is offline
external usenet poster
 
Posts: 66
Default Counting Unique Values with Duplicates

May I ask a question about these formulas please?

=SUMPRODUCT(--(A2<A$2:A$11),1/COUNTIF(A$2:A$11,A$2:A$11))+1

Versus

=SUM(IF(FREQUENCY(MATCH(B2:B10,B2:B10,0),MATCH(B2: B10,B2:B10,0))0,1))

I am counting a list of names in a column. For example, the first three
rows of "Johnny Jones" would count as one occurence. The next five rows of
"Janey Smith" would count as two, and so on. The second formula above should
work, but it designates the first set of occurences as "102" and works
backward from there. The numbering sequence should be 1, 2, 3, etc. Please
advise.