Sort list

[Guest]

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!

 

[Roger Govier]

Hi Arne

If you mark just the column of dates then use
Data>Filter>Advanced Filter>click unique values only>Copy to New
Location>Sheet2!A1
you will get a filtered list with no repeats of date.