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.
Bookmarks