Creating a Set of Custom Instructions Using the #Excel TEXTJOIN Function by David Hager

 

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.

=TEXTJOIN(CHAR(10),,IF(B7:B16=”Yes”,A7:A16,””))

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:

 TJ_Instruction1

There are a number of other useful variations of this technique which I plan to explore.

You can download the example file here.

TJ_Instruction

 

Advertisements

4 thoughts on “Creating a Set of Custom Instructions Using the #Excel TEXTJOIN Function by David Hager

  1. Pingback: #Excel Super Links #117 – shared by David Hager | Excel For You

  2. Pingback: List of Priority Items from Another List Using #Excel TEXTJOIN Function by David Hager | Excel For You

  3. Pingback: #Excel Super Links #123 – shared by David Hager | Excel For You

  4. Pingback: #Excel Super Links #136 – shared by David Hager | Excel For You

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s