Sort or macro

[S Capeless]

After putting three lists of names together, into a
Master list, I want to put together a list of those names
that have occurred three times in the Master list. Is
this a sorting problem, or a job for a macro?

 

[duane]

if your names arein column a you could add a column b like below an
then sort based on column b - this counts the # of occurances of
given name in the list.

=COUNTIF($A$4:$A$6,A4

 

[Debra Dalgleish]

You can use an Advanced Filter to extract the names
There are instructions in Excel's help, and here:

http://www.contextures.com/xladvfilter01.html

In the criteria area, leave the heading cell blank
In the cell below, enter a formula that refers to the first data row in
the column of names, e.g.:
=COUNTIF(C2:C5000,C2)=3

In the extract area, leave the heading cells blank, to extract all the
columns
Or, enter the headings for specific columns that you want to extract

 

[Bob Phillips]

You could use worksheet formulas and functions.

For each name, add a formula in an adjacent column, such as

=COUNTIF($A$1:A1,A1)=3, and copy down

this will put TRUE or FALSE in the column, and filter on that column for
TRUE

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[S Capeless]

Thank you for your help, your filter worked beautifully.
But... I forgot to add that the names in column A have
addresses in column B that need to go with them.
Thank you for your time and willingness to help.

Steve C.

 

[Debra Dalgleish]

In the extract area, enter the column headings from Columns A and B.
For example, if your list looks like this:
A B C
1 Name Address DateEntered
2 J. Smith 123 Main St 1/1/04
3 K. Jones 345 Pine Rd 4/4/04

in the extract area, enter the headings:
J K
1 Name Address

In the Advanced Filter dialog box, enter J1:K1 as the Extract range
(Copy to)