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. |
All times are GMT +1. The time now is 10:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com