looking up names in a list

[macca]

I have a worksheet which contains a list of names. Some names appear once,
some twice, some three times and so on. I would like a formula that would
return a list of all the names that appear say twice.

Anyone got any ideas?

[Peo Sjoblom]

Use a help column and a formula like

=COUNTIF($A$2:$A$100,A1)=2

copy down, apply data>filter>autofilter and filter on help column and TRUE

another approach, select list, do data>filter>advanced filer, copy to
another location and unique records only
that will create a list with names only appearing once, in an adjacent cell
put

=COUNTIF($A$2:$A$100,H2)

where H2 is the first unique named of the filtered list, copy down and
you'll get the occurrences of the names next to each name

--
Regards,

Peo Sjoblom

(No private emails please)


"macca" <[email protected]> wrote in message
news:[email protected]...
>I have a worksheet which contains a list of names. Some names appear once,
> some twice, some three times and so on. I would like a formula that would
> return a list of all the names that appear say twice.
>
> Anyone got any ideas?