Finding The Minimum of Consecutive Dates

nichihan

New Member
Joined
Dec 30, 2005
Messages
2
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.
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

nichihan

New Member
Joined
Dec 30, 2005
Messages
2
Below is a better example of what I'm working with.

Code:
Insured Name	Policy	Pol Eff Date	Pol Exp Date
John	BA1277928927	4/20/95	4/20/96
John	BA1292848928	4/20/96	4/20/97
John	BA1315358929	4/20/97	4/20/98
John	BA1345728930	4/20/98	4/20/00
John	BA1412388931	4/20/00	4/20/01
John	BA1457618932	4/20/01	4/20/02
John	BA1497058933	4/20/02	4/20/03
John	BA1542948934	4/20/03	4/20/04
John	BA1586488935	4/20/04	4/20/05
John	BA1586488936	4/20/05	4/20/06
Steve	BA12472311544	10/6/91	10/6/92
Steve	BA12534511545	10/6/92	10/6/93
Steve	BA12616211546	10/6/93	10/6/94
Steve	BA12726411547	10/6/94	10/6/95
Steve	BA13005311548	10/6/96	10/6/97
Steve	BA13288911549	10/6/97	10/6/98
Steve	BA13594211550	10/6/98	10/6/99
Steve	BA14263211551	10/6/00	10/6/02
Steve	BA15177711552	10/6/02	10/6/03
Steve	BA15639111553	10/6/03	10/6/04
Steve	BA15639111554	10/6/04	9/1/05
Steve	BA15639111555	9/1/05	10/1/06
 

Watch MrExcel Video

Forum statistics

Threads
1,119,265
Messages
5,577,094
Members
412,766
Latest member
BigRusty82
Top