Dynamic List based on Multiple Criteria

I'm trying to create a dynamic list based on multiple criteria. I have the formula set in C26 that works well, but I need it to also filter based on the CM name in the first column that matches the B25 cell.

Any thoughts?

Thank You!

I think you have uploaded a wrong sample sheet.

Here is a solution for the whole table in one go:

Please empty all expected results and try

Please Login or Register  to view this content.

old array formula:

Please Login or Register  to view this content.

Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

Yes, the reason of #CALC is because I forgot the IFERROR part for the months without selected persons:

Pelase try:

Please Login or Register  to view this content.