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 [Read More >>>]
DESCRIPTION Learn how to create an array formula to show a sorted list of modes in a single cell. See the Functions: TEXTJOIN, INDEX, SMALL, MODE.MULT, COUNT, ROW, INDIRECT. Learn about difference (and history) between [Read More >>>]
In the above example is it possible, on another sheet, to have the months as shown in column A. Then in B1 input Disk Drives or CD Drives or DVD Drives etc… and then display the numbers for the corresponding title alongside the months?