Excel Magic Trick 1309

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


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).


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

Be the first to comment

Leave a Reply