People in many walks of life need a list of instructions to follow. These can include from a doctor’s instruction, an exercise routine, a corporate protocol, etc. In many cases, a generic list of all possible instructions could be available. If so, the following technique could be very useful.
The list of instructions shown in column A is accompanied by a column B containing Yes or No (added through Data Validation). The desired result is to create a string that contains only the instructions that are matched with Yes.
The following array formula in G3 works for this example.
It will return a text string for each selected instruction to appear as a vertical list, which then can be printed to give to the intended group or person. See Figure:
There are a number of other useful variations of this technique which I plan to explore.
You can download the example file here.