EXCEL - Match Name, Sort, Check if "Active"

Hello All,

I recently posted a question to how match and sort a list of names to positions. However, I forgot that they needed a third variable which is only list those that are active. (Thank you RobertMika for this)

Please see spreadsheet attached that has the formula I wanted to list the names in order; but doesn't filter out just the actives.

Can someone please update the formula for me to only show active people...

Thanks in advance, it's much appreciated.

_Jason