Excel Magic Trick 1309

Extract Unique List and List in Single Cell: TEXTJOIN Array Formula

DESCRIPTION

Learn how to create an array formula to display a unique list in a single cell. This formula comes from Bill Szysz at YouTube. See the functions: MATCH, ROW, IF and the new Excel 2016, Office 365 function TEXTJOIN. Also see formula that is used on an expandable Excel Table and see Excel Table Formula Nomenclature (Structured References).

WORKBOOKS

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




Be the first to comment

Leave a Reply