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 ...
Whether you're assigning random shifts, anonymizing a study, or shuffling a deck, randomizing rows in an Excel table manually is guaranteed to result in mistakes. So, instead of dragging and dropping ...