=UNIQUE(P:P)

[j4ymf]

Hello All

If i have a unique reference for a date, how would i re write it so that it sorts in ascending order.
=UNIQUE(P:P)

many thanks Jason

 

[Fluff]

How about

=sort(UNIQUE(P:P))

 

[j4ymf]

Hi Fluff

Thanks for coming back to me, column P:P has dates from last week, the result of that formula returns and it puts the 1st at the top of the list but i would like the 1st at the bottom, any ideas.

 

[Fluff]

That sounds as though your dates are really text & not real dates.