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 ...

One formula filters, dedupes, and ranks your data into a live list. No more manual sort or remove duplicates.

Have you ever found yourself buried under a mountain of Excel spreadsheets, painstakingly updating formulas every time new data comes in? It’s a common struggle, one that can turn even the most ...