Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.

Microsoft Excel can save you time in lots of little ways, like adding a drop-down list to cells so that only pre-written text can be entered.