Advanced filter help using Excel 2007

[thefreelove]

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.

[martindwilson]

have you read here?
http://www.contextures.com/xladvfilter01.html

[thefreelove]

Yes I looked at that website earlier today, but I'm still having trouble getting the correct results. I have only been using Excel for a few weeks now and I know I'm doing it wrong. On that website I did not see a criteria layout similar to mine.

[newdoverman]

The Advanced Filter to get the records for M, >=15 and <=30, GR =B and TUITCTGY = Undergrad could look like this:

G AGE AGE GR TUITCTGY
M >=15 <=30 B Undergrad

To have both A and B for GR

G AGE AGE GR TUITCTGY
M >=15 <=30 B Undergrad
M A

The spacing gets all messed up. The A should be under the B in the GR column

The logic of the Advanced Filter can get rather convoluted as you have no doubt seen in the many examples in the help and other files.

In its simplest form, criteria in a single row are AND criteria and criteria in multiple rows are OR criteria. The AND criteria all must be true and any of the criteria in the OR criteria can be true to return records.

Your own examples are correctly written on the AdvFil1. It is necessary to repeat the M and age criteria for the second row otherwise you will get a mix M and G and all ages for the specified grade.

Only practice will sort out the logic until it becomes easy to use.

I had trouble with your workbook for some strange reason. There appeared to be several hidden rows but no filters hiding them. I only got the rows back by creating a table out of the data and then re-creating a normal range out of the data....strange.

[thefreelove]

Thanks, I finally figured it out before I saw your post (I was making it a lot harder than I should have), but you were right about that nonetheless.