ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Counting and unduplicating values based on the date (https://www.excelbanter.com/excel-programming/454472-counting-unduplicating-values-based-date.html)

rtour957

Counting and unduplicating values based on the date
 
I have two columns table that has multiple codes and dates like below:
CP 1/1/2019
CP 1/22/2019
WK 1/1/2019
WK 1/1/2019
CP 1/22/2019
I need to count and unduplicate each value during the given month that is dependent on the date: if the code occurred on the same date (WK) above - I only count it once. If the code occurred on different dates - I count it twice unduplicating if need be..
The result for the table above shall look like this:

WK - 1
CP - 2 (counting one that occurred on 1/1/2019 and unduplicating CP that occurred twice on 1/22/2019

I'm struggling to come up with the formula or VBA that would do that.

Thank you,
Art


All times are GMT +1. The time now is 07:23 AM.

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