software

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: www.excelforum.com/member.php...oamp;userid=30180
View this thread: www.excelforum.com/showthread...hreadid=498626Here 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 )gt;1,ROW($A1:$A20),quot;quot;),ROW(
$A1:$A20))),quot;quot;,
INDEX($A$1:$A$20,SMALL(IF(COUNTIF($A$1:$A$20,$A$1: $A$20)gt;1,ROW($A1:$A20),quot;quot;)
,ROW($A1:$A20))))

and commit with Ctrl-Shift-Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Alphabetquot; gt; wrote in
message ...
gt;
gt; Hello
gt;
gt; i need help in what formula or best way it would be to create a
gt; seperate list from several, on a number of my sheets that will display
gt; all names that have occured more than once. can anyone help.
gt;
gt;
gt; --
gt; Alphabet
gt; ------------------------------------------------------------------------
gt; Alphabet's Profile:
www.excelforum.com/member.php...oamp;userid=30180
gt; View this thread: www.excelforum.com/showthread...hreadid=498626
gt;