Hi Christian,

Am Tue, 2 Apr 2013 11:57:32 +0000 schrieb Christian Michael:

EXAMPLE
A
1 Smith
2 Smith
3 Johnson
4 Davis
5 Johnson
6 Davis

FARMED

A
1 Davis
2 Johnson
3 Smith

And could this be done to be automatically updating, or would it only be
a one-time function?

if you have headers you can use advanced filter without duplicates. In
case of changes you have to do it again.
You can also do it with formula.
Your data in column A, then e.g. in C1:
=A1
In C2:
=IF(SUM(COUNTIF(A$1:A$99,C$1:C1))=SUM((A$1:A$99< "")*1),"",INDEX(A:A,MATCH(1,(COUNTIF(C$1:C1,A$1:A$ 99)=0)*(A$1:A$99<""),0)))
and enter this array formula with CTRL+Shift+Enter
and copy down


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2