{"id":9624,"date":"2025-01-02T11:18:28","date_gmt":"2025-01-02T11:18:28","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-chon-ngau-nhien-nhieu-o-tu-mot-cot-don-gian-nhat\/"},"modified":"2025-01-02T11:18:28","modified_gmt":"2025-01-02T11:18:28","slug":"huong-dan-cach-chon-ngau-nhien-nhieu-o-tu-mot-cot-don-gian-nhat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-chon-ngau-nhien-nhieu-o-tu-mot-cot-don-gian-nhat\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch ch\u1ecdn ng\u1eabu nhi\u00ean nhi\u1ec1u \u00f4 t\u1eeb m\u1ed9t c\u1ed9t \u0111\u01a1n gi\u1ea3n nh\u1ea5t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch ch\u1ecdn ng\u1eabu nhi\u00ean nhi\u1ec1u \u00f4 t\u1eeb m\u1ed9t c\u1ed9t c\u00f3 s\u1eb5n v\u1edbi s\u1ef1 h\u1ed7 tr\u1ee3 c\u1ee7a hai h\u00e0m c\u01a1 b\u1ea3n.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-67767604151c2\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/chon-ngau-nhien-nhieu-o-tu-mot-cot.html#Chon_ngau_nhien_nhieu_o_tu_mot_cot_co_san_bang_cach_su_dung_cac_ham\" title=\"Ch\u1ecdn ng\u1eabu nhi\u00ean nhi\u1ec1u \u00f4 t\u1eeb m\u1ed9t c\u1ed9t c\u00f3 s\u1eb5n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m\">Ch\u1ecdn ng\u1eabu nhi\u00ean nhi\u1ec1u \u00f4 t\u1eeb m\u1ed9t c\u1ed9t c\u00f3 s\u1eb5n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/chon-ngau-nhien-nhieu-o-tu-mot-cot.html#Cach_1_Su_dung_VLOOKUP_ket_hop_RANDBETWEEN_cho_so_thu_tu\" title=\"C\u00e1ch 1: S\u1eed d\u1ee5ng VLOOKUP k\u1ebft h\u1ee3p RANDBETWEEN cho s\u1ed1 th\u1ee9 t\u1ef1\">C\u00e1ch 1: S\u1eed d\u1ee5ng VLOOKUP k\u1ebft h\u1ee3p RANDBETWEEN cho s\u1ed1 th\u1ee9 t\u1ef1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/chon-ngau-nhien-nhieu-o-tu-mot-cot.html#Cach_2_Su_dung_RAND_INDEX_va_RANK\" title=\"C\u00e1ch 2: S\u1eed d\u1ee5ng RAND, INDEX v\u00e0 RANK\">C\u00e1ch 2: S\u1eed d\u1ee5ng RAND, INDEX v\u00e0 RANK<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Chon_ngau_nhien_nhieu_o_tu_mot_cot_co_san_bang_cach_su_dung_cac_ham\"><\/span>Ch\u1ecdn ng\u1eabu nhi\u00ean nhi\u1ec1u \u00f4 t\u1eeb m\u1ed9t c\u1ed9t c\u00f3 s\u1eb5n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong v\u00ed d\u1ee5 minh h\u1ecda cho b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd \u0111\u01b0a ra m\u1ed9t b\u1ea3ng g\u1ed3m 10 \u00f4 ch\u1ee9a d\u1eef li\u1ec7u. Vi\u1ec7c ta c\u1ea7n l\u00e0m \u0111\u00f3 l\u00e0 l\u1ea5y ng\u1eabu nhi\u00ean 5 trong 10 d\u1eef li\u1ec7u \u0111\u00f3 ra v\u00e0 \u0111i\u1ec1n v\u00e0o b\u1ea3ng b\u00ean c\u1ea1nh.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23882\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chon-o-ngau-nhien-trong-cot-1.png\" width=\"341\" height=\"277\" title=\"chon-o-ngau-nhien-trong-cot-1\"><\/p>\n<p>\u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, ta c\u00f3 th\u1ec3 t\u01b0 duy nh\u01b0 sau:<\/p>\n<ul>\n<li>G\u1eafn m\u1ed7i t\u00ean v\u1edbi 1 con s\u1ed1(ng\u1eabu nhi\u00ean ho\u1eb7c s\u1eafp \u0111\u1eb7t)<\/li>\n<li>S\u1eed d\u1ee5ng h\u00e0m l\u1ea5y gi\u00e1 tr\u1ecb t\u00ean theo s\u1ed1 (ng\u1eabu nhi\u00ean ho\u1eb7c s\u1eafp \u0111\u1eb7t)<\/li>\n<li>S\u1eed d\u1ee5ng Fill cho c\u00e1c \u00f4 c\u00f2n l\u1ea1i<\/li>\n<\/ul>\n<p>\u0110\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean, m\u1ed9t trong hai bi\u1ebfn ho\u1eb7c c\u1ea3 hai \u0111\u1ec1u ph\u1ea3i ng\u1eabu nhi\u00ean. T\u1eeb \u0111\u00f3, ta c\u00f3 nh\u1eefng c\u00e1ch sau.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cach_1_Su_dung_VLOOKUP_ket_hop_RANDBETWEEN_cho_so_thu_tu\"><\/span>C\u00e1ch 1: S\u1eed d\u1ee5ng VLOOKUP k\u1ebft h\u1ee3p RANDBETWEEN cho s\u1ed1 th\u1ee9 t\u1ef1<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ea7u ti\u00ean, ta s\u1ebd \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 b\u1eb1ng c\u00e1ch t\u1ea1o th\u00eam c\u1ed9t STT b\u00ean tr\u00e1i c\u1ed9t H\u1ecd t\u00ean:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23883\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chon-o-ngau-nhien-trong-cot-2.png\" width=\"219\" height=\"258\" title=\"chon-o-ngau-nhien-trong-cot-2\"><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-72.gif\" title=\"ex101_92019-nho-72\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Sau \u0111\u00f3, t\u1ea1i \u00f4 C2 ta nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n<p><em>=VLOOKUP(RANDBETWEEN(1,10),$A$2:$B$11,2,0)<\/em><\/p>\n<p>Trong \u0111\u00f3:<br \/>\nH\u00e0m\u00a0<strong>RANDBETWEEN(1,10)<\/strong> s\u1ebd t\u1ea1o ng\u1eabu nhi\u00ean gi\u00e1 tr\u1ecb l\u00e0 s\u1ed1 t\u1ef1 nhi\u00ean trong kho\u1ea3ng t\u1eeb 1 \u0111\u1ebfn 10.<\/p>\n<p>H\u00e0m\u00a0<strong>VLOOKUP<\/strong> t\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb c\u1ee7a\u00a0<strong>RANDBETWEEN(1,10)<\/strong> trong b\u1ea3ng A2:B11, \u0111\u1ed1i chi\u1ebfu sang c\u1ed9t th\u1ee9 2 v\u00e0 tr\u1ea3 k\u1ebft qu\u1ea3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23884\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chon-o-ngau-nhien-trong-cot-3.png\" width=\"569\" height=\"341\" title=\"chon-o-ngau-nhien-trong-cot-3\"><\/p>\n<p>S\u1eed d\u1ee5ng fill cho to\u00e0n b\u1ed9 4 \u00f4 c\u00f2n l\u1ea1i.<\/p>\n<p>\u00a0<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cach_2_Su_dung_RAND_INDEX_va_RANK\"><\/span>C\u00e1ch 2: S\u1eed d\u1ee5ng RAND, INDEX v\u00e0 RANK<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, thay v\u00ec c\u1ed1 \u0111\u1ecbnh s\u1ed1 th\u1ee9 t\u1ef1, ta s\u1ebd g\u1eafn c\u00e1c gi\u00e1 tr\u1ecb h\u1ecd t\u00ean v\u1edbi m\u1ed9t con s\u1ed1 ng\u1eabu nhi\u00ean t\u1eeb 0 t\u1edbi 1 b\u1eb1ng <strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-random-trong-excel-ham-tao-so-ngau-nhien.html\">h\u00e0m\u00a0RAND<\/a>().\u00a0<\/strong>Nh\u1eadp\u00a0<strong>=RAND()<\/strong> t\u1ea1i c\u1ed9t s\u1ed1 th\u1ee9 t\u1ef1 v\u00e0 s\u1eed d\u1ee5ng fill.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23886\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chon-o-ngau-nhien-trong-cot-4.png\" width=\"194\" height=\"255\" title=\"chon-o-ngau-nhien-trong-cot-4\"><\/p>\n<p>Ti\u1ebfp theo, t\u1ea1i \u00f4 C1, ta s\u1ebd s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c:<\/p>\n<p><em>=INDEX($B$2:$B$11,RANK(A2,$A$2:$A$11))<\/em><\/p>\n<p>H\u00e0m\u00a0<strong>RANK<\/strong> s\u1ebd \u0111\u01b0a ra x\u1ebfp h\u1ea1ng c\u1ee7a \u00f4 A2 trong v\u00f9ng A2:A11.<\/p>\n<p>H\u00e0m\u00a0<strong>INDEX\u00a0<\/strong>s\u1ebd tr\u1ea3 ra k\u1ebft qu\u1ea3 theo d\u00f2ng v\u00e0 c\u1ed9t c\u1ee7a m\u1ea3ng \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o. VD \u00f4\u00a0<strong>A2\u00a0<\/strong>x\u1ebfp h\u1ea1ng 3, k\u1ebft qu\u1ea3 INDEX tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 d\u00f2ng th\u1ee9 3 c\u1ee7a c\u1ed9t\u00a0<strong>H\u1ecd t\u00ean<\/strong>.<\/p>\n<p>S\u1eed d\u1ee5ng Fill v\u00e0 ta c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23887\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chon-o-ngau-nhien-trong-cot-5.png\" width=\"533\" height=\"336\" title=\"chon-o-ngau-nhien-trong-cot-5\"><\/p>\n<p>\u00a0<\/p>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 2 c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 l\u1ea5y ra m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean c\u00e1c \u00f4 trong m\u1ed9t c\u1ed9t. Ngo\u00e0i ra c\u00f2n c\u00f3 nh\u1eefng ph\u01b0\u01a1ng ph\u00e1p \u0111\u01a1n gi\u1ea3n h\u01a1n, ti\u1ec7n h\u01a1n v\u00e0 ti\u00eau t\u1ed1n \u00edt dung l\u01b0\u1ee3ng h\u01a1n. C\u00e1c b\u1ea1n h\u00e3y th\u1eed t\u00ecm hi\u1ec3u nh\u00e9!<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t.<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/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":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-72.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9625,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9624","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9624","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=9624"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9624\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9625"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9624"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9624"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}