Hello all,
Please help me with the below request. In the below table there are some date and Serial numbers. What i want is that count of serial numbers which re-appeared within 30 days from Date. Ex: The Serial number which appeared on 8/6/2013 L3AAB8Y - 350M same as reappeared within 30 days on 9/1/2013 and that should be counted. However another serial number which is appeared on 8/1/2013 L3AGD7K - 35ZG is again reappeaed after 30 days should not be counted.
I hope i have explained my situation clearely here. Advance thanks ...NG
[TABLE="class: grid, width: 500"]
Date
[/td]Combine Serial
[/td]8/6/2013
[/td]L3AAB8Y - 350M
[/td]8/7/2013
[/td]L3AGD7K - 23JC
[/td]8/1/2013
[/td]L3AGD7K - 35ZG
[/td]8/8/2013
[/td][TABLE="width: 185"]
[TD="align: right"]
L3AGF8Y - 3FLP
[/td][/TABLE]
[/TD]
9/1/2013
[/td]L3AAB8Y - 350M
[/td]9/1/2013
[/td]L3AGD7K - 23JC
[/td]9/10/2013
[/td]L3AGD7K - 35ZG
[/td]
[/TABLE]