Good morning,
I looking for some pointers on how to approach this problem:
3 columns - A for name, B for policy, C for effective date, D for expiration date
There are multiple rows with different effective/expiration dates for each policy and/or name.
ie.
Name Policy Eff Date Exp Date
John AB1234 12/1/05 12/1/06
John AB1233 12/1/04 12/1/05
John AB1232 12/1/03 06/31/04
Notice the gap between policies AB1232 and AB1233. Starting from the most recent policy, how would I go about finding the earliest policy with no gaps in between? In this case, it would identify AB1233.
I've searched this forum and think it might have to do with arrays. Unfortunately I have limited experience with arrays and would like some pointers on how to solve this problem.
Thanks for any help that I can get.
I looking for some pointers on how to approach this problem:
3 columns - A for name, B for policy, C for effective date, D for expiration date
There are multiple rows with different effective/expiration dates for each policy and/or name.
ie.
Name Policy Eff Date Exp Date
John AB1234 12/1/05 12/1/06
John AB1233 12/1/04 12/1/05
John AB1232 12/1/03 06/31/04
Notice the gap between policies AB1232 and AB1233. Starting from the most recent policy, how would I go about finding the earliest policy with no gaps in between? In this case, it would identify AB1233.
I've searched this forum and think it might have to do with arrays. Unfortunately I have limited experience with arrays and would like some pointers on how to solve this problem.
Thanks for any help that I can get.