Hi Arne

If you mark just the column of dates then use
DataFilterAdvanced Filterclick unique values onlyCopy to New
LocationSheet2!A1
you will get a filtered list with no repeats of date.

--
Regards

Roger Govier


"Arne Hegefors" wrote in
message ...
Hi! I have a long list of dates and corresponding values to each date.
The
problem is that sometimes there are multiple occurences of a single
date. The
list is sorted by date. I want to create a new list based on the old
one but
where I have only the first occurence of a date. How can I do this
using
worksheetfunctions or a macro? I tried =if(A9=A8;A10;A9) but the
problem is
that there can be many repetitions of a single date ie I does not work
to use
many if(..if(..)) etc. Please help! Thanks alot in advance!