I have a list of dates (max of 6 dates possible in one column) that I need to put in ascending order and also combine duplicate dates into one listing. Here is an example:
Original:
05/23/2008
02/02/2005
<blank>
06/14/2001
02/02/2005
<blank>
Formatted:
06/14/2001
02/02/2005
05/23/5008
<blank>
<blank>
<blank>
I need a formula that can do all of these steps at once. It would be EXTREMELY helpful. Thank you!
Bookmarks