"Aaron" skrev i en meddelelse
...
In my spreadsheet I have the courses that each uni student is taking for
the
current year. Each student (by row) can take up to 8 courses a year so
there
are 8 different columns. At certain points throughout the year, I will
need
to draw up a classlist for example of everyone in the 2nd year who is
taking
modernism. Therefore, I will need to filter all 8 columns at once to
provide
all the rows containg 'modernism'. However, because Excel provides
additive
filtering, once I have filtered column 1 for 'modernism', I have already
probably hidden info I need from the other 7 columns and the next column I
filter will only filter from the previous filter put in place.
So, I would like to know how to filter all 8 columns for a particular
course
simultaenously because filtering 1 column at a time will only be additive
and
will hide info I need from the other columns.

You might want to try the following:
If you have "courses" in for example B2:I100 try entering in cell J2 the
array formula:
=OR(B2:I2="modernism"). (Remember to hold down the Ctrl and Shift keys while
pressing Enter. If entered correct the formula should look like this:
{=OR(B2:I2="modernism")}. Copy the formula down through J100. You should get
TRUE if there is at least one "modernism", otherwise FALSE. Now you can
filter on column J.

Regards
Hans Knudsen