This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

Figure B How to use the UNIQUE () function in Excel If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE () function.

Now, let’s create a dropdown on another sheet named Dropdown and reference Animals_List : Create a second sheet and name it Dropdown (strictly speaking, it isn’t necessary to name this new sheet).

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

Discover two powerful Excel formula methods to unpivot data. Transform cross-tab layouts into analysis-ready formats without Power Query.