{"id":863,"date":"2024-12-02T02:58:05","date_gmt":"2024-12-02T02:58:05","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tao-day-so-ngau-nhien-khong-trung-lap-trong-excel\/"},"modified":"2024-12-02T02:58:05","modified_gmt":"2024-12-02T02:58:05","slug":"tao-day-so-ngau-nhien-khong-trung-lap-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tao-day-so-ngau-nhien-khong-trung-lap-trong-excel\/","title":{"rendered":"T\u1ea1o d\u00e3y s\u1ed1 ng\u1eabu nhi\u00ean kh\u00f4ng tr\u00f9ng l\u1eb7p trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng Excel ta \u0111\u00e3 g\u1eb7p nhi\u1ec1u b\u00e0i to\u00e1n y\u00eau c\u1ea7u m\u1ed9t ho\u1eb7c nhi\u1ec1u d\u00e3y s\u1ed1 ho\u1eb7c danh s\u00e1ch ng\u1eabu nhi\u00ean, c\u1ee5 th\u1ec3 l\u00e0 m\u1ed9t d\u00e3y s\u1ed1 ng\u1eabu nhi\u00ean kh\u00f4ng tr\u00f9ng l\u1eb7p. B\u00e0i to\u00e1n t\u01b0\u1edfng \u0111\u01a1n gi\u1ea3n n\u00e0y h\u00f3a ra l\u1ea1i l\u00e0 m\u1ed9t th\u00e1ch th\u1ee9c ch\u00ednh b\u1edfi y\u00eau c\u1ea7u v\u1ec1 t\u00ednh \u0111\u1ed9c nh\u1ea5t c\u1ee7a c\u00e1c ph\u1ea7n t\u1eed trong d\u00e3y. V\u1edbi b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd ch\u1ec9 ra nh\u1eefng v\u1ea5n \u0111\u1ec1 c\u01a1 b\u1ea3n v\u00e0 m\u1ed9t v\u00e0i c\u00e1ch ti\u1ebfp c\u1eadn \u0111\u1ec3 l\u00e0m b\u00e0i to\u00e1n n\u00e0y.<\/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-674d223c466d7\" 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\/day-so-ngau-nhien-khong-trung-lap-excel.html#Bai_toan_day_so_ngau_nhien_khong_trung_lap\" title=\"B\u00e0i to\u00e1n d\u00e3y s\u1ed1 ng\u1eabu nhi\u00ean kh\u00f4ng tr\u00f9ng l\u1eb7p\">B\u00e0i to\u00e1n d\u00e3y s\u1ed1 ng\u1eabu nhi\u00ean kh\u00f4ng tr\u00f9ng l\u1eb7p<\/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\/day-so-ngau-nhien-khong-trung-lap-excel.html#Yeu_cau\" title=\"Y\u00eau c\u1ea7u\">Y\u00eau c\u1ea7u<\/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\/day-so-ngau-nhien-khong-trung-lap-excel.html#Cach_tiep_can\" title=\"C\u00e1ch ti\u1ebfp c\u1eadn\">C\u00e1ch ti\u1ebfp c\u1eadn<\/a>\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/day-so-ngau-nhien-khong-trung-lap-excel.html#Day_so_theo_thu_tu_chon_lua_theo_thu_tu\" title=\"D\u00e3y s\u1ed1 theo th\u1ee9 t\u1ef1, ch\u1ecdn l\u1ef1a theo th\u1ee9 t\u1ef1\">D\u00e3y s\u1ed1 theo th\u1ee9 t\u1ef1, ch\u1ecdn l\u1ef1a theo th\u1ee9 t\u1ef1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/day-so-ngau-nhien-khong-trung-lap-excel.html#Day_so_khong_theo_thu_tu_chon_lua_theo_thu_tu\" title=\"D\u00e3y s\u1ed1 kh\u00f4ng theo th\u1ee9 t\u1ef1, ch\u1ecdn l\u1ef1a theo th\u1ee9 t\u1ef1\">D\u00e3y s\u1ed1 kh\u00f4ng theo th\u1ee9 t\u1ef1, ch\u1ecdn l\u1ef1a theo th\u1ee9 t\u1ef1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/day-so-ngau-nhien-khong-trung-lap-excel.html#Chon_cap_so_tu_day_cho_truoc\" title=\"Ch\u1ecdn c\u1eb7p s\u1ed1 t\u1eeb d\u00e3y cho tr\u01b0\u1edbc\">Ch\u1ecdn c\u1eb7p s\u1ed1 t\u1eeb d\u00e3y cho tr\u01b0\u1edbc<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Bai_toan_day_so_ngau_nhien_khong_trung_lap\"><\/span>B\u00e0i to\u00e1n d\u00e3y s\u1ed1 ng\u1eabu nhi\u00ean kh\u00f4ng tr\u00f9ng l\u1eb7p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Yeu_cau\"><\/span>Y\u00eau c\u1ea7u<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Ch\u00fang ta s\u1ebd b\u1eaft \u0111\u1ea7u b\u1eb1ng y\u00eau c\u1ea7u nh\u1eadn \u0111\u01b0\u1ee3c sau:<\/p>\n<figure id=\"attachment_40420\" aria-describedby=\"caption-attachment-40420\" style=\"width: 612px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-40420\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screenshot-2023-02-21-102427-1.png\" width=\"612\" height=\"387\" title=\"screenshot-2023-02-21-102427-1\"><figcaption id=\"caption-attachment-40420\" class=\"wp-caption-text\">Truy c\u1eadp link b\u00e0i vi\u1ebft g\u1ed1c: <a href=\"https:\/\/www.facebook.com\/groups\/hocexcel.online\/posts\/5652560088176640\/\">https:\/\/www.facebook.com\/groups\/hocexcel.online\/posts\/5652560088176640\/<\/a><\/figcaption><\/figure>\n<p>V\u1edbi y\u00eau c\u1ea7u tr\u00ean, ta s\u1ebd chia nh\u1ecf ra th\u00e0nh t\u1eebng b\u01b0\u1edbc:<\/p>\n<p>B\u01b0\u1edbc 1: T\u1ea1o danh s\u00e1ch t\u1eeb 1 \u0111\u1ebfn 50<\/p>\n<p>B\u01b0\u1edbc 2: Ch\u1ecdn ra 25 c\u1eb7p s\u1ed1 kh\u00f4ng tr\u00f9ng l\u1eb7p<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cach_tiep_can\"><\/span>C\u00e1ch ti\u1ebfp c\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u1edbi y\u00eau c\u1ea7u n\u00e0y, ta c\u00f3 th\u1ec3 hi\u1ec3u v\u00e0 ti\u1ebfp c\u1eadn theo nhi\u1ec1u h\u01b0\u1edbng. H\u1ecdc Excel Online s\u1ebd g\u1ee3i \u00fd m\u1ed9t v\u00e0i c\u00e1ch ti\u1ebfp c\u1eadn \u0111\u1ec3 gi\u1ea3i b\u00e0i to\u00e1n, c\u00f2n l\u1ea1i c\u00e1c b\u1ea1n t\u1ef1 b\u1ed5 sung th\u00eam nh\u00e9.<\/p>\n<h5><span class=\"ez-toc-section\" id=\"Day_so_theo_thu_tu_chon_lua_theo_thu_tu\"><\/span>D\u00e3y s\u1ed1 theo th\u1ee9 t\u1ef1, ch\u1ecdn l\u1ef1a theo th\u1ee9 t\u1ef1<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>R\u00f5 r\u00e0ng l\u00e0, n\u1ebfu ta \u0111\u01b0a ra d\u00e3y s\u1ed1 t\u1eeb 1 t\u1edbi 50, sau \u0111\u00f3 l\u1ea5y 25 c\u1eb7p t\u1eeb tr\u00ean xu\u1ed1ng d\u01b0\u1edbi, ta c\u0169ng s\u1ebd c\u00f3 25 c\u1eb7p kh\u00f4ng tr\u00f9ng l\u1eb7p. \u0110\u1ec3 t\u1ea1o ra d\u00e3y t\u1eeb 1 t\u1edbi 50 c\u00f3 r\u1ea5t nhi\u1ec1u ph\u01b0\u01a1ng ph\u00e1p, ch\u1eb3ng h\u1ea1n nh\u01b0 d\u00f9ng c\u00e1c h\u00e0m, c\u00f4ng th\u1ee9c hay t\u00ednh n\u0103ng Fill.<\/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\/2024\/12\/ex101_92019-nho-51.gif\" title=\"ex101_92019-nho-51\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure id=\"attachment_40422\" aria-describedby=\"caption-attachment-40422\" style=\"width: 324px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-40422\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screenshot-2023-02-21-103812-1.png\" width=\"324\" height=\"465\" title=\"screenshot-2023-02-21-103812-1\"><figcaption id=\"caption-attachment-40422\" class=\"wp-caption-text\">M\u1ed9t v\u00e0i c\u00e1ch t\u1ea1o d\u00e3y s\u1ed1 t\u1eeb 1 t\u1edbi 50<\/figcaption><\/figure>\n<p>Sau \u0111\u00f3 ta l\u1ea5y ra t\u1eebng c\u1eb7p t\u1eeb tr\u00ean xu\u1ed1ng d\u01b0\u1edbi. C\u00e1ch l\u1ea5y chi ti\u1ebft s\u1ebd \u0111\u01b0\u1ee3c nh\u1eafc \u0111\u1ebfn <strong><a href=\"https:\/\/blog.hocexcel.online\/day-so-ngau-nhien-khong-trung-lap-excel.html#chon_cap_so\">\u1edf ph\u1ea7n d\u01b0\u1edbi<\/a><\/strong>.<\/p>\n<h5><span class=\"ez-toc-section\" id=\"Day_so_khong_theo_thu_tu_chon_lua_theo_thu_tu\"><\/span>D\u00e3y s\u1ed1 kh\u00f4ng theo th\u1ee9 t\u1ef1, ch\u1ecdn l\u1ef1a theo th\u1ee9 t\u1ef1<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>Tr\u00ean th\u1ef1c t\u1ebf, ta th\u01b0\u1eddng mu\u1ed1n v\u00e0 \u1ee9ng d\u1ee5ng c\u00e1c c\u1eb7p s\u1ed1 c\u00f3 t\u00ednh \u201cng\u1eabu nhi\u00ean\u201d. V\u1ea5n \u0111\u1ec1 nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng hay m\u1eafc ph\u1ea3i n\u1eb1m \u1edf \u0111\u00e2y, \u0111\u00f3 l\u00e0m th\u1ebf n\u00e0o t\u1ea1o \u0111\u01b0\u1ee3c m\u1ed9t d\u00e3y s\u1ed1 kh\u00f4ng theo th\u1ee9 t\u1ef1 m\u00e0\u00a0<strong>kh\u00f4ng tr\u00f9ng l\u1eb7p<\/strong>. L\u00fd do cho s\u1ef1 kh\u00f3 kh\u0103n n\u00e0y l\u00e0 do c\u00e1c h\u00e0m \u201cng\u1eabu nhi\u00ean\u201d c\u00f3 s\u1eb5n c\u1ee7a Excel kh\u00f4ng th\u1ec3 \u0111\u1ea3m b\u1ea3o \u0111i\u1ec1u \u0111\u00f3. V\u00ed d\u1ee5 nh\u01b0 h\u00e0m <strong>RANDBETWEEN<\/strong> r\u1ea5t th\u00f4ng d\u1ee5ng, nh\u01b0ng n\u1ebfu b\u1ea1n \u00e1p d\u1ee5ng c\u00f9ng l\u00fac 50 h\u00e0m cho 50 \u00f4, ch\u1eafc ch\u1eafn s\u1ebd c\u00f3 \u00edt nh\u1ea5t 2 \u00f4 tr\u00f9ng nhau.<\/p>\n<p>V\u1eady, \u0111\u1ec3 t\u1ea1o ra d\u00e3y s\u1ed1 kh\u00f4ng theo th\u1ee9 t\u1ef1 trong Excel ta l\u00e0m nh\u01b0 th\u1ebf n\u00e0o?<\/p>\n<p><strong>T\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean v\u00e0 l\u1ecdc tr\u00f9ng<\/strong><\/p>\n<p>V\u1edbi ph\u01b0\u01a1ng ph\u00e1p n\u00e0y, ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m\u00a0<strong>RANDBETWEEN<\/strong> ho\u1eb7c\u00a0<strong>RANDARRAY\u00a0<\/strong>(trong tr\u01b0\u1eddng h\u1ee3p m\u00e1y b\u1ea1n s\u1eed d\u1ee5ng Office 365)\u00a0cho kho\u1ea3ng\u2026. 9999 \u00f4 (c\u00e0ng nhi\u1ec1u \u00f4 c\u00e0ng t\u1ed1t, m\u1ee5c \u0111\u00edch l\u00e0 \u0111\u1ec3 c\u00e1c s\u1ed1 \u0111\u1ec1u xu\u1ea5t hi\u1ec7n \u00edt nh\u1ea5t 1 l\u1ea7n), sau \u0111\u00f3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m <strong>UNIQUE\u00a0<\/strong>(phi\u00ean b\u1ea3n Office 365) ho\u1eb7c k\u1ebft h\u1ee3p v\u1edbi h\u00e0m\u00a0<strong>RANK <\/strong>t\u1ea1i\u00a0c\u1ed9t ph\u1ee5 \u0111\u1ec3 l\u1ea5y ra c\u00e1c gi\u00e1 tr\u1ecb \u0111\u1ed9c nh\u1ea5t.<\/p>\n<p><strong>S\u1eed d\u1ee5ng Office 365:<\/strong><\/p>\n<p>V\u1edbi Office 365 ta c\u00f3 c\u00f4ng th\u1ee9c sau:<\/p>\n<blockquote>\n<pre>=UNIQUE(RANDARRAY(9999,1,1,50,TRUE))<\/pre>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-40426\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screenshot-2023-02-21-111727-1.png\" width=\"292\" height=\"462\" title=\"screenshot-2023-02-21-111727-1\"><\/p>\n<p>V\u1eady l\u00e0 ta \u0111\u00e3 c\u00f3 \u0111\u01b0\u1ee3c 1 d\u00e3y s\u1ed1 ng\u1eabu nhi\u00ean t\u1eeb 1 t\u1edbi 50 kh\u00f4ng tr\u00f9ng nhau. C\u00f4ng vi\u1ec7c ti\u1ebfp theo l\u00e0 ch\u1ecdn c\u1eb7p, s\u1ebd \u0111\u01b0\u1ee3c n\u00f3i t\u1edbi <strong><a href=\"https:\/\/blog.hocexcel.online\/day-so-ngau-nhien-khong-trung-lap-excel.html#chon_cap_so\">\u1edf ph\u1ea7n d\u01b0\u1edbi<\/a><\/strong>.<\/p>\n<p><strong>S\u1eed d\u1ee5ng phi\u00ean b\u1ea3n Office ngo\u00e0i 365<\/strong><\/p>\n<p>N\u1ebfu kh\u00f4ng s\u1eed d\u1ee5ng Office 365, ta c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m RANK ho\u1eb7c RANK.EQ (c\u00f3 t\u1eeb phi\u00ean b\u1ea3n Excel 2010) trong c\u1ed9t ph\u1ee5 \u0111\u1ec3 l\u1ea5y ra danh s\u00e1ch 50 s\u1ed1 kh\u00f4ng tr\u00f9ng l\u1eb7p t\u1eeb 1 t\u1edbi 50. C\u1ee5 th\u1ec3:<\/p>\n<p>\u0110\u1ea7u ti\u00ean, ta v\u1eabn t\u1ea1o 1 d\u00e3y s\u1ed1 v\u1edbi h\u00e0m RANDBETWEEN, tuy nhi\u00ean l\u1ea7n n\u00e0y kh\u00f4ng ph\u1ea3i 9999 m\u00e0 ta ch\u1ec9 c\u1ea7n 50 h\u00e0m RANDBETWEEN nh\u01b0 sau:<\/p>\n<blockquote>\n<pre>=RANDBETWEEN(1,50)<\/pre>\n<\/blockquote>\n<figure id=\"attachment_40427\" aria-describedby=\"caption-attachment-40427\" style=\"width: 364px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-40427\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screenshot-2023-02-21-112457-1.png\" width=\"364\" height=\"504\" title=\"screenshot-2023-02-21-112457-1\"><figcaption id=\"caption-attachment-40427\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng 50 h\u00e0m RANDBETWEEN b\u1eb1ng c\u00e1ch Autofill<\/figcaption><\/figure>\n<p>Sau khi t\u1ea1o, ta nh\u1eadn ra s\u1ebd c\u00f3 kha kh\u00e1 s\u1ed1 tr\u00f9ng l\u1eb7p v\u1edbi nhau, b\u1edfi v\u1eady ta c\u1ea7n s\u1eed d\u1ee5ng\u00a0<strong>c\u1ed9t ph\u1ee5<\/strong>. Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y c\u00f3 \u00fd t\u01b0\u1edfng t\u1eeb vi\u1ec7c\u00a0<strong>x\u1ebfp h\u1ea1ng<\/strong> c\u00e1c s\u1ed1, n\u1ebfu\u00a0<strong>2 s\u1ed1 b\u1eb1ng nhau<\/strong> s\u1ebd\u00a0<strong>t\u0103ng th\u00eam 1 h\u1ea1ng<\/strong><strong> cho s\u1ed1 \u1edf sau.\u00a0<\/strong>B\u1edfi v\u1eady, \u0111\u1ebfn cu\u1ed1i c\u00f9ng ta s\u1ebd c\u00f3 1 d\u00e3y t\u1eeb 1 t\u1edbi 50 ng\u1eabu nhi\u00ean m\u00e0 kh\u00f4ng c\u1ea7n quan t\u00e2m c\u00f3 bao nhi\u00eau s\u1ed1 b\u1ecb tr\u00f9ng t\u1ea1i c\u1ed9t ch\u00ednh.<\/p>\n<blockquote>\n<pre>=RANK.EQ(A2,$A$2:$A$50)+COUNTIFS($A$2:A2,A2)-1<\/pre>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-40428\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screenshot-2023-02-21-113038-1.png\" width=\"576\" height=\"503\" title=\"screenshot-2023-02-21-113038-1\"><\/p>\n<h5 id=\"chon_cap_so\"><span class=\"ez-toc-section\" id=\"Chon_cap_so_tu_day_cho_truoc\"><\/span>Ch\u1ecdn c\u1eb7p s\u1ed1 t\u1eeb d\u00e3y cho tr\u01b0\u1edbc<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>V\u1edbi d\u00e3y s\u1ed1 \u0111\u00e3 c\u00f3, ta s\u1ebd ti\u1ebfn h\u00e0nh ch\u1ecdn ra 25 c\u1eb7p s\u1ed1. B\u1edfi d\u00e3y s\u1ed1 \u0111\u00e3 ng\u1eabu nhi\u00ean n\u00ean ta kh\u00f4ng c\u1ea7n ch\u1ecdn ng\u1eabu nhi\u00ean \u00f4 n\u00e0o n\u1eefa, m\u00e0 ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 ch\u1ecdn t\u1eeb tr\u00ean xu\u1ed1ng d\u01b0\u1edbi.<br \/>\nTrong Office 365, h\u00e0m WRAPCOLS ho\u1eb7c WRAPROWS s\u1ebd gi\u00fap ta l\u00e0m c\u00f4ng vi\u1ec7c n\u00e0y d\u1ec5 d\u00e0ng:<\/p>\n<blockquote>\n<pre>=WRAPROWS($B$2:$B$50,25)<\/pre>\n<\/blockquote>\n<p>ho\u1eb7c<\/p>\n<blockquote>\n<pre>=WRAPCOLS($B$2:$B$50,2)<\/pre>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-40431\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screenshot-2023-02-21-115029-1.png\" width=\"1200\" height=\"231\" title=\"screenshot-2023-02-21-115029-1\"><\/p>\n<p>C\u00f2n n\u1ebfu b\u1ea1n \u0111ang d\u00f9ng phi\u00ean b\u1ea3n kh\u00e1c? Ta ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng INDEX k\u1ebft h\u1ee3p v\u1edbi m\u1ed9t ch\u00fat ki\u1ebfn th\u1ee9c to\u00e1n \u0111\u1ec3 l\u1ea5y ra t\u1eebng \u00f4 trong d\u00e3y.<\/p>\n<blockquote>\n<pre>=INDEX($B$2:$B$50,ROW(A1)+(COLUMN(A1)-1)*2)<\/pre>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-40432\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screenshot-2023-02-21-115402-1.png\" width=\"1366\" height=\"316\" title=\"screenshot-2023-02-21-115402-1\"><\/p>\n<p>V\u00ec sao l\u1ea1i l\u00e0 ROW + COLUMN? C\u00e1c b\u1ea1n h\u00e3y nh\u00ecn g\u1ee3i \u00fd b\u00ean d\u01b0\u1edbi \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u v\u00e0 \u0111o\u00e1n nh\u00e9 \ud83d\ude09 (<em>g\u1ee3i \u00fd: 1=1+(1-1)*2, 3=1+(2-1)*2<\/em>).<\/p>\n<hr>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00e1ch c\u01a1 b\u1ea3n \u0111\u1ec3 c\u00f3 th\u1ec3 t\u1ea1o ra d\u00e3y s\u1ed1 ng\u1eabu nhi\u00ean kh\u00f4ng tr\u00f9ng l\u1eb7p. V\u1ec1 c\u00e1c \u1ee9ng d\u1ee5ng kh\u00e1c, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-lay-danh-sach-ngau-nhien-khong-trung-lap-trong-excel.html\"><strong>L\u1ea5y danh s\u00e1ch ng\u1eabu nhi\u00ean kh\u00f4ng tr\u00f9ng l\u1eb7p trong Excel<\/strong><\/a><\/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\/2024\/12\/ex101_92019-nho-51.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":864,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-863","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\/863","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=863"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/863\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/864"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=863"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=863"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=863"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}