Hey.

I wanīt excel to recognize when it sees the same date twice. For example:

At the first page I have:

22-04-2013
22-04-2013
23-04-2013
24-04-2013
25-04-2013
25-04-2013

At the second page, I want excel to make it look like this + sort them so that there are no spaces between them:

22-04-2013
23-04-2013
24-04-2013
25-04-2013

Iīve tried this:

"so you want to remove duplicates

assuming first page in sheet1 A2:A400

And result 2nd page to go into Sheet2 A2

=INDEX(Sheet1!$A$2:$A$400, MATCH(0, COUNTIF($A1:A$1, Sheet1!$A$2:$A$400), 0))
use
Control + Shift + enter to change to an array formula so you get {}"

Didnīt work.

Any ideas?

Thank you.