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.