I believe you can get the same result with

=IF(COUNTIF($A$1:$A1,$A1)=1,$A1,"")

copied down


"Teethless mama" wrote:

Try this:
=IF(ISERR(SMALL(IF(COUNTIF($A$1:$A1,$A1)=1,ROW(IND IRECT("1:"&ROWS($A$1:$A$5)))),ROWS($1:1))),"",INDE X($A$1:$A$5,SMALL(IF(COUNTIF($A$1:$A1,$A1)=1,ROW(I NDIRECT("1:"&ROWS($A$1:$A$5)))),ROWS($1:1))))

ctrlshiftenter (not just enter)


"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.