Sort or macro

  • Thread starter Thread starter S Capeless
  • Start date Start date
S

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?
 
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
 
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
 
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)
 
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.
 
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)
 
Back
Top