ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Sort list (https://www.excelbanter.com/excel-worksheet-functions/127653-sort-list.html)

Arne Hegefors

Sort list
 
Hi! I have a long list of dates. Some of these dates occur many times in the
list (it is however in date order). I want to clean that list so that I have
a list containing only unique dates. In other words I just want to have one
occurrence of each date. How can I do this? Please help me! Many thanks in
advance!

SteveW

Sort list
 
Use Data Data, Advanced Filter...

Steve

On Thu, 25 Jan 2007 07:56:02 -0000, Arne Hegefors
wrote:

Hi! I have a long list of dates. Some of these dates occur many times in
the
list (it is however in date order). I want to clean that list so that I
have
a list containing only unique dates. In other words I just want to have
one
occurrence of each date. How can I do this? Please help me! Many thanks
in
advance!



All times are GMT +1. The time now is 06:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com