Help Filtering Multiple Columns

[Guest]

I recently made a database with the Grades of all my students in each of their classes, each of which has its own column. What I want to do is display all of my students that have a particular grade, or grades, in ANY class. For instance, I want to show all students who have C's or below in any of their classes. I've tried this using filters and encountered two problems. First, I can only choose one Grade to filter (A, B, B-, etc), rather than a range of grades (C - F, for instance). The other problem is that, once I filter one column, the only data now available in other columns is contingent on whatever wasn't filtered out of the first column. I hope this makes sense.
Thanks
Matthew

 

[Peo Sjoblom]

Have you tried the custom function of the autofilter, if you put greater
than or equal to and put A,
then you select less than or equal to and select B- that should return all
the students with grades
B- to A Or if you select greater than or equal to C and less than or equal
to F, that will give you grades between
C and F. Think of it when you select as if A is 1 and F is largest

--

Regards,

Peo Sjoblom

I recently made a database with the Grades of all my students in each of

their classes, each of which has its own column. What I want to do is
display all of my students that have a particular grade, or grades, in ANY
class. For instance, I want to show all students who have C's or below in
any of their classes. I've tried this using filters and encountered two
problems. First, I can only choose one Grade to filter (A, B, B-, etc),
rather than a range of grades (C - F, for instance). The other problem is
that, once I filter one column, the only data now available in other columns
is contingent on whatever wasn't filtered out of the first column. I hope
this makes sense.

 

[Debra Dalgleish]

You can use an Advanced Filter. There are instructions in Excel's Help,
and here:
http://www.contextures.com/xladvfilter01.html

In the criteria area, leave the heading cell blank, and enter the
following formula in the cell below (if the first student's grades are
in cells B2:E2):
=OR(B3>="C",C3>="C",D3>="C",E3>="C")