Advanced Filter

  • Thread starter Thread starter SeaTiger
  • Start date Start date
S

SeaTiger

I running MS Excel 2007. I have a contact list over 4000 USA accounts. The
respective telephone numbers are under Column labeled Telephone. The cells
under the Telephone column are formatted for telephone #'s.

How would I do an Adanced Filter for accounts with specific area codes, i.e.
415, 310, 209, 619. I am not sure what operator to use to only inclue those
accounts with these specific area codes.

Thanks for your help.
 
I think I'd use a second column that extracts the area code and then use that
for the filtering.
 
In the workbook, type a list of the specific area codes that you want to
filter. In this example, I typed the list in column K.

If the telephone number is in column A, and the area code is in the
first three digits of the phone number, use this formula in the criteria
range:

=COUNTIF(K:K,LEFT(A2,3))

Leave the heading cell blank above this formula.

Then run the advanced filter, using the blank cell and formula as the
criteria range.
 
Hey this is awesome!

My problem is how do I apply this to my particular list.

StoreName Contact Telephone Fax E-mail


I will want the information for each of the columns above to be included
when I do the filter. The grey FILTER button on your sheet, I didn't see any
formula in the cell?

Thanks again.
 
Back
Top