How to find Duplicates between Sub Id Dates

[basavarajkh]

Hi

In Column A I have to find duplicates,

in that duplicates I want know about both dates are same or not, how to find?

Pls help me.


Thanks

Basavaraj K H

 

[basavarajkh]

Pls find the attachment


http://speedy.sh/w6duf/Find-the-Duplicates-between-Sub-Id-Dates.xls

 

[srinidhi]

Insert Pivot table, drag Subscriber Id & Dates in ROW Lables.Design subtotal donot show subtitle, If there are different dates in the SUB ID, only one date will have the SUB ID & the other will be blank.

 

[srinidhi]

One more, concatenate the SUBID & Date in Column C & apply this formula in Column D =IF(COUNTIF($C$2:C2,C2)>1, “Duplicate!”,”Original”)