Excel Magic Trick 1295

TEXTJOIN & INDEX Function to create Random Description Codes


Learn how to create random transaction description codes for products by randomly looking up a row from a product lookup table with the INDEX and RANDBETWEEN functions and then join them with a dash delimiter using the Excel 2016 function TEXTJOIN.


Download “Excel Magic Trick 1281-1300.zip” Excel-Magic-Trick-1281-1300.zip – Downloaded 825 times – 4 MB

Be the first to comment

Leave a Reply