Help Filtering Multiple Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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


MAtthew said:
I recently made a database with the Grades of all my students in each of
Click to expand...
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.
 
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")
 
Back
Top