Finding Unique Dates

Kasey Mabary

I looking to find unique values, in order, and separate them into columns.

The "Client Update Date" column will contain dates, not in order and some dates may be duplicated. In the "1st Date Feedback I'm getting the correct date of 12/12/25 with the formula:

=MIN([Client Update Date]:[Client Update Date])

In the "2nd Date Feedback" I am unable to find a formula to retrieve the date 12/14/25, as that is the next unique value in the column. "3rd Date Feedback" should be 12/15/25 and "4th Date Feedback" should be 12/18/25.

Is there a way to capture these values in their respective columns?

Paul Newcome

You would use something along the lines of

=SMALL(DISTINCT(COLLECT([Client Update Date]:[Client Update Date], [Client Update Date]:[Client Update Date], @cell <> "")), 1)

The 1 at the end signifies the smallest (or earliest) date. Changing that to a 2 will give you the second smallest / earliest, so on and so forth.