Magic Data Validation List using Dynamic Range Reference or Spilled Range Operator!! EMT 1910
From excelisfun · · 7 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
Download Excel File: https://excelisfun.net/files/EMT1909-1911.xlsx Buy excelisfun’s Excel Books: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ref=ap_rdr&ccs_id=6f8ce877-462f-447e-b825-7ede1f72a9d3 Free Excel Class from excelisfun: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo Learn how to add a Data Validation Dropdown List to a single cell so that you can copy the cell and the validation AND so that when new values are added, the Data Validation Dropdown List updates perfectly. Learn how to use the Spilled Range Operator and the Dynamic Range Reference Operator. Also learn how to use Relative Cell References in the Data Validation dialog box. Topics: 1. (00:00) Introduction. 2. (00:24) Review of next three videos: 1909, 1910, 1911. 3. (01:01) What we did in last video. 4. (01:16) Goal of this video. 5. (01:58) Problem with Data Validation List. 6. (02:54) Spilled Range Operator solution for a Dynamic Spilled Array. 7. (04:48) Dynamic Range Reference Operator solution. 8. (06:56) Summary 9. (07:13) Closing
#excel #microsoft #excelisfun #excelcourse #mikegirvin #excel365 #DynamicRangeReferenceOperator # SpilledRangeOperator # DynamicSpilledArray #datavalidation #datavalidationlist #exceldatavalidation
#excel #excel365 #excelisfun #highlinecollege #mikegirvin #freeexcellessons #excelformulas #excelfunctions
This video has subtitles or audio translations in these languages:: Afrikaans, Amharic, Arabic (experimental), Bangla (experimental), Chinese, Danish, Dutch, Dutch (Netherlands) (experimental), Filipino, Finnish, French, French (France), German, German (Germany), Hebrew (experimental), Hindi, Indonesian, Irish, Italian, Japanese, Khmer, Korean (experimental), Maithili, Malagasy, Malay, Malayalam, Nepali, Norwegian, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Punjabi (experimental), Russian (experimental), Sanskrit, Scottish Gaelic, Serbian, Sicilian, Slovenian, Somali, Spanish, Spanish (United States), Swahili, Tajik, Tamil (experimental), Tatar, Telugu (experimental), Thai, Tibetan, Turkish, Ukrainian, Urdu, Vietnamese, Welsh. Click gear icon below video to set subtitles, audio and language.