+ Reply to Thread
Results 1 to 3 of 3

Results of List of Data with Advanced Filter

  1. #1
    Registered User
    Join Date
    11-07-2008
    Location
    RTP
    Posts
    2

    Results of List of Data with Advanced Filter

    Hopefully someone can help me out here as I'm going crazy.

    I have a list of phone system data which is around 20,000 records a month. I want to create a filter in excel that will filter this data based on the "column" dialed with a condition "Begins with X".

    The X will be the prefix that people dial to get outside line.

    I have uploaded an example. I put some fake data in the lines below. I want to have a filter automatically fill in the tables at the top of the sheet based on the data below. Even better, if I can move the results to a different worksheet.

    However, for each of the rows at the top:

    9
    9301
    91301
    9202
    91202
    9240
    91240
    9703
    91703
    91800
    91866


    I want to use each of those as a filter of the data below. Using the "Begins with 9 or 9301 or 91301 etc... of the column "dialed".

    Then put the results in the columns next to it. All I need is a total of the number of calls that match the filter then the subtotal of those calls "duration" column.

    Anyhow, I can do this right now using autofilter but I have to manually put in the "Begins With" filter for the dialed column then copy the values of the result for each filter.

    Thanks much for any ideas.
    Attached Files Attached Files

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,255
    Hello vtphilk,

    Welcome to the Forum!

    You can get your question answered faster by posting a copy of your workbook in Excel 2003 format.

    Sincerely,
    Leith Ross

  3. #3
    Registered User
    Join Date
    11-07-2008
    Location
    RTP
    Posts
    2
    Sounds good. Here it is in 2003
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1