Excel Magic Trick 1295

TEXTJOIN & INDEX Function to create Random Description Codes

DESCRIPTION

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.

WORKBOOKS

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




Be the first to comment

Leave a Reply