[TABLE="class: cms_table, width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Date[/TD]
[TD][/TD]
[TD]ID[/TD]
[TD]Date[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1/1/2015
[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1/11/2015[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1/10/2015
[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]2/17/2015[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1/14/2015[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]4/5/2015[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2/4/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2/8/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]3/11/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]4/1/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]4/7/2015
Hi:
I would like to have a formula that will look through a list of dates (column 2) and return the closest NEXT date to the date in the 5th column for each of the IDs. I have tried using INDEX MIN MATCH, but this is returning the most recent date, not the one closest.
Thank you![/TD]
[/TR]
</tbody>
[/TABLE]
<tbody>[TR]
[TD]ID[/TD]
[TD]Date[/TD]
[TD][/TD]
[TD]ID[/TD]
[TD]Date[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1/1/2015
[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1/11/2015[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1/10/2015
[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]2/17/2015[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1/14/2015[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]4/5/2015[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2/4/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2/8/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]3/11/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]4/1/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]4/7/2015
Hi:
I would like to have a formula that will look through a list of dates (column 2) and return the closest NEXT date to the date in the 5th column for each of the IDs. I have tried using INDEX MIN MATCH, but this is returning the most recent date, not the one closest.
Thank you![/TD]
[/TR]
</tbody>
[/TABLE]