Thank you Max.

Unfortunately my colleague advises that I have misunderstood slightly what
he requires.

Where I stated that in the dates column, column D, there may be some
instances occurring where the same date occurs in more than one row of that
column, he has advised he is only requiring to know the first occurrence to
be shown in column A.

Hope this makes sense.

Many thanks.

Ellie

"Max" wrote:

One play using non-array formulas which will deliver the desired dynamic
unique listing of dates in source col E ..

Source dates assumed running in D2 down

In A2:
=IF(E2="","",IF(COUNTIF(E$2:E2,E2)1,"",ROW()))
Leave A1 blank

In B2:
=IF(ROWS($1:1)COUNT(A:A),"",INDEX(E:E,SMALL(A:A,R OWS($1:1))))
Format B2 as date. Select A2:B2, copy down to cover the max expected extent
of data in col E. Hide away col A. Col B will dynamically return the desired
unique list of dates in col E, all neatly bunched at the top.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ellie" wrote:
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.