{"id":8682,"date":"2024-12-24T12:25:52","date_gmt":"2024-12-24T12:25:52","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/24\/tao-drop-down-list-co-gia-tri-phu-thuoc-mot-list-khac\/"},"modified":"2024-12-24T12:25:52","modified_gmt":"2024-12-24T12:25:52","slug":"tao-drop-down-list-co-gia-tri-phu-thuoc-mot-list-khac","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/24\/tao-drop-down-list-co-gia-tri-phu-thuoc-mot-list-khac\/","title":{"rendered":"T\u1ea1o Drop-down list c\u00f3 gi\u00e1 tr\u1ecb ph\u1ee5 thu\u1ed9c m\u1ed9t list kh\u00e1c"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 2 danh s\u00e1ch: c\u00e1c khoa c\u1ee7a 1 tr\u01b0\u1eddng \u0111\u1ea1i h\u1ecdc v\u00e0 c\u00e1c nh\u00f3m ng\u00e0nh t\u01b0\u01a1ng \u1ee9ng c\u1ee7a t\u1eebng khoa \u0111\u00f3. B\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng t\u00ednh n\u0103ng data validation trong Excel \u0111\u1ec3 t\u1ea1o ra 2 c\u00e1i dropdown menu (danh s\u00e1ch ch\u1ecdn) m\u00e0 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn \u1edf danh s\u00e1ch th\u1ee9 2 (c\u00e1c ng\u00e0nh) s\u1ebd ph\u1ee5 thu\u1ed9c v\u00e0o d\u1eef li\u1ec7u v\u1ec1 khoa c\u00e1c b\u1ea1n \u0111\u00e3 ch\u1ecdn \u1edf danh s\u00e1ch th\u1ee9 nh\u1ea5t. Ch\u00fang ta g\u1ecdi \u0111\u00e2y l\u00e0 danh s\u00e1ch ph\u1ee5 thu\u1ed9c nhau, \u0111\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y, m\u1eddi c\u00e1c b\u1ea1n xem video h\u01b0\u1edbng d\u1eabn c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\">Excel online<\/a> sau \u0111\u00e2y v\u00e0 \u0111\u1eebng qu\u00ean download t\u00e0i li\u1ec7u k\u00e8m theo video \u0111\u1ec3 c\u00f3 th\u1ec3 th\u1ef1c h\u00e0nh ngay trong khi xem video.<\/p>\n<div class=\"videowrapper\" style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/aEaYrGWBC7s?autoplay=1&amp;loop=1&amp;wmode=transparent\" width=\"560\" height=\"315\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<h3 id=\"download-ti-liu-lin-quan\">Download t\u00e0i li\u1ec7u li\u00ean quan:<\/h3>\n<p>[sociallocker id=457]<\/p>\n<p><a href=\"http:\/\/bit.ly\/dtnEX79\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Download t\u00e0i li\u1ec7u Excel k\u00e8m theo video<\/strong><\/a><\/p>\n<p>[\/sociallocker]<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 2 danh s\u00e1ch: c\u00e1c khoa c\u1ee7a 1 tr\u01b0\u1eddng \u0111\u1ea1i h\u1ecdc v\u00e0..<\/p>\n","protected":false},"author":1,"featured_media":8683,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8682","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8682","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=8682"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8682\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8683"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8682"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}