Drop Down Lists in Excel - Dependent, Unique Lists and Other Data Validation Lists

Drop Down Lists in Excel - Dependent, Unique Lists and Other Data Validation Lists

Leila Gharani via YouTube Direct link

Excel: Dependent Drop Down Lists with OFFSET, CHOOSE, INDEX & INDIRECT

1 of 13

1 of 13

Excel: Dependent Drop Down Lists with OFFSET, CHOOSE, INDEX & INDIRECT

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Drop Down Lists in Excel - Dependent, Unique Lists and Other Data Validation Lists

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Excel: Dependent Drop Down Lists with OFFSET, CHOOSE, INDEX & INDIRECT
  2. 2 Excel Simple Dependent Drop down List based on numbers (Index without match)
  3. 3 Realistic Case: Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List
  4. 4 Excel Dependent Drop Down List with Tabular Data without Named Ranges
  5. 5 Excel: Extract unique items for dynamic data validation drop down list
  6. 6 Excel: Find Multiple Matches & Dependent Drop Down List (Unsorted Tabular Data Set)
  7. 7 Create SMART Drop Down Lists in Excel (with Data Validation)
  8. 8 Excel Custom Data Validation (Use formulas to check for text, numbers & length)
  9. 9 Smart Dependent Drop-Down Lists in Excel: Expandable & Exclude Blank Cells
  10. 10 Excel Dynamic Arrays (How they will change EVERYTHING!)
  11. 11 This Excel Dependent Combo Box Solves an Annoying Problem (you've probably had this)
  12. 12 Reset Dependent Drop-down in Excel (with a tiny bit of VBA)
  13. 13 Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.