Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sum unique values among duplicates horizontally | Excel Worksheet Functions | |||
How to remove duplicates and combine their unique values? | Excel Discussion (Misc queries) | |||
Sum duplicates unique values and delete dupliques | Excel Worksheet Functions | |||
check for duplicates, then sum unique values | Excel Discussion (Misc queries) | |||
Count Unique Values In A Filtered Row with Duplicates | Excel Discussion (Misc queries) |