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!