Help creating list of Reoccuring names

[Alphabet]

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.

[Bob Phillips]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>