Excel Magic Trick 774: Dynamic Data Validation AND Dependent Data Validation Together
Loading...
Loading...
4,919
Loading...
4:04
Excel Magic Trick 773: VLOOKUP to lookup last character in ID Code & Convert Number Text to Numberby ExcelIsFun2,919 views- 8:09
Excel Magic Trick 775: Round to 5 Minutes for Integer Values or Time Values ROUND & MROUNDby ExcelIsFun1,396 views
- 10:58
Excel Magic Trick 549: Dynamic Data Validation List Drop-Down OFFSET or Table Feature?by ExcelIsFun24,920 views
- 2:53
Excel Magic Trick 776: Slaying Excel Dragon DVD Out! & RANK From More Than One Column Trickby ExcelIsFun1,716 views
- 1:09:39
Excel Magic Trick 778: INDEX & MATCH Functions Beginning To Advanced (18 Examples)by ExcelIsFun23,022 views
- 5:44
excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks and more...by ExcelIsFun445,703 views
- 5:06
Create dependent drop down lists in Excel.aviby Computergaga6,769 views
- 10:27
Mr Excel & excelisfun Trick 54: Approximate Lookup To Return Multiple Itemsby ExcelIsFun3,727 views
- 4:36
Dependent Data Validation on Microsoft Excelby iPowerUser532 views
- 10:07
Excel Magic Trick 794: Conditional Formatting MAX or MIN or Top 3 Value/s In Rowby ExcelIsFun3,754 views
- 4:58
Different Drop Down Lists in Same Excel Cellby contextures30,636 views
- 17:43
Excel 2010 Magic Trick 789: Extract Records That Match Criteria for Multiple Reports Across Sheetsby ExcelIsFun4,988 views
- 10:48
Excel Magic Trick 791: Partial Part Number Lookup: LOOKUP SEARCH functions and more...by ExcelIsFun1,886 views
- 10:41
Excel Dynamic Chart #9: 4 Week Chart Dynamic Formula & Dynamic Data Validation Formulaby ExcelIsFun6,789 views
- 3:06
How to use data validation in Excel 2007by throngle3,445 views
- 11:16
Excel Magic Trick 811:Multiple Two Way Lookup Adding INDIRECT, ADDRESS & Array MATCH Functionby ExcelIsFun2,347 views
- 9:43
Excel Magic Trick 780: 3-D Cell References For SUMIF Function - Adding with Criteria Across Sheetsby ExcelIsFun2,034 views
- 7:22
Excel Magic Trick 400: Show List of Values In Cells After Using Data Validation Drop-Downby ExcelIsFun9,439 views
- 6:38
Use the INDIRECT() Function to Create a 2nd Pick From List in Excelby DannyRocksExcels9,283 views
- 8:23
YTLE#84: A Few Data Validation Tricksby ExcelIsFun4,618 views
I do not know. Try posting to:
mrexcel[dot]com/forum
ExcelIsFun 9 months ago
I'm pulling from a seperate sheet so idk if that's the issue but i get the reply... The list source must be a delimited list, or a reference to single row or column when i do the final step of 'Data Validation'
Help???
MrVandeju 9 months ago
I do not know. Try posting a question to THE best Excel question site:
mrexcel[dot]com
ExcelIsFun 11 months ago
Can I have additional drop-downs based on the selection i've made in the first cell. i.e Can I have two different Data Validations based on my first selection? eg. I select something from a drop down in cell A1, and then based on A1, select something in B1, and again based on A1, select something in C1? I Hope I have not confused you.
11curiosity11 11 months ago
Cool! I am glad the trick from Contextures worked so well!!!
ExcelIsFun 11 months ago
Incredible. Instantly going to switch my Files from Index to Offset. That even solves the issue I had with the empty cells in the drop down fields (used a combo box instead of data validation, where formulas in the reference do not work).
Had to extend it by a lookup, but from there on it was thx to this video easy game.
ElmarBischof 11 months ago