Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

Spill

Create Dependent Drop-Downs with Spill Ranges

By Jeff Lenning | February 12, 2019 |

A while ago, I wrote about creating dependent (aka cascading, dynamic, or conditional) drop-downs using data validation. This is where you have a primary drop-down, and the choices in the related secondary drop-down depend on the selection made in the first drop-down. Well, this process became MUCH easier with the introduction of dynamic array functions…

Read More
Training Programs
Free Resources

Learn by Email

Subscribe to Blog (free)
!
!
Subscribe
Something went wrong. Please check your entries and try again.

Topics

Battle Breakout Chart ChatGPT CHOOSE CONCAT CONCATENATE Conditional Formatting COUNTIFS Data Model Data Validation Dynamic Arrays EOMONTH FILTER Filters FlashFill Format Get & Transform Hacks Hyperlink IFERROR INDEX INDIRECT Macro MATCH Named Ranges Named References PIvotChart PivotTable PMT Power Pivot Power Query SEQUENCE Sort Spill SUBTOTAL SUMIFS Tables TEXT TEXTJOIN UNIQUE VLOOKUP VSTACK worksheet protection XLOOKUP

Categories