Formula to Copy from one column to another and exclude duplicates

[Dena]

Is there a way to have Column B mirror whats in Column A but exclude any duplicates?

[canapone]

Hi,

are you working with numbers or strings (names for istance)?

Regards

[Dena]

Column A is a list of names which might be entered in more than once but in column B I only want them to show one time.

[canapone]

Hi,

In B2 (in A2:A1000 the list) to be confirmed with control+shift+enter

=IFERROR(INDEX($A$2:$A$1000,SMALL(IF(ISNUMBER(MATCH(ROW($A$2:$A$1000)-1,MATCH($A$2:$A$1000,$A$2:$A$1000,0),0)),MATCH($A$2:$A$1000,$A$2:$A$1000,0),""), ROW(A1))),"")

You could simply use a pivot table or an advanced filter too.

Attached a little example where I cannot use IFERROR (I'm using EXCEL 2000).

Hope that helps

[Dena]

Thank you, works perfectly.

[canapone]

Ciao,

thanks for the kind feedback.

Attached the 2010 version.

Cheers