Could you not have a column for each course by name? This way (for example)
column E is headed 'Modernism', and the entries in the rows below contain a
flag - 'Y' might do - though you may have to develop a coding system
according to your requirements.



--
HTH
Roger
Shaftesbury (UK)




"Aaron" wrote in message
...
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.