In addition to the new SORT function, you may also find the new FILTER and UNIQUE array functions useful. For example, the worksheet on the next page contains a detailed listing of invoices in columns ...
Excel provides three functions for generating random values: RAND(), RANDARRAY(), and RANDBETWEEN(), but there’s no comparable function for generating random letters. The truth is, most of won’t need ...