Filtering Rows by criteria

[Grant T]

Hi,

With help from people here I managed to partly achieve my objective, although not as cleanly as I would like.

What I have:

Within the attached you will see it takes TWO steps to achieve displaying only the rows of questions which meet the criteria.

1. Select the assessment level, then;
2. Apply the filter

What i'd like:

To somehow achieve my objective of only displaying the rows of questions which meet the criteria with ONE step, is this possible, if so, how?

[AliGW]

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...-a-filter.html