Learn how to create drop down list in Excel. This tutorial covers Yes or No list, using a range for a list and making it dynamically auto update, creating dependent drop down list when one column selection will define available options in the other column. Functions used: OFFSET, COUNTA, INDIRECT, SUBSTITUTE.

#excel #dropdown #tutorial #microsoft