Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Count including up to n duplicates
Hello everyone,
Can anyone think of a formula that will give me a total count of items in a range of cells while counting up to, but not more than, six duplicates? For example, if A1:A20 includes two duplicates of a certain value, four duplicates of another value, eight duplicates of another value, and six unique values, it will return a "count" of 18 (2 + 4 + 6 + 6). Thank you, Dan B. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not including duplicates in a count | Excel Discussion (Misc queries) | |||
Count Employee Work Time - Don't Count Duplicates | Excel Worksheet Functions | |||
How can I count numbers without including the repeated values? | Excel Discussion (Misc queries) | |||
count them number of cells between values -2 and 2 including 0 | Excel Discussion (Misc queries) | |||
count a group of numbers but do not count duplicates | Excel Worksheet Functions |