Dan,

For example, in cell C1:

=MAX(A1:A100)

In cell C2, array enter (enter using Ctrl-Shift-Enter)
=MAX(($A$1:$A$1000<C1)*$A$1:$A$1000)

and then copy C2 to C3:C5.

HTH,
Bernie
MS Excel MVP


"Dan" wrote in message
...
I have a list of 100 dates (some are duplicate) - how do I find the 5 most
recent unique dates?
Many thanks,
Dan