Here's another one that accounts for blank/empty cells (with error trap).

Array entered:

=IF(ROWS($1:1)<=SUM((A$1:A$10<"")/COUNTIF(A$1:A$10,A$1:A$10&"")),INDEX(A$1:A$10,SMAL L(IF(A$1:A$10<"",IF(ROW(A$1:A$10)-ROW(A$1)+1=MATCH(A$1:A$10,A$1:A$10,0),ROW(A$1:A$10 )-ROW(A$1)+1)),ROW(1:1))),"")

Biff

"SJT" wrote in message
...
On Sheet 1 of my worksheet in column A I have a list of names to which I
add
every week. Many of these are duplicates. On Sheet 2, I would like to
maintain an ongoing list of unique entries of column A from Sheet 1. Since
I
would like to be able to look at both the table that has the duplicates
and
also a table w/ the unique names (which will have different information),
a
filter of unique entries on Sheet 1 is not an ideal solution. How can I
accomplish this?


Example:

Sheet 1

Column A
ABC Company
XYZ Company
123 Company
ABC Company
XYZ Company

Results of Sheet 2

Column A
ABC Company
XYZ Company
123 Company


Thank you in advance for your assistance.