Excel 2007 : advanced unique list

[erika_1978]

I have 3 columns of email addresses (A:C). there are repeats in all 3 columns sporadically. I have a work around by putting the following in coumn d: =IF(A1<>"",A1,";") for the first 30 rows with A1 increasing with each row. Then B1...C1...for 30 rows each also in column D. I then copy as values to column F, sort and advanced filter (check unique)... Does anyone have a formula to do it faster? Thanks in advance for any help.

[erika_1978]

here is a list of emails to play with:
1@email.com 2@email.com 3@email.com
2@email.com 1@email.com 3@email.com
1@email.com 2@email.com 5@email.com
2@email.com 1@email.com 2@email.com
2@email.com 4@email.com 4@email.com
1@email.com 6@email.com
4@email.com 2@email.com 1@email.com
1@email.com 1@email.com 1@email.com
3@email.com 2@email.com
6@email.com 5@email.com
5@email.com 7@email.com
8@email.com
9@email.com
10@email.com

[erika_1978]

HAHA, i found the coolest button ever! There's a "Remove Duplicates" button. Instead of sort and advanced filter (check unique)... just press the button and press enter. too bad i can't give it a range to delete veritically and horizontally but I'll just have to keep the formula columns i mentioned above for that..