Excel Magic Trick 1302

List Text Modes in Single Cell with TEXTJOIN, HLOOKUP, MATCH & MODE.MULT

DESCRIPTION

Learn how to create an Array Formula to list multiple text modes in a single cell using the functions, MATCH, MODE.MULT, HLOOKUP and the wildcard for “any text” asterisk, “*”, and the new Excel 2016 function TEXTJOIN.

WORKBOOKS

Download “Excel Magic Trick 1301-1320” Excel-Magic-Trick-1301-1320.zip – Downloaded 62 times – 285 KB




Be the first to comment

Leave a Reply