D
DOUG ECKERT
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.
=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.