View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to create a list of unique dates?

[List of dates]
14-Jun,14-Jun,17-Jun,15-Jun,23-Jun,16-Jun,26-Jun,17-Jun,05-Jul,19-Jun

There is a list of dates under column A, does anyone have any suggestion on
how to create a list of unique dates as show below? but I don't want to use
Data, Filter, Advanced Filter. Does anyone have any suggestions?
Thank for any suggestions
Eric

[Unique dates]
14-Jun,15-Jun,16-Jun,17-Jun,19-Jun,23-Jun,26-Jun,05-Jul