Dynamic Data Validation

preview_player
Показать описание

If you've ever created a dashboard in Excel, you've probably added Data Validation drop down lists for selectors. Once you start to add a few in that may relate to each other, you'll find that it would be nice if each list reduced to only the applicable items based on the choices from the other selections. In this video, we'll look at how to make that happen! You'll need dynamic arrays (Office 365) for this.

#EXCEL #dashboard #VSTACK #UNIQUE #FILTER #dataValidation
  1. Nick - Double Excel
Рекомендации по теме
Easy Dynamic Dependent 0:07:20

Easy Dynamic Dependent Data Validation Two Ways

Data Validation List 0:01:09

Data Validation List with Dynamic Arrays in Excel - EQ 95

Smart Dependent Drop-Down 0:15:55

Smart Dependent Drop-Down Lists in Excel: Expandable & Exclude Blank Cells

Create SMART Drop 0:15:42

Create SMART Drop Down Lists in Excel (with Data Validation)

Data Validation Drop-Down 0:02:24

Data Validation Drop-Down List with Excel Table Dynamic Range

DYNAMIC Data validation 0:05:11

DYNAMIC Data validation | Excel tips & tricks tutorial

Dynamic Excel Drop 0:10:02

Dynamic Excel Drop Down Lists - PLUS how to get SEARCHABLE Drop Down Lists!

Dynamic Data Validation 0:07:43

Dynamic Data Validation

Automating Month End 0:59:08

Automating Month End Processes with Power Query and Dynamic Arrays

Create Multiple Dependent 0:11:57

Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)

Excel Dynamic Arrays: 0:04:46

Excel Dynamic Arrays: Data Validation List Dropdown: Unique, Sorted & No Blanks EMT 1523

Data Validation Drop 0:10:07

Data Validation Drop Down List with Excel Table Dynamic Range

Extract UNIQUE Items 0:14:49

Extract UNIQUE Items for Dynamic Data Validation Drop Down List

Create Dynamic Dropdown 0:13:03

Create Dynamic Dropdown Lists in Excel

MS Excel - 0:04:50

MS Excel - Dependent Dropdown List

Create multiple dependent 0:07:16

Create multiple dependent drop-down lists in Excel [EASY]

Dynamic Data Validation 0:07:42

Dynamic Data Validation Using Offset

Dependent Drop Down 0:11:10

Dependent Drop Down List in Excel Tutorial

Easier Data Validation 0:01:00

Easier Data Validation with Dynamic Drop-down List in Excel

Advanced Excel - 0:13:08

Advanced Excel - Data Validation and Drop-Down Lists

Excel - Data 0:05:16

Excel - Data Validation with the INDIRECT Function - Excel Advanced

INDIRECT Dependent Dynamic 0:12:35

INDIRECT Dependent Dynamic Drop Down List | How to create Dynamic Drop-Down List in Excel

Excel Dynamic Arrays 0:07:01

Excel Dynamic Arrays (How they will change EVERYTHING!)

Create data validation 0:05:10

Create data validation list from Excel Table... the RIGHT WAY!

Комментарии
Автор

thanks, this is exactly what im looking for

damngocminhchau
Автор

Nick, good luck with the channel! Question - what about using IFS in the DV formulas instead of IF? I do see how easy it was to adapt the IF statements, but wasn't able to try it out as noted below.
It's great that you are (trying to) provide a sample workbook. I find the best Excel channels do that, and especially provide Start and Finished solutions whether in separate worksheets or files.
Again, good luck!

jerrydellasala