Sort list
 

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!

Sort list
 

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!