One way...

Enter this formula in A1:

=MAX(H1:H100)

Enter this array formula** in A2 and copy down to A10:

=MAX(IF(H$1:H$100<A1,H$1:H$100))

Format as DATE

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)


--
Biff
Microsoft Excel MVP


"Adam" wrote in message
...
I would like to move just the latest ten dates that appear in a column (H)
into a smaller table on a different sheet. I have been using =LARGE but
there are repetitions of the same date throughout H on the bigger table.

Is this possible, can anyone advise?

Thanks