Hi

I'm posting this question on behalf of a colleague, so hope I have
understood the question correctly.

He has a spreadsheet with an ascending list of dates (column D). In column
A he is wanting to show the next date.

Example - Cell D2 = 7 September (07/09/2007) and the next date in the list
(Cell D3) is 11 September (11/09/2007).

In Cell A2, he wants to place a formula showing the next date (i.e. cell
D3), allowing for the fact that on some days there may be more than 1 row
with the same date, so will all need to be show in Column A.

Could anyone make any suggestions and if not clear on the question, please
don't hesitate to come back and ask.

Many thanks in advance.