{"id":24496,"date":"2021-05-13T09:49:42","date_gmt":"2021-05-13T02:49:42","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24496"},"modified":"2021-05-13T09:49:42","modified_gmt":"2021-05-13T02:49:42","slug":"ham-choose-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-choose-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Choose trong Excel qua v\u00ed d\u1ee5 b\u00e0i t\u1eadp"},"content":{"rendered":"<p><strong>H\u00e0m Choose trong Excel<\/strong> \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i v\u00e0 s\u1eed d\u1ee5ng l\u00e0m h\u00e0m tra c\u1ee9u v\u00e0 tham chi\u1ebfu. H\u00e0m n\u00e0y tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1eeb m\u1ed9t m\u1ea3ng, chu\u1ed7i gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng. N\u1ebfu ch\u01b0a bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m Choose trong Excel<\/strong> nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o ti\u1ebfp b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ben Computer nh\u00e9.<\/p>\n<h2><strong>H\u00e0m Choose trong Excel\u00a0<\/strong><\/h2>\n<p><strong>H\u00e0m Choose trong Excel<\/strong> l\u00e0 h\u00e0m t\u00ecm ki\u1ebfm 1 gi\u00e1 tr\u1ecb trong 1 chu\u1ed7i gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng. \u0110\u00e2y c\u0169ng l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m Excel ph\u1ed5 bi\u1ebfn \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong u\u00e1 tr\u00ecnh t\u00ednh to\u00e1n v\u00e0 t\u00ecm ki\u1ebfm trong Excel. Ngo\u00e0i ra ch\u00fang ta c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m Choose v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m Excel kh\u00e1c \u0111\u1ec3 qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n d\u1ec5 d\u00e0ng h\u01a1n.<\/p>\n<figure id=\"attachment_24498\" aria-describedby=\"caption-attachment-24498\" style=\"width: 597px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"597\" height=\"328\" class=\"wp-image-24498 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-choose-trong-excel.png\" alt=\"H\u00e0m Choose trong Excel\u00a0\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-choose-trong-excel.png 597w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-choose-trong-excel-300x165.png 300w\" sizes=\"auto, (max-width: 597px) 100vw, 597px\" \/><figcaption id=\"caption-attachment-24498\" class=\"wp-caption-text\">H\u00e0m Choose trong Excel<\/figcaption><\/figure>\n<h3><strong>C\u00f4ng th\u1ee9c h\u00e0m Choose trong Excel<\/strong><\/h3>\n<p><strong>H\u00e0m Choose trong Excel<\/strong> c\u00f3 c\u00f4ng th\u1ee9c, c\u00fa ph\u00e1p nh\u01b0 d\u1ea1ng d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<blockquote><p><strong>=CHOOSE(index_num, value1, [value2], \u2026)<\/strong><\/p><\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\n<p><strong>\u2013 Index_num<\/strong>\u00a0(tham s\u1ed1 b\u1eaft bu\u1ed9c): l\u00e0 ch\u1ec9 s\u1ed1 m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh ch\u1ecdn gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 trong chu\u1ed7i gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c ch\u1ecdn. Tham s\u1ed1 n\u00e0y ph\u1ea3i l\u00e0 s\u1ed1 nguy\u00ean trong kho\u1ea3ng t\u1eeb 1 \u0111\u1ebfn 254, ho\u1eb7c c\u00f4ng th\u1ee9c ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn \u00f4 ch\u1ee9a m\u1ed9t gi\u00e1 tr\u1ecb trong kho\u1ea3ng t\u1eeb 1 \u2013 254.<\/p>\n<p><strong>\u2013 Value1, Value2<\/strong>: trong \u0111\u00f3 Value 1 l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c v\u00e0 Value 2 l\u00e0 t\u00f9y ch\u1ecdn, c\u00f3 th\u1ec3 c\u00f3 ho\u1eb7c kh\u00f4ng. C\u00e1c tham s\u1ed1 n\u00e0y l\u00e0 gi\u00e1 tr\u1ecb ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean trong chu\u1ed7i gi\u00e1 tr\u1ecb c\u1ee7a h\u00e0m Choose.<\/p>\n<h3><strong>M\u1ed9t s\u1ed1 l\u01b0u \u00fd quan tr\u1ecdng:<\/strong><\/h3>\n<ul>\n<li>N\u1ebfu gi\u00e1 tr\u1ecb tham s\u1ed1 index_num l\u00e0 1, h\u00e0m Choose s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb m\u00e0 1, t\u01b0\u01a1ng t\u1ef1, n\u1ebfu index_num l\u00e0 2 th\u00ec h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 2, v\u00e0 c\u1ee9 th\u1ebf ti\u1ebfp t\u1ee5c.<\/li>\n<li>C\u00e1c tham s\u1ed1Value 1, Value 2 ph\u1ea3i \u0111\u01b0\u1ee3c nh\u1eadp d\u01b0\u1edbi d\u1ea1ng c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang l\u1ebb (ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn c\u00e1c \u00f4 ri\u00eang l\u1ebb ch\u1ee9a gi\u00e1 tr\u1ecb).<\/li>\n<li>N\u1ebfu gi\u00e1 tr\u1ecb tham s\u1ed1 index_num l\u00e0 ph\u00e2n s\u1ed1, h\u00e0m choose s\u1ebd l\u1ea5y gi\u00e1 tr\u1ecb l\u00e0 s\u1ed1 nguy\u00ean th\u1ea5p nh\u1ea5t tr\u01b0\u1edbc khi s\u1eed d\u1ee5ng.<\/li>\n<li>N\u1ebfu gi\u00e1 tr\u1ecb tham s\u1ed1 index_num l\u00e0 m\u1ed9t m\u1ea3ng, m\u1ecdi gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 khi h\u00e0m Choose \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1.<\/li>\n<li>C\u00e1c tham s\u1ed1 c\u00f3 th\u1ec3 l\u00e0 tham chi\u1ebfu ph\u1ea1m vi ho\u1eb7c c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01a1n l\u1ebb.<\/li>\n<li>H\u00e0m Choose c\u00f3 s\u1eb5n tr\u00ean c\u00e1c phi\u00ean b\u1ea3n Excel cho Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 cho Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000.<\/li>\n<\/ul>\n<h3><strong>C\u00e1ch s\u1eed d\u1ee5ng ham Choose trong Excel<\/strong><\/h3>\n<p>\u0110\u1ec3 d\u1ec5 h\u00ecnh dung c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m Choose trong Excel<\/strong> nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ben Computer:<\/p>\n<h4><strong>V\u00ed d\u1ee5 1<\/strong><\/h4>\n<p>Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"319\" class=\"aligncenter wp-image-16920 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-12.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-12-300x151.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-12-360x180.jpg 360w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-12.jpg 632w\" alt=\"1 12 - H\u00e0m Choose trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng - Ben Computer\" \/><\/p>\n<p>Y\u00eau c\u1ea7u \u0111\u1eb7t ra \u1edf \u0111\u00e2y l\u00e0 t\u00ednh to\u00e1n c\u00e1c qu\u00fd t\u00e0i ch\u00ednh theo nh\u1eefng th\u00e1ng \u0111\u01b0\u1ee3c \u0111\u01b0a ra trong b\u1ea3ng d\u1eef li\u1ec7u kh\u00f4ng ph\u1ea3i l\u00e0 th\u00e1ng 1.<\/p>\n<p>Ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c h\u00e0m Excel c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"225\" class=\"aligncenter wp-image-16921 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-12.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-12-300x107.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-12.jpg 632w\" alt=\"2 12 - H\u00e0m Choose trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng - Ben Computer\" \/><\/p>\n<p>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"303\" class=\"aligncenter wp-image-16922 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-10.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-10-300x144.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-10.jpg 632w\" alt=\"3 10 - H\u00e0m Choose trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng - Ben Computer\" \/><\/p>\n<h4><strong>V\u00ed d\u1ee5 2<\/strong><\/h4>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 6 \u0111i\u1ec3m d\u1eef li\u1ec7u bao g\u1ed3m: 2, 3, 10, 24, 8, 11. Y\u00eau c\u1ea7u \u0111\u01b0a ra l\u00e0 ch\u1ecdn ph\u1ea7n t\u1eed th\u1ee9 4, v\u00ec v\u1eady c\u00f4ng th\u1ee9c h\u00e0m Choose c\u00f3 d\u1ea1ng nh\u01b0 sau: CHOOSE(4,2,3,10,24,8,11).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"320\" class=\"aligncenter wp-image-16923 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-9.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-9-300x152.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-9.jpg 632w\" alt=\"4 9 - H\u00e0m Choose trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng - Ben Computer\" \/><\/p>\n<p>K\u1ebft qu\u1ea3 \u0111\u1ea7u ra tr\u1ea3 v\u1ec1 c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 3.<\/p>\n<h3><strong>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Choose Excel<\/strong><\/h3>\n<p>1. H\u00e0m Choose tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 l\u1ed7i Value! khi:<\/p>\n<ul>\n<li>Tham s\u1ed1 index_num \u0111\u00e3 cho nh\u1ecf h\u01a1n 1 ho\u1eb7c l\u1edbn h\u01a1n gi\u00e1 tr\u1ecb \u0111\u00e3 cho.<\/li>\n<li>Ho\u1eb7c tham s\u1ed1 index_num \u0111\u00e3 cho kh\u00f4ng ph\u1ea3i l\u00e0 gi\u00e1 tr\u1ecb s\u1ed1.<\/li>\n<\/ul>\n<p><strong>2. H\u00e0m Choose tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 l\u1ed7i Name? khi:<\/strong> c\u00e1c tham s\u1ed1 l\u00e0 v\u0103n b\u1ea3n kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p v\u00e0 kh\u00f4ng ph\u1ea3i tham chi\u1ebfu \u00f4 h\u1ee3p l\u1ec7.<\/p>\n<p><strong>3. Gi\u00e1 tr\u1ecb tham s\u1ed1 index_value n\u1eb1m trong kho\u1ea3ng t\u1eeb 1 \u0111\u1ebfn 254.<\/strong><\/p>\n<p><strong>4. Gi\u00e1 tr\u1ecb tham s\u1ed1 index_value t\u01b0\u01a1ng \u1ee9ng v\u1edbi gi\u00e1 tr\u1ecb s\u1ed1, n\u1ebfu kh\u00f4ng h\u00e0m Choose s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i.<\/strong><\/p>\n<p>B\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y Ben Computer v\u1eeba gi\u1edbi thi\u1ec7u cho b\u1ea1n v\u1ec1 <strong>h\u00e0m Choose trong Excel<\/strong> v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m nh\u01b0 th\u1ebf n\u00e0o. Hy v\u1ecdng v\u1edbi nh\u1eefng th\u00f4ng tin tr\u00ean \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n l\u00e0m ch\u1ee7 h\u00e0m Excel n\u00e0y d\u1ec5 d\u00e0ng h\u01a1n. Ngo\u00e0i ra n\u1ebfu mu\u1ed1n t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng <a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-sumif-trong-excel\/\">h\u00e0m Sumif trong Excel<\/a> nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft \u0111\u00e3 c\u00f3 tr\u00ean Ben Computer nh\u00e9.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m Choose trong Excel \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i v\u00e0 s\u1eed d\u1ee5ng l\u00e0m h\u00e0m tra c\u1ee9u v\u00e0 tham chi\u1ebfu. H\u00e0m n\u00e0y tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1eeb m\u1ed9t m\u1ea3ng, chu\u1ed7i gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng. N\u1ebfu ch\u01b0a bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Choose trong Excel nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o ti\u1ebfp b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a [&hellip;]<\/p>\n","protected":false},"author":39,"featured_media":24498,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-24496","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24496","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=24496"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24496\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/24498"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=24496"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=24496"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=24496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}