Try this:

With
Sheet1, cells A1:A10 contaiining a list of names (some duplicated)

Then
On Sheet2
D1: NameList

Enter this ARRAY FORMULA:
D2:
=IF(SUM((Sheet1!$A$1:$A$10<"")*ISERROR(MATCH(Shee t1!$A$1:$A$10,$C$1:C1,0)))<0,INDEX(Sheet1!$A$1:$A $10,MATCH(1,--ISERROR(IF(ISBLANK(Sheet1!$A$1:$A$10),0,MATCH(Shee t1!$A$1:$A$10,$C$1:$C1,0))),0),1),"")

Or...if you want the list on Sheet1..
use this shorter version of the formula
D2:
=IF(SUM(($A$1:$A$10<"")*ISERROR(MATCH($A$1:$A$10, $D$1:D1,0)))<0,INDEX($A$1:$A$10,MATCH(1,--ISERROR(IF(ISBLANK($A$1:$A$10),0,MATCH($A$1:$A$10, $D$1:$D1,0))),0),1),"")

Note: For array formulas, hold down [Ctrl] and [Shift] when you press
[Enter], instead of just pressing [Enter].

Copy D2
Paste into D3 and down as far as you need

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"SJT" wrote:

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.