How can I display unique values from a list in Excel 2003 without using advanced filter?

I’m trying to create a separate list of unique names from a list of names containing duplicates without using the advanced filter option in Excel 2003.

I tried using =IF(COUNTIF($T$8:$T$102,T8)=1,T8," "), however this returns the names that are listed only once instead of listing a duplicate name once and then not again in the column.

Here’s an example of the list:

Mary
Bob
Jane
Chris
Michael
Bob
Michael
Mary

Any advice on how to do this?

This tutorial show you How to extract a unique distinct list from a column in excel (without using advanced filter)

http://www.get-digital-help.com/2009/03/30/how-to-extract-a-unique-list-and-the-duplicates-in-excel-from-one-column/

The formula is:
=INDEX(List,MATCH(0,COUNTIF($B$1:B1,List),0))+ CTRL + SHIFT + ENTER and copy it down as far as necessary.

where LIST is a named range for the data to filter
more information about named range http://www.contextures.com/xlNames01.html

Related posts:

1. How do you use the advanced filter in excel for mac?
2. I am using the advanced filter feature in Excel, I want to choose a register and then delite it?
3. How to use Advanced Filter in Excel?
4. Excel Advanced Help?
5. Can I use a vlookup formula to return multiple values?