Here is one way, but it does show all of the repetitions as well

Select a range of cells in an adjacent column. Then in the formula bar enter

=IF(ISERROR(SMALL(IF(COUNTIF($A$1:$A$20,$A$1:$A$20 )1,ROW($A1:$A20),""),ROW(
$A1:$A20))),"",
INDEX($A$1:$A$20,SMALL(IF(COUNTIF($A$1:$A$20,$A$1: $A$20)1,ROW($A1:$A20),"")
,ROW($A1:$A20))))

and commit with Ctrl-Shift-Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Alphabet" wrote in
message ...

Hello

i need help in what formula or best way it would be to create a
seperate list from several, on a number of my sheets that will display
all names that have occured more than once. can anyone help.


--
Alphabet
------------------------------------------------------------------------
Alphabet's Profile:
http://www.excelforum.com/member.php...o&userid=30180
View this thread: http://www.excelforum.com/showthread...hreadid=498626