Results 1 to 5 of 5

Advanced filter help using Excel 2007

Threaded View

  1. #1
    Registered User
    Join Date
    08-22-2013
    Location
    Tulsa
    MS-Off Ver
    Excel 2007
    Posts
    3

    Advanced filter help using Excel 2007

    Hi, I just started learning Excel this summer in preparation for starting college, and I am having trouble with some advanced filtering. My list range is in the Database sheet and named "database", my criteria range is $A$1:$E$4 in the "AdvFil2" sheet, and the results are extracted to $A$8:$E$8, which I named report2, also in "AdvFil2".

    What I am trying to do is this: The criteria is all residents of Tulsa with a tuition amount between $30,000 and $40,000 inclusive, or over $50,000, who are in either Business or Engineering and who have a percentage grade below 75%.
    The "report2" data should show Name, Type, Age, Percentage Grade, and Tuition Amount (but the filtered data is obviously wrong).

    I hope you'll be able to see the attachment to see proper column labels, but if not they are: City = C, tuition = TUITION, business or engineering = COL, percentage grade = PCT, name = NAME, type = TYPE, age = AGE.

    I would really appreciate any help on how to set up this advanced filter correctly. Also if you would please, take a look at the sheet AdvFil1 and tell me if there's a better way to write out that advanced filter, because when I put in the B on the second row all by itself, the results were incorrect.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007 : Advanced filter issue
    By Nikeyg in forum Excel General
    Replies: 2
    Last Post: 04-06-2013, 05:53 AM
  2. Pivot Table - Advanced Filter or Countif in Excel 2007
    By Andjsmith in forum Excel General
    Replies: 1
    Last Post: 07-17-2012, 10:59 AM
  3. Excel 2010 Advanced Function Filter problems - 2007 issues
    By adamwestrop in forum Excel General
    Replies: 3
    Last Post: 07-29-2011, 01:52 PM
  4. Replies: 0
    Last Post: 02-28-2009, 04:11 AM
  5. Excel 2007 Beta Advanced Filter Performance
    By RHoodnkt in forum Excel General
    Replies: 1
    Last Post: 08-12-2006, 06:00 PM

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