In the attached is what I
think you're looking for.
In the
Data sheet I've removed all but the raw data, that is no calculated columns.
In the sheet
Missed I've put a formula in cell A2. This is all you need. The result spills down into the rows below. There is no need to copy this formula down:
Code:
=CHOOSECOLS(FILTER(tData,tData[Missed]="Yes","None found"),1,2,6,5)
In cell I2, is the same formula but it doesn't pick and choose the columns returned, it returns all the columns from the
Data sheet. Delete this formula (and the headers in row 1), it's only there for your information and to let you check the filtering is correct.
I've done the same for the
Gone and
Work sheets.