Hello,

I am having a excel sheet as a sample shown below, with some duplicated values in column A and column B and dates in another column C, based on the occurence of the date the counts need to be incremented on the duplicated values,

If the values in column A & B are same based on the dates the occurrence in column D the count is to be printed and needs to be incremented.The number of rows are not fixed.

Kindly do help me out to solve this. Thanks in advance

A B C D
type1 str1 28.10.2012 1
type2 amd1 29.11.2012 1
type3 str2 15.12.2012 1
type3 str2 05.02.2013 2
type1 str1 10.03.2013 2
char2 rds2 15.05.2014 1
type3 str2 17.05.2014 3
type3 str2 21.8.2014 4
type3 str4 08.09.2014 1
type3 str2 15.10.2014 5