Просто об аналитике и Excel | Зависимые выпадающие списки в Excel
54bin54 bin izleme
Yayın tarihi 23 eki 202023 eki 2020
{"pages":{"search":{"query":"Просто об аналитике и Excel | Зависимые выпадающие списки в Excel","originalQuery":"","serpid":"1752379622763675-15398834450130377353-balancer-l7leveler-kubr-yp-klg-285-BAL","reqid":"1752379622763675-15398834450130377353-balancer-l7leveler-kubr-yp-klg-285-BAL","parentReqid":"1752345672586189-16330092684207774615-balancer-l7leveler-kubr-yp-klg-51-BAL","serpItems":[{"id":"16855846667179624583-0-0","type":"videoSnippet","props":{"videoId":"16855846667179624583"},"curPage":0}],"filters":{},"serpFooter":{"linksGroups":[{"type":"geo","links":[{"label":"Columbus","title":"Columbus","url":"//yandex.com.tr/tune/geo/","logNode":{"name":"region"},"target":"_self","a11yLabel":"Bölgeniz Columbus","needRetpath":true}]},{"type":"help","links":[{"label":"Bize ulaşın","url":"https://yandex.com.tr/support/video/troubleshooting.html","logNode":{"name":"feedback"},"needRetpath":true},{"label":"Yardım","url":"https://yandex.com.tr/support/video/","logNode":{"name":"help"},"needRetpath":true}]},{"type":"settings","links":[{"label":"Ayarlar","url":"https://yandex.com.tr/tune/search/","target":"_self","logNode":{"name":"settings"},"needRetpath":true}]},{"type":"company","links":[{"label":"Şirket hakkında","url":"//yandex.com.tr/company/","logNode":{"name":"about"},"target":"_blank"},{"label":"Kullanım lisansı","url":"//yandex.com.tr/legal/termsofuse/","logNode":{"name":"license"},"target":"_blank"},{"label":"Gizlilik Politikası","url":"//yandex.com.tr/legal/confidential/","logNode":{"name":"confidential"},"target":"_blank"}],"a11yHidden":true}],"hasExtralinks":true},"currentPage":0,"prevPageToLoad":-1,"nextPageToLoad":1,"isTranslationsFilterEnabled":false,"isTranslationsDistributionEnabled":false,"isTranslationsDistributionOnboardingEnabled":false,"isFeedbackModalVisible":false,"viewerData":{},"prevention":{},"hasNextPage":false,"rightSerpItems":[{"type":"direct","id":"search-list-right","props":{"advRsyaActivateParams":{"pcodeParams":{"blockId":"R-I-8843654-1","renderTo":"search-list-right-0-R-I-8843654-1","pageNumber":0,"grab":"dNCf0YDQvtGB0YLQviDQvtCxINCw0L3QsNC70LjRgtC40LrQtSDQuCBFeGNlbCB8INCX0LDQstC40YHQuNC80YvQtSDQstGL0L/QsNC00LDRjtGJ0LjQtSDRgdC/0LjRgdC60Lgg0LIgRXhjZWwK","darkTheme":false,"lazyLoad":false,"extParams":{"reqid":"1752379622763675-15398834450130377353-balancer-l7leveler-kubr-yp-klg-285-BAL","ui":"desktop","yuid":"7303773531752379622"}}},"isAdult":false,"position":0,"placement":"search-list-right"},"curPage":0}],"quasarData":{"title":""},"isAdultQuery":false,"errorList":[],"layout":"list","retpath":"https%3A%2F%2Fgs.yandex.com.tr%2Fvideo%2Fpreview%2F16855846667179624583"},"main":{"_isInitial":true,"snippets":[],"serpFooter":{"linksGroups":[]},"isLoggedIn":false}},"internal":{"nonce":"3988344501303773537285","expFlags":{"video_depot_viewer":1,"video_instream_player_yaru_loader":1,"video_skeleton_doc_update":1,"velocity_delay_drawer":1,"video_instream_disable_hosts":"dzen.ru,ok.ru,vk.com,video.mail.ru","video_search_toggle_with_text":1,"video_single_vh_unmute":1,"video_update_d2d_after_clickout":1,"video_viewer_desktop_hide_tabs":1,"velocity_disable_suspense":1,"video_viewer_desktop_smart_layout":1,"dark_theme_desktop":"cookie","distr_splashscreen_on":1,"video_instream_player_config":{"vmapScenarioId":119,"category":2,"impId":7,"partnerId":2216089},"video_font_yandex_sans":1,"video_adv_new_show_rules":1,"video_resource_loader":1,"video_adv_config_desktop":{"before-player":{"regular":{"default":"R-I-2120168-1"}}},"video_nohost_full_filter_onboarding_enable":1,"video_skeleton_direct_under_player_update":1,"video_instream_player_config_porno":{"vmapScenarioId":119,"category":3,"impId":4,"partnerId":1988486},"video_vh_player_js":0,"video_dzc":1,"video_masthead_ratio":"180,4","video_searchdata_scheme":1,"video_adv_serp_right_fixed_screens":3,"video_single_vh_iframe":1,"velocity_delay_metrika":1,"video_viewer_desktop_visible_header":1,"video_partner_label":1,"video_direct_render_in_viewport":1,"video_skeleton_instream_update":1,"video_resource_loader_load_timeout":6000,"int_tr":1,"video_viewer_catch_sandbox_early_inits":1,"int_newstr_header_tab":0,"mmui_extended_escape_scheme":"searchdata.clips.0.authorname","tabs_order_version":"search,images,video,newstr,maps,newstr","spok":"id","video_search_grid_direct_repeat":6,"video_direct_config_desktop_search":"search-grid-row:R-I-48058-718:R-I-474674-109,search-grid-head:R-I-2120168-7","init_meta":{"enable-yabs-distr":1,"ask-user-purchase-history":1,"use-src-videoquickp":1,"enable-begemot":1,"enable_masthead":1,"use-src-videop":1,"use-src-videoquickp_misspell":1,"enable_blackbox_multisession":1,"begemot-enable-cancelled-misspell-rtmr":1,"enable_video_iron_fetcher":1,"use-related-only":1,"ask-yandex-io-devices":1,"use-images-device-setup":1,"use-src-imagesp":1,"images-apphost-collections-front":1,"enable_aab_apphost":1,"graph-is-video-search":1,"use-src-imagesp_misspell":1,"use-src-imagesultrap":1,"use-video-apphost-pre-templates":1,"use-src-videop_misspell":1,"use-video-apphost-post-templates":1,"use-src-imagesquickp":1,"enable_video_carousels":"1","restrict-max-docs":"1000","use-images-region-setup":1,"use-post-auto2":1,"use-images-settings-setup":1,"use-src-ugc_favorites":1,"video_vitrina_disable":"0","use-images-user-setup":1,"use-video-pre-search-data":1,"begemot-no-suggest-history":1},"video_depot_viewer_masthead_ssr_only":1,"video_skeleton_direct_organic_update":1,"video_blender":1,"video_search_grid_enable":0,"video_depot_viewer_legacy_counters":1,"video_search_grid_direct_start":3,"video_instream_players_yaru_enable":1,"video_adv_new_show_rules_docs_count":1,"beauty_header_futuris_tab":9,"video_redirect_plug":2,"distr_popup_on":1,"video_disable_serp_dzc":1,"video_direct_pos_id":"R-I-48058-73","dark_theme_desktop_default_pref":"system","video_search_toggle_enable":1,"video_viewer_desktop_blocks":1,"velocity_split_hydration":4,"video_duration_counter_new_format":1,"video_force_grid_on_premordie":1,"video_nohost_full_filter":1,"distr_pcode_off":1,"video_baobab_blockstat":1,"video_thumb_poster_full":1,"video_scrollpages":2,"video_serp_desktop_block_design":1,"video_nohost_youtube_filter":0,"video_direct_pos":5,"video_direct_viewport_margin_desktop":700},"slots":["1302294,0,49;1308277,0,73;1305492,0,41;1186712,0,22;1316372,0,58;1313150,0,84;1312743,0,2;1314427,0,21;1298359,0,80;1311804,0,18;1313298,0,24;1313815,0,36;1313701,0,64;936723,0,23;1313003,0,65;1313058,0,75;1307498,0,13;1307462,0,23;1311442,0,33;1308840,0,14;1312963,0,69;1294039,0,14;1289810,0,26;1307399,0,97;1314479,0,12;1313092,0,58;1309721,0,90;1316451,0,51;1289138,0,45;1308557,0,3;1310003,0,22;1316635,0,28;45960,0,88;461653,0,41;332148,0,14;1239523,0,59;1145219,0,84;1002327,0,24;1311974,0,90;151171,0,93;1230682,0,22;1281084,0,6;287509,0,73;1299586,0,21;1299588,0,47;788004,0,70;1288010,0,57;681842,0,72"],"isYandexNet":false,"platform":"desktop","isEnLogo":true,"retpath":"https%3A%2F%2Fgs.yandex.com.tr%2Fvideo%2Fpreview%2F16855846667179624583","mordaUrl":"//yandex.com.tr/","videoSearchUrl":"https://gs.yandex.com.tr/video/search?text=%D0%9F%D1%80%D0%BE%D1%81%D1%82%D0%BE+%D0%BE%D0%B1+%D0%B0%D0%BD%D0%B0%D0%BB%D0%B8%D1%82%D0%B8%D0%BA%D0%B5+%D0%B8+Excel+%7C+%D0%97%D0%B0%D0%B2%D0%B8%D1%81%D0%B8%D0%BC%D1%8B%D0%B5+%D0%B2%D1%8B%D0%BF%D0%B0%D0%B4%D0%B0%D1%8E%D1%89%D0%B8%D0%B5+%D1%81%D0%BF%D0%B8%D1%81%D0%BA%D0%B8+%D0%B2+Excel","settingsUrl":"https://yandex.com.tr/tune/search/","helpUrl":"https://yandex.com.tr/support/video/","legalUrl":"//legal.yandex.com.tr/termsofuse/","feedbackUrl":"https://yandex.com.tr/support/video/troubleshooting.html","basename":"/video","currentPageName":"previewShort","isYandexApp":false,"isYandexAppAndroid":false,"isYandexAppIos":false,"isAnyYaBro":false,"isAndroid":false,"isHamster":false,"serpid":"1752379622763675-15398834450130377353-balancer-l7leveler-kubr-yp-klg-285-BAL","backUrl":"//ya.ru","url":"https://gs.yandex.com.tr/video/preview/16855846667179624583?parent-reqid=1752345672586189-16330092684207774615-balancer-l7leveler-kubr-yp-klg-51-BAL","isIntegrationTest":false,"isEndToEndTest":false,"shouldDropLogs":false,"seo":{"url":"https://gs.yandex.com.tr/video/preview/16855846667179624583?parent-reqid=1752345672586189-16330092684207774615-balancer-l7leveler-kubr-yp-klg-51-BAL","title":"Просто об аналитике и Excel | Зависимые выпадающие списки в Excel","description":"Видео автора «Просто об аналитике и Excel» в Дзене 🎦: Покажу один из способов создания зависимых вы...","image":"http://avatars.mds.yandex.net/get-vthumb/4607048/85a7f07c6392b34dd6ad12a4b82ce1fe/800x450","imageSecureUrl":"https://avatars.mds.yandex.net/get-vthumb/4607048/85a7f07c6392b34dd6ad12a4b82ce1fe/800x450","video":"https://video-preview.s3.yandex.net/OVZQUAIAAAA.mp4","videoType":"video/mp4","imageWidth":800,"imageHeight":450,"type":"video"},"isEmbedded":false,"isPumpkin":false,"quasarCsrfToken":"y0c17a691c70e717aadd102c108ba2401","reportFeedbackBaseProps":{"initEmail":"","metaFields":{"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","userTestids":"1302294,1308277,1305492,1186712,1316372,1313150,1312743,1314427,1298359,1311804,1313298,1313815,1313701,936723,1313003,1313058,1307498,1307462,1311442,1308840,1312963,1294039,1289810,1307399,1314479,1313092,1309721,1316451,1289138,1308557,1310003,1316635,45960,461653,332148,1239523,1145219,1002327,1311974,151171,1230682,1281084,287509,1299586,1299588,788004,1288010,681842","queryText":"","reqid":"1752379622763675-15398834450130377353-balancer-l7leveler-kubr-yp-klg-285-BAL","userRegionName":"","userRegionId":"function() {\n return this._region.id;\n }","yandexuid":"7303773531752379622","uid":"0","isChildAccount":false}},"userTestids":"191768,238743,246500,253288,265553,270072,277807,274239,294077,278842,299121,313103,331010,338398,378416,359879,415420,644350,652605,645301,679708,689693,690449,696466,696473,722746,740796,776165,771230,781521,790415,801982,851450,886706,883477,900639,931367,937268,969063,935488,945314,989988,982463,991363,990185,1015567,1011895,1035320,1033956,1035241,1036046,1087297,1089355,1060131,1099741,1071879,1078818,1077703,1116602,1045814,1131637,1144233,1151726,1152703,1156933,1174275,1173000,1167408,1202006,1194718,1221235,1228280,1239596,1227266,1226860,1279793,1279825,1246754,1277457,1281110,1276447,1289213,1288208,1316794,1299604,1302294,1308277,1305492,1298359,1313701,1308840,1308557,45960,461653","regionId":20815,"isYaRu":false,"shouldUnmountSearchPageInViewer":false,"videoGlobalContext":{"platform":"desktop","isPumpkin":false,"language":"tr","user_time":{"epoch":"1752379622","tz":"America/Louisville","to_iso":"2025-07-13T00:07:02-0400","__is_plain":1},"isQuasarEnabled":false,"isHermione":false,"shouldStubImages":true,"enableVideoPreviewInHermione":false,"reqid":"1752379622763675-15398834450130377353-balancer-l7leveler-kubr-yp-klg-285-BAL","tld":"com.tr","isEmbedded":false,"shouldDailyClickoutDzenInSerp":false,"shouldDailyClickoutDzenInViewer":true,"shouldDisableWebp":false,"removeLinkPrefix":"/video","shouldUseHighresPreview":true,"shouldCutSnippetTitle":true,"shouldShowPlusBadge":true,"reportFeedbackBaseProps":{"initEmail":"","metaFields":{"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","userTestids":"1302294,1308277,1305492,1186712,1316372,1313150,1312743,1314427,1298359,1311804,1313298,1313815,1313701,936723,1313003,1313058,1307498,1307462,1311442,1308840,1312963,1294039,1289810,1307399,1314479,1313092,1309721,1316451,1289138,1308557,1310003,1316635,45960,461653,332148,1239523,1145219,1002327,1311974,151171,1230682,1281084,287509,1299586,1299588,788004,1288010,681842","queryText":"","reqid":"1752379622763675-15398834450130377353-balancer-l7leveler-kubr-yp-klg-285-BAL","userRegionName":"","userRegionId":"function() {\n return this._region.id;\n }","yandexuid":"7303773531752379622","uid":"0","isChildAccount":false}},"deviceDetect":{"OSFamily":"Unknown","isTV":0,"x64":0,"GoogleToolBarVersion":"","MultiTouch":0,"BrowserBase":"","YandexBarVersion":"","isTablet":0,"YandexBar":0,"hasWebOmni":0,"isTouch":0,"hasYandexCamera":0,"isMobile":0,"DeviceKeyboard":"","device":"desktop","TurboAppPlatformVersion":"","historySupport":0,"BrowserShellVersion":"","DeviceVendor":"","isBrowser":0,"hasFlash":0,"MailRuSputnikVersion":"","isSameSiteSupported":0,"BrowserBaseVersion":"","BrowserVersionRaw":"","hasWebVert":0,"DeviceId":"","error":"","MailRuAgent":0,"ScreenWidth":0,"inAppBrowser":0,"hasHTML5":0,"isEmulator":0,"J2ME":0,"MailRuAgentVersion":"","BrowserEngineVersionRaw":"537.36","isRobot":1,"__is_plain":1,"BrowserEngineVersion":"0537.0036","BrowserName":"Unknown","DeviceModel":"","BrowserEngine":"WebKit","DeviceName":"","OSVersionRaw":"","OSName":"","GoogleToolBar":0,"ScreenSize":"","isTurboApp":0,"MailRuSputnik":0,"YaBuildName":"","isWAP":0,"PreferMobile":0,"DesktopMode":0,"BrowserVersion":"","BitsPerPixel":0,"BrowserShell":"","YaGUI":"","isBeta":0,"OSVersion":"","ScreenHeight":0},"nonce":"3988344501303773537285","disableDoc2DocHostLink":true,"shouldHideChannelLink":true,"enableSlowBufferingAlert":false,"enableSlowBufferingAlertDedup":false,"userConnectionRtt":161,"visibleHeader":true,"hideTabs":true,"animated":false,"isServiceLikeViewer":false,"isDoc2DocScrollFix":false,"smartDesktopLayout":true,"isAdvDisabled":false,"shouldShowVideoPlaylistPane":false,"isVideoTranslationSupported":false,"isSummaryDisabled":false,"isPlainHeader":false,"shouldRenderBroSummaryApiContainer":false,"shouldDropLogs":false,"shouldUseBeacon":false,"hasAdBlock":false,"isVerificationMarkDisabled":false,"shouldPlayNonStopForExternal":false,"forceSlowBufferingAlert":false},"shouldShowAdvId":false,"isAdultQuery":false,"classQueryIsPornoWebScore":0.0008613072569,"showSensitive":false,"shouldReplaceHref":false},"user":{"tld":"com.tr","isEuDomain":false,"login":"","passportId":"","isLoggedIn":false,"locationName":"Columbus","isFamily":false,"yandexuid":"7303773531752379622","ugcCsrfToken":"","family":1,"isChild":false},"config":{"skinMode":"system","skin":"light","version":"releases/frontend/video/v1.1625.0#f90714a104afda54021d2b0353e2805fb0cd6578","isGridSupported":false,"advConfig":{"under-player":{"regular":{"default":"R-I-48058-725","mail":"R-A-13411721-6"},"adult":{"default":"R-I-474674-114","mail":"R-A-13426421-6"}},"under-player-lite":{"regular":{"default":"R-I-48058-728"},"adult":{"default":"R-I-474674-103"}},"under-player-old":{"regular":{"default":"R-I-48058-725","mail":"R-A-13411721-6"},"adult":{"default":"R-I-474674-114","mail":"R-A-13426421-6"}},"video-list":{"regular":{"default":"R-I-48058-708","mail":"R-A-13411721-2"},"adult":{"default":"R-I-474674-101","mail":"R-A-13426421-2"}},"search-list":{"regular":{"default":"R-I-48058-715","mail":"R-A-13411721-3"},"adult":{"default":"R-I-474674-108","mail":"R-A-13426421-3"}},"search-grid-row":{"regular":{"default":"R-I-48058-718","mail":"R-A-13411721-4"},"adult":{"default":"R-I-474674-109","mail":"R-A-13426421-4"}},"search-grid-head":{"regular":{"default":"R-I-2120168-7"}},"search-list-right":{"regular":{"default":"R-I-8843654-1"}},"before-player-old":{"regular":{"default":"R-I-2120168-1"}},"before-player":{"regular":{"default":"R-I-2120168-1"}}},"isSkinInitedOnClient":false},"counters":{"params":{"useBeacon":false,"clickHost":"gs.yandex.com.tr/clck","pid":197},"dict":{"viewer":"2921","user":"538","info":"1275","sources":"1500","select":"775","close":"486","open":"842","source":"186","link":"513","click":"882","tech":"690","player":"1242","change":"719","summary":"3410","init":"1309","item":"22","button":"440","shown":"3780","copy":"1276","text":"232","load":"1724","fallback":"2010","channel":"1345","hide":"1656"}},"clips":{"items":{"16855846667179624583":{"videoId":"16855846667179624583","docid":"34-3-17-Z8DE9A624210F04D4","description":"Видео автора «Просто об аналитике и Excel» в Дзене 🎦: Покажу один из способов создания зависимых выпадающих списков - когда от значения в первом столбце зависит какой список для выбора будет...","preview":{"posterSrc":"//avatars.mds.yandex.net/get-vthumb/4607048/85a7f07c6392b34dd6ad12a4b82ce1fe/564x318_1","videoSrc":"https://video-preview.s3.yandex.net/OVZQUAIAAAA.mp4","videoType":"video/mp4"},"target":"_self","position":"0","reqid":"1752379622763675-15398834450130377353-balancer-l7leveler-kubr-yp-klg-285-BAL","isAdultDoc":false,"relatedParams":{"text":"Просто об аналитике и Excel | Зависимые выпадающие списки в Excel","related_orig_text":"","related_porno":false,"related_short":true,"related_less_3m_off":true,"client":"d2d","no_cnt":1,"related_src":"serp","related":"{\"porno\":false,\"vfp\":1,\"orig_text\":\"\",\"url\":\"http:\\/\\/dzen.ru\\/video\\/watch\\/5f92fe074dcc5c613c4ace47\",\"src\":\"serp\",\"rvb\":\"EhYKFDE2ODU1ODQ2NjY3MTc5NjI0NTgzGhYKFDE2ODU1ODQ2NjY3MTc5NjI0NTgzWhQxNjg1NTg0NjY2NzE3OTYyNDU4M2qxDBIBMBgAIkQaMAAKKWhoc25mY3FndmxyanR5emhoNWU1MTg3M2MxMTYzOGEyYTE4YzE0N2RmEgIAESoQwg8PGg8_E8QBggQkAYAEKyqLARABGniBBRT9CQT8APr-A_8EBf4BHQ8AB_MDAwD5_wUA-gT-AP8EDvMIAQAA_Az8BQ0AAAAD-vz7_f0BANUCAgkCAAAAIArzBv0AAAD4Av36_wEAAPv78fECAAAABfoL-_8AAAAJCwTtAAAAAAYNB_wAAAAADg72_QAAAAAgAC1L5Mc7OBNACUhOUAIqhAIQABrwAXsqEv_34rkDgScQAPbQ7QK82isAFwz8_6IcAQGtBNoAo8QSAiAR2P-7F8b-qQkB_9Hp0_8nBdIBEhEN__XUHgD6ueEBPvUFAQQj0QEUMgv9__1K_hjfEf8q3zsHPPwR_yfbJf_cx_8BtPfCAQ7xKP8RChwF4w8gAP3E-PrZJ_8D_K34_SPIBAL8w8cBBe0QAObiJgY5NCb-C736BvwC5wT7Dt3_C_fkBhUc-_8Y__sJ3Q8QCzT5-PgiTxkHxTMF9uBVAwA6JgkHIB4T9RfC-_H36_AMFgX_7SkE4AeqFhICBun-8r0b7_IG-Bv86-IE9CAALQfK8zo4E0AJSGFQAirPBxAAGsAH-tTRvoEukLwUdlE9o1M8vfTIG7zrTTG84OLXvHi0EDzYkwa7JH9QPmNG-Lz-Q5o9rwjevYbUZbuJxM67OxlsPq4M6jyCjCU8Ghu1vazOxT394_e7E5BgvXNJdjt0JUI93PUSPZELzrygBxC7EjFVPrzeZz2eUcS8VWd1vddEsL0_LVA8ppfYPORjnDzsTcy8DTjit1iNxjtCRKi77a-IPYPuHL0u2mu7HB28vZE7dr1k0le7GVgXvhVNEb0uHXM8Zcz4vEAXTT3_5sU8_yPTvHV-wD3J6AC9ATCuPYd5pLvRDxk9TsClvMghh7wlVcC8l5pzvSVYXL3esfU7fsUKvk8gDL2iRt87Puq_Pei0-Dx2Co-3SdV7vZ_ziby1IBA8idTUvTySIb2O6188yu1NPW-_urtxBwW9KALrORYGqz0QFl-8jUolPdYjKD0s85Y8j7UVPfQ9fjzJwbY8yD_zvMWHo7ylzq08ids3PVF3VD2bjww8p3oCPpXBBz0wT9-7FryJO6muMrzuWHC7yHwAPlWoaT2NJaw8keZZPAdJur3qLj88N-JJPcXbNL3OORc8i8ucPaQXer1feEq8m9yUPa2F2T35xqU6fGESPqPgbj3fTZo7Qo0MPXScNj2XgRa8mKLcvXknurwb7_G6_70qvdsbN70Hzwg8KcSrOyfrob1sBno7iI3ovEdBCzwqGsm5ZSOGvZYE6LwT9oo6wS8_vPdnNb0TExK7yawOvrwIsjumvXE5QmadPaPPhbubRpU5tUOCPYHW1zxW5_U45ETgvABajDt2dpC4DFxmOWVCgrtvpiK6mseGPQBTJr4FXUA5aMQ2Pa1WQb2RwoU5wxHkPMjo5bxiRhS6ynoAPTmobj3cEpg6BiRGvcNXtb0IyF03G1ouvRgeIL3GPlS3Fwd8PUJ2Hr6jYIw3Il84PfNl2DwhgiK58Q4AvpVxQj1rgtg5u2SHvfXpAj0Ehqm4Q7lDvXJNQb1zEHw3CiSyPNvzgLtu6284aomlPRvFiD3Pr9A3b2tmvWhNYjxu5oG48Ugsvvf_xr2JXA24emCGvSD5Wb2UNQw5DzRVvODxkrx7nNA3gNQGPiwr7b0ILMA5irWTPJYjhD1sDYw4EybxvBv8gz13Hao4kkcLPfg_tjyL9C-4I0CHvd9BIj1xjsW2znI0vF0Py72ocJu3hj3tPf3-CbyBLEo3dDCxPY5W2rxBX7G342sPPoVOHj0XdK44T8sPPU4f5jyHNbe4squPvXy6-jxzlDQ3zmYavQ_uzryQJD-3IAA4E0AJSG1QASpzEAAaYPgIACDgF6_4IUPJIconNeMrwwHUIUb_Ce8A3iG0ww8bsCzlFwAYzgsipwAAAAhI3xeoAPt36f8U9f0mHs6xvfwsfzDjPMbO5eHU7x4bFb2vAulY7wAKBL07NRuN7Br97yAALWM0EDs4E0AJSG9QAjAJOAFKAGAAaAA,\"}","related_url":"http://dzen.ru/video/watch/5f92fe074dcc5c613c4ace47","parent-reqid":"1752379622763675-15398834450130377353-balancer-l7leveler-kubr-yp-klg-285-BAL","related_vfp":1,"relatedVideo":"yes"},"cwidth":950,"cheight":720,"cratio":1.31944,"dups":["16855846667179624583"],"episode":0,"season":0,"isEmbedOnly":false,"greenHost":"Dzen","hasTranslation":false,"contentTypeId":null}},"dups":{"16855846667179624583":{"videoId":"16855846667179624583","title":"Просто об аналитике и Excel | Зависимые выпадающие списки в Excel","cleanTitle":"Просто об аналитике и Excel | Зависимые выпадающие списки в Excel","host":{"title":"Dzen","href":"http://dzen.ru/video/watch/5f92fe074dcc5c613c4ace47?f=video","playerUri":"\u003ciframe src=\"https://dzen.ru/embed/v39-nQu8hXyg?autoplay=0&service=ya-video&from=yavideo\" frameborder=\"0\" scrolling=\"no\" allowfullscreen=\"1\" allow=\"autoplay; fullscreen; accelerometer; gyroscope; picture-in-picture; encrypted-media\" aria-label=\"Video\">\u003c/iframe>","playerId":"zen","providerName":"dzen.ru","sourceHost":"dzen.ru","name":"dzen.ru","secondPart":{"type":"CHANNEL","id":"ZHplbi5ydTs1ZTUxODczYzExNjM4YTJhMThjMTQ3ZGY=","isVerified":false,"subscribersCount":0,"url":"/video/search?channelId=ZHplbi5ydTs1ZTUxODczYzExNjM4YTJhMThjMTQ3ZGY%3D&how=tm&text=%D0%9F%D1%80%D0%BE%D1%81%D1%82%D0%BE+%D0%BE%D0%B1+%D0%B0%D0%BD%D0%B0%D0%BB%D0%B8%D1%82%D0%B8%D0%BA%D0%B5+%D0%B8+Excel","a11yText":""},"faviconUrl":"//favicon.yandex.net/favicon/v2/http%3A%2F%2Fdzen.ru?color=255%2C255%2C255%2C0&size=32&stub=1"},"duration":{"value":196,"text":"3:16","a11yText":"Süre 3 dakika 16 saniye"},"views":{"text":"54bin","shouldShowInSnippet":true,"a11yText":"54 bin izleme"},"date":"23 eki 2020","modifyTime":1603436400000,"isExternal":false,"shouldShowQuasar":false,"player":{"embedUrl":"https://dzen.ru/embed/v39-nQu8hXyg?autoplay=1","playerId":"zen","videoUrl":"http://dzen.ru/video/watch/5f92fe074dcc5c613c4ace47","reqid":"1752379622763675-15398834450130377353-balancer-l7leveler-kubr-yp-klg-285-BAL","duration":196},"parentClipId":"16855846667179624583","href":"/preview/16855846667179624583?parent-reqid=1752379622763675-15398834450130377353-balancer-l7leveler-kubr-yp-klg-285-BAL","rawHref":"/video/preview/16855846667179624583?parent-reqid=1752379622763675-15398834450130377353-balancer-l7leveler-kubr-yp-klg-285-BAL","isEmbedOnly":false}}},"viewer":{"_isInitial":false,"clips":{"items":{"16855846667179624583":{"videoId":"16855846667179624583","docid":"34-3-17-Z8DE9A624210F04D4","description":"Видео автора «Просто об аналитике и Excel» в Дзене 🎦: Покажу один из способов создания зависимых выпадающих списков - когда от значения в первом столбце зависит какой список для выбора будет...","preview":{"posterSrc":"//avatars.mds.yandex.net/get-vthumb/4607048/85a7f07c6392b34dd6ad12a4b82ce1fe/564x318_1","videoSrc":"https://video-preview.s3.yandex.net/OVZQUAIAAAA.mp4","videoType":"video/mp4"},"target":"_self","position":"0","reqid":"1752379622763675-15398834450130377353-balancer-l7leveler-kubr-yp-klg-285-BAL","isAdultDoc":false,"relatedParams":{"text":"Просто об аналитике и Excel | Зависимые выпадающие списки в Excel","related_orig_text":"","related_porno":false,"related_short":true,"related_less_3m_off":true,"client":"d2d","no_cnt":1,"related_src":"serp","related":"{\"porno\":false,\"vfp\":1,\"orig_text\":\"\",\"url\":\"http:\\/\\/dzen.ru\\/video\\/watch\\/5f92fe074dcc5c613c4ace47\",\"src\":\"serp\",\"rvb\":\"EhYKFDE2ODU1ODQ2NjY3MTc5NjI0NTgzGhYKFDE2ODU1ODQ2NjY3MTc5NjI0NTgzWhQxNjg1NTg0NjY2NzE3OTYyNDU4M2qxDBIBMBgAIkQaMAAKKWhoc25mY3FndmxyanR5emhoNWU1MTg3M2MxMTYzOGEyYTE4YzE0N2RmEgIAESoQwg8PGg8_E8QBggQkAYAEKyqLARABGniBBRT9CQT8APr-A_8EBf4BHQ8AB_MDAwD5_wUA-gT-AP8EDvMIAQAA_Az8BQ0AAAAD-vz7_f0BANUCAgkCAAAAIArzBv0AAAD4Av36_wEAAPv78fECAAAABfoL-_8AAAAJCwTtAAAAAAYNB_wAAAAADg72_QAAAAAgAC1L5Mc7OBNACUhOUAIqhAIQABrwAXsqEv_34rkDgScQAPbQ7QK82isAFwz8_6IcAQGtBNoAo8QSAiAR2P-7F8b-qQkB_9Hp0_8nBdIBEhEN__XUHgD6ueEBPvUFAQQj0QEUMgv9__1K_hjfEf8q3zsHPPwR_yfbJf_cx_8BtPfCAQ7xKP8RChwF4w8gAP3E-PrZJ_8D_K34_SPIBAL8w8cBBe0QAObiJgY5NCb-C736BvwC5wT7Dt3_C_fkBhUc-_8Y__sJ3Q8QCzT5-PgiTxkHxTMF9uBVAwA6JgkHIB4T9RfC-_H36_AMFgX_7SkE4AeqFhICBun-8r0b7_IG-Bv86-IE9CAALQfK8zo4E0AJSGFQAirPBxAAGsAH-tTRvoEukLwUdlE9o1M8vfTIG7zrTTG84OLXvHi0EDzYkwa7JH9QPmNG-Lz-Q5o9rwjevYbUZbuJxM67OxlsPq4M6jyCjCU8Ghu1vazOxT394_e7E5BgvXNJdjt0JUI93PUSPZELzrygBxC7EjFVPrzeZz2eUcS8VWd1vddEsL0_LVA8ppfYPORjnDzsTcy8DTjit1iNxjtCRKi77a-IPYPuHL0u2mu7HB28vZE7dr1k0le7GVgXvhVNEb0uHXM8Zcz4vEAXTT3_5sU8_yPTvHV-wD3J6AC9ATCuPYd5pLvRDxk9TsClvMghh7wlVcC8l5pzvSVYXL3esfU7fsUKvk8gDL2iRt87Puq_Pei0-Dx2Co-3SdV7vZ_ziby1IBA8idTUvTySIb2O6188yu1NPW-_urtxBwW9KALrORYGqz0QFl-8jUolPdYjKD0s85Y8j7UVPfQ9fjzJwbY8yD_zvMWHo7ylzq08ids3PVF3VD2bjww8p3oCPpXBBz0wT9-7FryJO6muMrzuWHC7yHwAPlWoaT2NJaw8keZZPAdJur3qLj88N-JJPcXbNL3OORc8i8ucPaQXer1feEq8m9yUPa2F2T35xqU6fGESPqPgbj3fTZo7Qo0MPXScNj2XgRa8mKLcvXknurwb7_G6_70qvdsbN70Hzwg8KcSrOyfrob1sBno7iI3ovEdBCzwqGsm5ZSOGvZYE6LwT9oo6wS8_vPdnNb0TExK7yawOvrwIsjumvXE5QmadPaPPhbubRpU5tUOCPYHW1zxW5_U45ETgvABajDt2dpC4DFxmOWVCgrtvpiK6mseGPQBTJr4FXUA5aMQ2Pa1WQb2RwoU5wxHkPMjo5bxiRhS6ynoAPTmobj3cEpg6BiRGvcNXtb0IyF03G1ouvRgeIL3GPlS3Fwd8PUJ2Hr6jYIw3Il84PfNl2DwhgiK58Q4AvpVxQj1rgtg5u2SHvfXpAj0Ehqm4Q7lDvXJNQb1zEHw3CiSyPNvzgLtu6284aomlPRvFiD3Pr9A3b2tmvWhNYjxu5oG48Ugsvvf_xr2JXA24emCGvSD5Wb2UNQw5DzRVvODxkrx7nNA3gNQGPiwr7b0ILMA5irWTPJYjhD1sDYw4EybxvBv8gz13Hao4kkcLPfg_tjyL9C-4I0CHvd9BIj1xjsW2znI0vF0Py72ocJu3hj3tPf3-CbyBLEo3dDCxPY5W2rxBX7G342sPPoVOHj0XdK44T8sPPU4f5jyHNbe4squPvXy6-jxzlDQ3zmYavQ_uzryQJD-3IAA4E0AJSG1QASpzEAAaYPgIACDgF6_4IUPJIconNeMrwwHUIUb_Ce8A3iG0ww8bsCzlFwAYzgsipwAAAAhI3xeoAPt36f8U9f0mHs6xvfwsfzDjPMbO5eHU7x4bFb2vAulY7wAKBL07NRuN7Br97yAALWM0EDs4E0AJSG9QAjAJOAFKAGAAaAA,\"}","related_url":"http://dzen.ru/video/watch/5f92fe074dcc5c613c4ace47","parent-reqid":"1752379622763675-15398834450130377353-balancer-l7leveler-kubr-yp-klg-285-BAL","related_vfp":1,"relatedVideo":"yes"},"cwidth":950,"cheight":720,"cratio":1.31944,"dups":["16855846667179624583"],"episode":0,"season":0,"isEmbedOnly":false,"greenHost":"Dzen","hasTranslation":false,"contentTypeId":null}},"dups":{"16855846667179624583":{"videoId":"16855846667179624583","title":"Просто об аналитике и Excel | Зависимые выпадающие списки в Excel","cleanTitle":"Просто об аналитике и Excel | Зависимые выпадающие списки в Excel","host":{"title":"Dzen","href":"http://dzen.ru/video/watch/5f92fe074dcc5c613c4ace47?f=video","playerUri":"\u003ciframe src=\"https://dzen.ru/embed/v39-nQu8hXyg?autoplay=0&service=ya-video&from=yavideo\" frameborder=\"0\" scrolling=\"no\" allowfullscreen=\"1\" allow=\"autoplay; fullscreen; accelerometer; gyroscope; picture-in-picture; encrypted-media\" aria-label=\"Video\">\u003c/iframe>","playerId":"zen","providerName":"dzen.ru","sourceHost":"dzen.ru","name":"dzen.ru","secondPart":{"type":"CHANNEL","id":"ZHplbi5ydTs1ZTUxODczYzExNjM4YTJhMThjMTQ3ZGY=","isVerified":false,"subscribersCount":0,"url":"/video/search?channelId=ZHplbi5ydTs1ZTUxODczYzExNjM4YTJhMThjMTQ3ZGY%3D&how=tm&text=%D0%9F%D1%80%D0%BE%D1%81%D1%82%D0%BE+%D0%BE%D0%B1+%D0%B0%D0%BD%D0%B0%D0%BB%D0%B8%D1%82%D0%B8%D0%BA%D0%B5+%D0%B8+Excel","a11yText":""},"faviconUrl":"//favicon.yandex.net/favicon/v2/http%3A%2F%2Fdzen.ru?color=255%2C255%2C255%2C0&size=32&stub=1"},"duration":{"value":196,"text":"3:16","a11yText":"Süre 3 dakika 16 saniye"},"views":{"text":"54bin","shouldShowInSnippet":true,"a11yText":"54 bin izleme"},"date":"23 eki 2020","modifyTime":1603436400000,"isExternal":false,"shouldShowQuasar":false,"player":{"embedUrl":"https://dzen.ru/embed/v39-nQu8hXyg?autoplay=1","playerId":"zen","videoUrl":"http://dzen.ru/video/watch/5f92fe074dcc5c613c4ace47","reqid":"1752379622763675-15398834450130377353-balancer-l7leveler-kubr-yp-klg-285-BAL","duration":196},"parentClipId":"16855846667179624583","href":"/preview/16855846667179624583?parent-reqid=1752379622763675-15398834450130377353-balancer-l7leveler-kubr-yp-klg-285-BAL","rawHref":"/video/preview/16855846667179624583?parent-reqid=1752379622763675-15398834450130377353-balancer-l7leveler-kubr-yp-klg-285-BAL","isEmbedOnly":false}},"loadingStatus":"None"},"internal":{"videoId":"16855846667179624583","sandboxEventPrefix":"sandbox:","sandboxVersion":"0x37b97f62901","isHermione":false,"isEmbedded":false,"from":"yavideo","service":"ya-video","hbPeriod":30,"rknWarnHosts":[""],"table":"video_tech","nonce":"3988344501303773537285","errorList":[],"isAdultAdv":false,"isImportantCommonAdv":false,"shouldShowAdvId":false,"advConfig":{"under-player":{"regular":{"default":"R-I-48058-725","mail":"R-A-13411721-6"},"adult":{"default":"R-I-474674-114","mail":"R-A-13426421-6"}},"under-player-lite":{"regular":{"default":"R-I-48058-728"},"adult":{"default":"R-I-474674-103"}},"under-player-old":{"regular":{"default":"R-I-48058-725","mail":"R-A-13411721-6"},"adult":{"default":"R-I-474674-114","mail":"R-A-13426421-6"}},"video-list":{"regular":{"default":"R-I-48058-708","mail":"R-A-13411721-2"},"adult":{"default":"R-I-474674-101","mail":"R-A-13426421-2"}},"search-list":{"regular":{"default":"R-I-48058-715","mail":"R-A-13411721-3"},"adult":{"default":"R-I-474674-108","mail":"R-A-13426421-3"}},"search-grid-row":{"regular":{"default":"R-I-48058-718","mail":"R-A-13411721-4"},"adult":{"default":"R-I-474674-109","mail":"R-A-13426421-4"}},"search-grid-head":{"regular":{"default":"R-I-2120168-7"}},"search-list-right":{"regular":{"default":"R-I-8843654-1"}},"before-player-old":{"regular":{"default":"R-I-2120168-1"}},"before-player":{"regular":{"default":"R-I-2120168-1"}}},"shouldValidateSandbox":false,"isSSROnlyMastheadEnabled":true,"queryUriEscaped":"%D0%9F%D1%80%D0%BE%D1%81%D1%82%D0%BE%20%D0%BE%D0%B1%20%D0%B0%D0%BD%D0%B0%D0%BB%D0%B8%D1%82%D0%B8%D0%BA%D0%B5%20%D0%B8%20Excel%20%7C%20%D0%97%D0%B0%D0%B2%D0%B8%D1%81%D0%B8%D0%BC%D1%8B%D0%B5%20%D0%B2%D1%8B%D0%BF%D0%B0%D0%B4%D0%B0%D1%8E%D1%89%D0%B8%D0%B5%20%D1%81%D0%BF%D0%B8%D1%81%D0%BA%D0%B8%20%D0%B2%20Excel","filterMode":1,"isUserChild":false},"playbackQueue":{"currentIndex":0,"items":[{"type":"VIDEO","videoId":"16855846667179624583","source":"serp","selectEvent":"click"}]},"related":{"items":[],"pages":[],"loadingStatus":"None","nextPageNum":0,"ncrnd":0},"playlist":{"items":{}}}}