LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 18th 19, 10:48 PM
Junior Member
First recorded activity by ExcelBanter: Feb 2013
Posts: 16
Default 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,

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting unique values based on 2 columns Tee51 Excel Worksheet Functions 3 March 15th 12 02:32 PM
Counting values in one cell based on values in another S2 Excel Discussion (Misc queries) 7 April 18th 09 02:46 AM
Counting values based on multiple conditions Paul Excel Worksheet Functions 4 December 18th 08 08:01 PM
Counting based on values in two separate columns Wayne Excel Worksheet Functions 3 August 30th 06 07:43 PM
Counting based on values in two columns? Brother of Andrew Excel Worksheet Functions 4 November 18th 05 11:11 PM

All times are GMT +1. The time now is 08:24 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017