ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Count including up to n duplicates (https://www.excelbanter.com/excel-worksheet-functions/268791-count-including-up-n-duplicates.html)

dan_boisvert

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.


All times are GMT +1. The time now is 05:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com