Creating a condensed subset list from items selected in master list.

Question

I apologize, because I know this has been covered many times over I'm sure.  I reviewed a post that uses the INDEX & Aggregate function to create a subset list from a set of selections in a master list.  I also looked at the TEXTJOIN way to do this but I would like the result to end up as a Column of cells, not a concatenated list of items grouped into one cell.  Basically, I am looking for a formula or function (CSE array or pull down) that can be entered into cell D21 (of my example above) that provides a list of only the items in D2 to D18 that have been checked in the check box or are another words triggered by the True/False linked cells in column C.  So from this screen shot, I would like cells D21, D22, D23 to display the items "Standard", "Laundry Detergent", and "Dog Food" respectively.     Any assistance would be greatly appreciated.   Tom F.

Answer 1

Try the following in D21

=FILTER(D$2:D$18,C$2:C$18=TRUE)

from D21, the formula can be copied to G21 & J21

Answer 2

Thank you so much xl_geek.  Boy was I making that harder than it really was. :)