{"id":714,"date":"2024-12-02T02:44:17","date_gmt":"2024-12-02T02:44:17","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/su-khac-biet-khi-xu-ly-nested-array-cua-cong-thuc-mang-cu-va-moi-trong-excel\/"},"modified":"2024-12-02T02:44:17","modified_gmt":"2024-12-02T02:44:17","slug":"su-khac-biet-khi-xu-ly-nested-array-cua-cong-thuc-mang-cu-va-moi-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/su-khac-biet-khi-xu-ly-nested-array-cua-cong-thuc-mang-cu-va-moi-trong-excel\/","title":{"rendered":"S\u1ef1 kh\u00e1c bi\u1ec7t khi x\u1eed l\u00fd nested array c\u1ee7a c\u00f4ng th\u1ee9c m\u1ea3ng c\u0169 v\u00e0 m\u1edbi trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Ch\u00fang ta h\u1eb3n \u00edt nhi\u1ec1u \u0111\u00e3 bi\u1ebft v\u1ec1 kh\u00e1i ni\u1ec7m <strong>m\u1ea3ng <\/strong>\u2013 <strong>array<\/strong> trong Excel r\u1ed3i ph\u1ea3i kh\u00f4ng n\u00e0o? Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd n\u00f3i \u0111\u1ebfn <strong>nested array<\/strong> (m\u1ea3ng l\u1ed3ng), c\u0169ng nh\u01b0 s\u1ef1 kh\u00e1c bi\u1ec7t c\u1ee7a c\u00f4ng th\u1ee9c m\u1ea3ng c\u0169 (CSE) v\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng m\u1edbi (Dynamic array) khi x\u1eed l\u00fd nested array nh\u00e9.<\/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-674d1f002af62\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/xu-ly-nested-array-cu-va-moi.html#Bai_toan_ve_Nested_array\" title=\"B\u00e0i to\u00e1n v\u1ec1 Nested array\">B\u00e0i to\u00e1n v\u1ec1 Nested array<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/xu-ly-nested-array-cu-va-moi.html#Cach_Dynamic_Array_xu_ly_nested_array\" title=\"C\u00e1ch Dynamic Array x\u1eed l\u00fd nested array\">C\u00e1ch Dynamic Array x\u1eed l\u00fd nested array<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/xu-ly-nested-array-cu-va-moi.html#Cach_cong_thuc_mang_cu_CSE_xu_ly_nested_array\" title=\"C\u00e1ch c\u00f4ng th\u1ee9c m\u1ea3ng c\u0169 (CSE) x\u1eed l\u00fd nested array\">C\u00e1ch c\u00f4ng th\u1ee9c m\u1ea3ng c\u0169 (CSE) x\u1eed l\u00fd nested array<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/xu-ly-nested-array-cu-va-moi.html#Vi_du\" title=\"V\u00ed d\u1ee5\">V\u00ed d\u1ee5<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Bai_toan_ve_Nested_array\"><\/span>B\u00e0i to\u00e1n v\u1ec1 Nested array<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong Excel, ta c\u00f3 th\u1ec3 t\u1ea1o ra m\u1ed9t m\u1ea3ng b\u1eb1ng c\u00e1c c\u00e1ch kh\u00e1c nhau. V\u1edbi c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t, ta vi\u1ebft trong d\u1ea5u ngo\u1eb7c nh\u1ecdn nh\u01b0 h\u00ecnh:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"224\" height=\"226\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/image-11.png\" class=\"wp-image-42233\" title=\"image-11\"><\/figure>\n<\/div>\n<p>T\u1ea1i \u0111\u00e2y, ta \u0111\u00e3 t\u1ea1o ra 1 m\u1ea3ng g\u1ed3m 3 ph\u1ea7n t\u1eed bao g\u1ed3m 3 ph\u1ea7n t\u1eed: 1, 2, 3.<\/p>\n<p><em>Trong t\u00e0i li\u1ec7u Excel t\u1eebng ch\u00fa th\u00edch m\u1ea3ng s\u1ebd lu\u00f4n lu\u00f4n l\u00e0 m\u1ea3ng 2 chi\u1ec1u, tuy nhi\u00ean \u0111\u00f3 s\u1ebd l\u00e0 n\u1ed9i dung trong m\u1ed9t b\u00e0i vi\u1ebft kh\u00e1c. V\u1edbi b\u00e0i vi\u1ebft n\u00e0y, ta s\u1ebd t\u1eadp trung v\u00e0o m\u1ea3ng g\u1ed9p \u2013 nested array<\/em>.<\/p>\n<p>V\u1eady nested array l\u00e0 g\u00ec?<\/p>\n<p>C\u00f3 th\u1ec3 h\u00ecnh dung \u0111\u01a1n gi\u1ea3n, thay v\u00ec {1;2;3} gi\u1edd ch\u00fang ta c\u00f3 {{1;2;3};{4;5;6};{7;8;9}}. C\u0169ng c\u00f3 ngh\u0129a l\u00e0 \u2013 m\u1ea3ng trong m\u1ea3ng.<\/p>\n<p>Tuy nhi\u00ean, ta kh\u00f4ng th\u1ec3 vi\u1ebft tr\u1ef1c ti\u1ebfp 2 d\u1ea5u ngo\u1eb7c nh\u1ecdn. M\u00e0 \u0111\u1ec3 t\u1ea1o ra nested array ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t v\u00e0i ph\u01b0\u01a1ng ph\u00e1p, ch\u1eb3ng h\u1ea1n nh\u01b0 d\u00f9ng h\u00e0m INDEX:<\/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-39.gif\" title=\"ex101_92019-nho-39\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<pre class=\"wp-block-code\"><code>=INDEX({1,4,7;2,5,8;3,6,9},0,{1;2;3})<\/code><\/pre>\n<p>H\u00e0m s\u1ebd cho ra k\u1ebft qu\u1ea3: {{1;2;3};{4;5;6};{7;8;9}}. Tuy nhi\u00ean:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"482\" height=\"178\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/image-2-4.png\" class=\"wp-image-42235\" title=\"image-2-4\"><\/figure>\n<\/div>\n<p>Excel s\u1ebd kh\u00f4ng th\u1ec3 hi\u1ec3n th\u1ecb ra \u0111\u01b0\u1ee3c, b\u1edfi c\u00e1c m\u1ea3ng \u0111ang \u0111\u00e8 l\u00ean nhau. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u ng\u1ea7m r\u1eb1ng, b\u00ean d\u01b0\u1edbi s\u1ed1 1 kia th\u1ef1c t\u1ebf l\u00e0 m\u1ea3ng {1;2;3}.<\/p>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cach_Dynamic_Array_xu_ly_nested_array\"><\/span>C\u00e1ch Dynamic Array x\u1eed l\u00fd nested array<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Dynamic Array (m\u1ea3ng \u0111\u1ed9ng) xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean trong phi\u00ean b\u1ea3n Office 365. T\u00ednh n\u0103ng n\u00e0y cho ph\u00e9p ch\u00fang ta vi\u1ebft v\u00e0 tr\u1ea3 v\u1ec1 m\u1ea3ng d\u1ec5 d\u00e0ng h\u01a1n tr\u01b0\u1edbc \u0111\u00e2y r\u1ea5t nhi\u1ec1u. C\u1ee5 th\u1ec3, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm \u0111\u1ecdc b\u00e0i vi\u1ebft:<\/p>\n<p>Dynamic array: <a href=\"http:\/\/blog.ezworkapp.com\/microsoft-excel-2018-dynamic-array.html\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/blog.hocexcel.online\/microsoft-excel-2018-dynamic-array.html<\/a><\/p>\n<p>V\u1eady Dynamic array x\u1eed l\u00fd nested array nh\u01b0 th\u1ebf n\u00e0o? N\u00f3 \u0111\u01b0\u1ee3c x\u1eed l\u00fd theo c\u00e1ch \u201c\u0111\u01a1n gi\u1ea3n h\u00f3a\u201d: hi\u1ec3n th\u1ecb ph\u1ea7n t\u1eed \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ea3ng con v\u00e0 b\u1ecf m\u1ea3ng l\u1ed3ng. T\u1ea5t nhi\u00ean, c\u00f2n c\u00e1c quy t\u1eafc kh\u00e1c m\u00e0 Microsoft c\u00f3 v\u00e0 kh\u00f4ng chia s\u1ebb, nh\u01b0ng n\u00f3 kh\u00f4ng thu\u1ed9c ph\u1ea1m vi b\u00e0i vi\u1ebft n\u00e0y.<\/p>\n<p>V\u00ed d\u1ee5, trong tr\u01b0\u1eddng h\u1ee3p tr\u00ean, Excel \u0111\u00e3 l\u1ea5y ra 3 ph\u1ea7n t\u1eed 1-4-7 t\u01b0\u01a1ng \u1ee9ng 3 ph\u1ea7n t\u1eed \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ea3ng {1;2;3};{4;5;6};{7;8;9} sau khi x\u1eed l\u00fd h\u00e0m INDEX:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/image-3-4.png\" class=\"wp-image-42236\" width=\"482\" height=\"178\" title=\"image-3-4\"><\/figure>\n<\/div>\n<p>V\u00e0 n\u1ebfu ch\u00fang ta l\u1ed3ng ra b\u00ean ngo\u00e0i 1 h\u00e0m SUM, ta s\u1ebd c\u00f3 k\u1ebft qu\u1ea3 l\u00e0 12.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/image-4-3.png\" class=\"wp-image-42237\" width=\"558\" height=\"179\" title=\"image-4-3\"><\/figure>\n<\/div>\n<p>V\u1eady c\u00f4ng th\u1ee9c m\u1ea3ng c\u0169 x\u1eed l\u00fd ra sao?<\/p>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cach_cong_thuc_mang_cu_CSE_xu_ly_nested_array\"><\/span>C\u00e1ch c\u00f4ng th\u1ee9c m\u1ea3ng c\u0169 (CSE) x\u1eed l\u00fd nested array<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu b\u1ea1n ngh\u0129 c\u00f4ng th\u1ee9c m\u1ea3ng trong c\u00e1c phi\u00ean b\u1ea3n c\u0169 c\u0169ng x\u1eed l\u00fd gi\u1ed1ng nh\u01b0 v\u1eady, th\u00ec kh\u00f4ng ph\u1ea3i \u0111\u00e2u!<\/p>\n<p><em>V\u00e0 t\u1ea1i sao c\u00f4ng th\u1ee9c m\u1ea3ng c\u0169 l\u1ea1i g\u1ecdi l\u00e0 CSE nh\u1ec9? V\u00ec khi nh\u1eadp c\u00f4ng th\u1ee9c m\u1ea3ng c\u0169, ta c\u1ea7n \u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl+Shift+Enter thay v\u00ec Enter \u0111\u00f3.<\/em><\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"549\" height=\"170\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/image-5-3.png\" class=\"wp-image-42238\" title=\"image-5-3\"><\/figure>\n<\/div>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y trong h\u00ecnh, v\u1edbi c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1eb7t t\u1ea1i \u00f4 F1, k\u1ebft qu\u1ea3 tr\u1ea3 l\u00e0 6, ch\u1ee9 kh\u00f4ng ph\u1ea3i 12.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"563\" height=\"186\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/image-6-3.png\" class=\"wp-image-42239\" title=\"image-6-3\"><\/figure>\n<\/div>\n<p>V\u00e0 n\u1ebfu ch\u00fang ta ch\u1ecdn 2 \u00f4 sau \u0111\u00f3 s\u1eed d\u1ee5ng CSE, k\u1ebft qu\u1ea3 l\u1ea1i l\u00e0 15.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"563\" height=\"169\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/image-7-3.png\" class=\"wp-image-42240\" title=\"image-7-3\"><\/figure>\n<\/div>\n<p>V\u1edbi 3 \u00f4 v\u00e0 CSE, k\u1ebft qu\u1ea3 l\u1ea7n l\u01b0\u1ee3t l\u00e0 6 \u2013 15 -24. T\u1ea1i sao v\u1eady?<\/p>\n<p>C\u00e2u tr\u1ea3 l\u1eddi r\u1ea5t \u0111\u01a1n gi\u1ea3n: H\u00e3y nh\u00ecn l\u1ea1i m\u1ea3ng l\u1ed3ng {{1;2;3};{4;5;6};{7;8;9}}. N\u1ebfu ta t\u00e1ch th\u00e0nh 3 m\u1ea3ng con, th\u00ec m\u1ed7i \u00f4 t\u1eeb F1 \u0111\u1ebfn F3 s\u1ebd t\u01b0\u01a1ng \u1ee9ng v\u1edbi m\u1ed9t l\u1ea7n SUM cho m\u1ea3ng con trong \u0111\u00f3.<\/p>\n<p>V\u00e0 \u0111\u00f3 l\u00e0 s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa c\u00e1ch x\u1eed l\u00fd nested array c\u1ee7a Dynamic array v\u00e0 CSE. <\/p>\n<p>C\u0169ng trong b\u00e0i vi\u1ebft n\u00e0y, m\u00ecnh c\u00f3 m\u1ed9t v\u00e0i note nho nh\u1ecf:<br \/>-H\u00e0m INDEX s\u1ebd tr\u1ea3 v\u1ec1 nested array n\u1ebfu \u0111\u1ed1i s\u1ed1 row_number ho\u1eb7c column_number l\u00e0 d\u1ea1ng m\u1ea3ng, d\u00f9 ch\u1ec9 tham chi\u1ebfu t\u1edbi 1 ph\u1ea7n t\u1eed. VD: =INDEX({1;2;3;4},{1;2}) s\u1ebd tr\u1ea3 v\u1ec1 {{1};{2}} v\u00e0 \u0111\u01b0\u1ee3c gi\u1ea3n l\u01b0\u1ee3c th\u00e0nh {1;2} n\u1ebfu s\u1eed d\u1ee5ng dynamic array.<\/p>\n<p>-H\u00e0m LOOKUP kh\u00f4ng tr\u1ea3 v\u1ec1 nested array. VD: LOOKUP({1;2},{1;2;3;4},{1;2;3;4}) s\u1ebd tr\u1ea3 v\u1ec1 {1;2} k\u1ec3 c\u1ea3 CSE.<\/p>\n<p>-H\u00e0m VLOOKUP c\u00f3 v\u1ebb tr\u1ea3 v\u1ec1 nested array ho\u1eb7c kh\u00f4ng t\u00f9y v\u00e0o s\u1ed1 l\u01b0\u1ee3ng \u00f4 \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng CSE. L\u00fd thuy\u1ebft n\u00e0y H\u1ecdc Excel Online \u0111ang nghi\u00ean c\u1ee9u th\u00eam.<\/p>\n<p>-H\u00e0m ROW trong phi\u00ean b\u1ea3n Office 2013 (v\u00e0 c\u00f3 th\u1ec3 1 v\u00e0i phi\u00ean b\u1ea3n kh\u00e1c) tr\u1ea3 v\u1ec1 nested array. Trong phi\u00ean b\u1ea3n Office 365 kh\u00f4ng tr\u1ea3 v\u1ec1 nested array d\u00f9 d\u00f9ng CSE hay dynamic array.<\/p>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span>V\u00ed d\u1ee5<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Cho b\u1ea3ng sau, v\u1edbi d\u1eef li\u1ec7u t\u1eeb \u00f4 C3 t\u1edbi F5:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"615\" height=\"205\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/image-8-2.png\" class=\"wp-image-42241\" title=\"image-8-2\"><\/figure>\n<\/div>\n<p>\u00c1p d\u1ee5ng l\u00fd thuy\u1ebft tr\u00ean, ta c\u00f3 th\u1ec3 t\u00ednh running total cho t\u1eebng d\u00f2ng trong b\u1ea3ng ch\u1ec9 v\u1edbi duy nh\u1ea5t 1 c\u00f4ng th\u1ee9c:<\/p>\n<pre class=\"wp-block-code\"><code>=TRANSPOSE(MMULT(\n     TRANSPOSE(TRANSPOSE(INDEX(C3:F5,{1;2;3},))*\n        (ROW(INDIRECT(\"1:\"&amp;COUNTA(INDEX(C3:F5,{1;2;3},))))&lt;=TRANSPOSE(ROW(INDIRECT(\"1:\"&amp;COUNTA(INDEX(C3:F5,{1;2;3},))))))),\n         ROW(INDIRECT(\"1:\"&amp;COUNTA(INDEX(C3:F5,{1;2;3},))))^0))<\/code><\/pre>\n<p>C\u00e1ch t\u00ednh: Ch\u1ecdn m\u1ed9t v\u00f9ng c\u00f9ng k\u00edch c\u1ee1 b\u1ea3ng (4\u00d73) \u0111\u1ec3 hi\u1ec3n th\u1ecb \u0111\u01b0\u1ee3c h\u1ebft running total (VD: H7:K9). \u0110\u1eb7t c\u00f4ng th\u1ee9c tr\u00ean v\u00e0o v\u00e0 \u1ea5n CSE.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"343\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/image-9-1024x343-2.png\" class=\"wp-image-42242\" title=\"image-9-1024x343-2\"><figcaption class=\"wp-element-caption\">\u1ee8ng d\u1ee5ng x\u1eed l\u00fd nested array \u0111\u1ec3 t\u00ednh runnning total trong 1 c\u00f4ng th\u1ee9c duy nh\u1ea5t<\/figcaption><\/figure>\n<\/div>\n<p>L\u01b0u \u00fd: c\u00f4ng th\u1ee9c tr\u00ean s\u1ebd kh\u00f4ng tr\u1ea3 v\u1ec1 \u0111\u00fang gi\u00e1 tr\u1ecb n\u1ebfu s\u1eed d\u1ee5ng Dynamic array. Ngo\u00e0i ra t\u1ea1i phi\u00ean b\u1ea3n Office 2013 c\u00f3 th\u1ec3 s\u1ebd kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng v\u00ec c\u00e1ch vi\u1ebft h\u00e0m ROW t\u1ea1i phi\u00ean b\u1ea3n \u0111\u00f3 kh\u00e1c. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1eed l\u1ea1i nh\u00e9.<\/p>\n<hr class=\"wp-block-separator has-alpha-channel-opacity\">\n<p>\u0110\u1ecdc th\u00eam 1 s\u1ed1 b\u00e0i vi\u1ebft kh\u00e1c:<br \/>M\u1ea3ng \u0111\u1ed9ng trong Excel: <a href=\"http:\/\/blog.ezworkapp.com\/ham-mang-dong-trong-excel-dynamic-array-formulas-phan-1-ham-co-kha-nang-mo-rong-vung-du-lieu.html\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/blog.hocexcel.online\/ham-mang-dong-trong-excel-dynamic-array-formulas-phan-1-ham-co-kha-nang-mo-rong-vung-du-lieu.html<\/a><\/p>\n<p>C\u00f4ng th\u1ee9c m\u1ea3ng c\u0169 trong Excel: <a href=\"http:\/\/blog.ezworkapp.com\/cong-thuc-mang-trong-excel.html\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/blog.hocexcel.online\/cong-thuc-mang-trong-excel.html<\/a><\/p>\n<\/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-39.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":715,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-714","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\/714","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=714"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/714\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/715"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=714"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=714"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=714"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}