| 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 | |||
Linear Mode
