No duplicated dates, put in same row.

[DugiDug]

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.

[Fotis1991]

Formula works great!

Do you confirm this as an ARRAY formula?

[DugiDug]

Dosnīt work. Also I have to convert it into danish version of excel. At the moment I get an error when I use that formular.

Ok, Iīll try to explain it with exactly my data now:

All in same sheet.

A13:A3000 is the colum where the duplicated dates are.

N13:N3000 is where I wanīt the results to be, without spaces between the removed duplicates.

[Fotis1991]

Upload a small sample workbook,pls.

[Fotis1991]

OK.....

Don't waste our time posting dublicate threads. It's not kind at all!

http://www.excelforum.com/excel-form...-in-a-row.html

[arlu1201]

Thanks Fotis.

Thread closed.