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

The FILTER function extracts every matching record while XLOOKUP only returns the first result.

Discover 15 modern Excel functions for 2026, including Group By and Scan, so you speed up your workflows, summaries and ...

The Microsoft Excel spreadsheet program, in combination with its Power Query data-fetching component, can be leveraged in so-called "Dynamic Data Exchange" (DDE) types of attacks, according to a ...

Use formulas instead of Power Query for tidy files, with a visible source path and clear parameters that teammates can review ...

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques. The article Five ways to take advantage of Excel list features showed five ...

How to use UNIQUE() to populate a dropdown in Microsoft Excel Your email has been sent Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.