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 have attached the spreadsheet with data.
I hope i have explained my situation clearely here. Advance thanks ...NG
Bookmarks