Excel Magic Trick 1302

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


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.


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

Be the first to comment

Leave a Reply