{"id":1861,"date":"2024-12-02T06:19:08","date_gmt":"2024-12-02T06:19:08","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/microsoft-excel-hau-2018-cuoc-cach-mang-cua-dynamic-array\/"},"modified":"2024-12-02T06:19:08","modified_gmt":"2024-12-02T06:19:08","slug":"microsoft-excel-hau-2018-cuoc-cach-mang-cua-dynamic-array","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/microsoft-excel-hau-2018-cuoc-cach-mang-cua-dynamic-array\/","title":{"rendered":"Microsoft Excel \u201ch\u1eadu 2018\u201d: Cu\u1ed9c c\u00e1ch m\u1ea1ng c\u1ee7a Dynamic Array"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<div>T\u1eeb tr\u01b0\u1edbc \u0111\u1ebfn nay ch\u00fang ta \u0111\u00e3 qu\u00e1 quen thu\u1ed9c v\u1edbi Microsoft Excel (Excel) \u2013 m\u1ed9t ch\u01b0\u01a1ng tr\u00ecnh b\u1ea3ng t\u00ednh m\u00e0 nh\u1eafc \u0111\u1ebfn th\u00f4i l\u00e0 ai c\u0169ng bi\u1ebft. H\u1ecdc sinh \u0111\u01b0\u1ee3c d\u1ea1y Excel trong ch\u01b0\u01a1ng tr\u00ecnh tin h\u1ecdc c\u01a1 s\u1edf. Sinh vi\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 l\u00e0m b\u00e0i. Gi\u00e1o vi\u00ean s\u1eed d\u1ee5ng Excel trong c\u00f4ng vi\u1ec7c v\u00e0 kh\u1ed1i v\u0103n ph\u00f2ng ch\u1eafc ch\u1eafn kh\u00f4ng th\u1ec3 kh\u00f4ng c\u00e0i Excel trong m\u00e1y. V\u00e0 ngay c\u1ea3 nh\u1eefng ng\u01b0\u1eddi kh\u00f4ng l\u00e0m vi\u1ec7c li\u00ean quan t\u1edbi b\u1ea3ng t\u00ednh, th\u00ec Excel, d\u00f9 x\u00e0i \u201cch\u00f9a\u201d hay b\u1ea3n quy\u1ec1n, lu\u00f4n \u0111\u01b0\u1ee3c c\u00e0i s\u1eb5n trong m\u00e1y (\u00edt nh\u1ea5t l\u00e0 n\u1ebfu m\u00e1y \u0111\u00f3 ch\u1ea1y h\u1ec7 \u0111i\u1ec1u h\u00e0nh Windows). B\u1edfi l\u1ebd \u0111\u00f3, ch\u00fang ta lu\u00f4n t\u01b0\u1edfng r\u1eb1ng \u0111\u00e3 qu\u00e1 th\u00e2n thu\u1ed9c v\u1edbi Excel, cho \u0111\u1ebfn n\u0103m 2018.<\/div>\n<div>\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"fr-fic fr-dib img-focus fr-draggable alignnone\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%201280%201190'%3E%3C\/svg%3E\" alt=\"\" width=\"1280\" height=\"1190\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2238478092bd11eba890131d97a772e4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"fr-fic fr-dib img-focus fr-draggable alignnone\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2238478092bd11eba890131d97a772e4.png\" width=\"1280\" height=\"1190\" title=\"2238478092bd11eba890131d97a772e4\"><figcaption class=\"image-description\">B\u1ea1n \u0111\u00e3 bi\u1ebft logo m\u1edbi c\u1ee7a Microsoft Excel ch\u01b0a?<\/figcaption><\/figure>\n<\/div>\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-674d515b56129\" 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<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/microsoft-excel-2018-dynamic-array.html#Vay_trong_nam_do_Excel_da_trai_qua_%E2%80%9Cbien_co%E2%80%9D_gi\" title=\"V\u1eady trong n\u0103m \u0111\u00f3, Excel \u0111\u00e3 tr\u1ea3i qua \u201cbi\u1ebfn c\u1ed1\u201d g\u00ec?\">V\u1eady trong n\u0103m \u0111\u00f3, Excel \u0111\u00e3 tr\u1ea3i qua \u201cbi\u1ebfn c\u1ed1\u201d g\u00ec?<\/a><\/li>\n<\/ul>\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\/microsoft-excel-2018-dynamic-array.html#Vay_thi_Dynamic_Array_la_gi_va_no_da_thay_doi_nguoi_dung_ra_sao\" title=\"V\u1eady th\u00ec Dynamic Array l\u00e0 g\u00ec v\u00e0 n\u00f3 \u0111\u00e3 thay \u0111\u1ed5i ng\u01b0\u1eddi d\u00f9ng ra sao?\">V\u1eady th\u00ec Dynamic Array l\u00e0 g\u00ec v\u00e0 n\u00f3 \u0111\u00e3 thay \u0111\u1ed5i ng\u01b0\u1eddi d\u00f9ng ra sao?<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Vay_trong_nam_do_Excel_da_trai_qua_%E2%80%9Cbien_co%E2%80%9D_gi\"><\/span>V\u1eady trong n\u0103m \u0111\u00f3, Excel \u0111\u00e3 tr\u1ea3i qua \u201cbi\u1ebfn c\u1ed1\u201d g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div><\/div>\n<div>Ng\u01b0\u1ee3c d\u00f2ng th\u1eddi gian v\u1ec1 th\u00e1ng 11 n\u0103m 2015, th\u1eddi \u0111i\u1ec3m <a href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/11\/13\/the-evolution-of-powerpoint-introducing-designer-and-morph\/\" target=\"_blank\" rel=\"noopener noreferrer\">d\u1ef1 \u00e1n <strong>Office Insider<\/strong><\/a><strong>\u00a0<\/strong>\u0111\u01b0\u1ee3c ra m\u1eaft. \u0110\u00e2y l\u00e0 m\u1ed9t d\u1ef1 \u00e1n m\u00e0 n\u00f3i theo c\u00e1ch \u0111\u01a1n gi\u1ea3n s\u1ebd cho b\u1ea1n tr\u1ea3i nghi\u1ec7m nh\u1eefng c\u1eadp nh\u1eadt m\u1edbi nh\u1ea5t (m\u1ed9t s\u1ed1 k\u00e8m theo c\u1ea3 l\u1ed7i) n\u1ebfu b\u1ea1n l\u00e0 ng\u01b0\u1eddi d\u00f9ng phi\u00ean b\u1ea3n Office 365 v\u00e0 ch\u1ea5p nh\u1eadn tham gia d\u1ef1 \u00e1n n\u00e0y. N\u00f3i \u0111\u01a1n gi\u1ea3n, c\u1ed9ng \u0111\u1ed3ng Insider s\u1ebd l\u00e0 nh\u1eefng \u201cTester\u201d gi\u00fap c\u00e1c t\u00ednh n\u0103ng ho\u00e0n thi\u1ec7n h\u01a1n tr\u01b0\u1edbc khi \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt ch\u00ednh th\u1ee9c v\u00e0o nh\u1eefng phi\u00ean b\u1ea3n kh\u00e1c. V\u00e0 3 n\u0103m sau, t\u1ea1i Microsoft Ignite 2018, ngo\u00e0i th\u00f4ng b\u00e1o v\u1ec1 s\u1ef1 c\u1ea3i thi\u1ec7n c\u1ee7a engine t\u00ednh to\u00e1n gi\u00fap t\u0103ng t\u1ed1c \u0111\u1ed9 x\u1eed l\u00fd c\u1ee7a c\u00e1c h\u00e0m, ng\u01b0\u1eddi d\u00f9ng \u0111\u00e3 nh\u1eadn \u0111\u01b0\u1ee3c m\u1ed9t t\u00ednh n\u0103ng m\u1edbi m\u00e0 \u0111\u1ebfn t\u1eadn th\u1eddi \u0111i\u1ec3m b\u00e2y gi\u1edd, ng\u01b0\u1eddi ch\u01b0a \u0111\u01b0\u1ee3c d\u00f9ng th\u00ec th\u00e8m kh\u00e1t, c\u00f2n ng\u01b0\u1eddi \u0111ang d\u00f9ng th\u00ec v\u1eabn th\u1ea3o lu\u1eadn kh\u00f4ng ng\u1eebng. N\u00f3 c\u00f3 t\u00ean l\u00e0 <a href=\"https:\/\/techcommunity.microsoft.com\/t5\/excel-blog\/preview-of-dynami\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Dynamic Array<\/strong><\/a> (m\u1ea3ng \u0111\u1ed9ng). \u0110i k\u00e8m v\u1edbi n\u00f3 l\u00e0 <a href=\"https:\/\/www.youtube.com\/watch?v=5nQgqmlcDmQ\" target=\"_blank\" rel=\"noopener noreferrer\">7 h\u00e0m m\u1edbi<\/a> bao g\u1ed3m: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY v\u00e0 SINGLE.<\/div>\n<div>\n<figure class=\"aligncenter\"><img decoding=\"async\" class=\"fr-fic fr-dib fr-draggable\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%200%200'%3E%3C\/svg%3E\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dd20d4d092be11eb97ddd92022686715.png\"><img decoding=\"async\" class=\"fr-fic fr-dib fr-draggable\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dd20d4d092be11eb97ddd92022686715.png\" title=\"dd20d4d092be11eb97ddd92022686715\"><figcaption class=\"image-description\">1 c\u00f4ng th\u1ee9c t\u1ea1i 1 \u00f4 m\u1edf d\u1eef li\u1ec7u ra h\u1eb3n 10 \u00f4? T\u1ea1i sao kh\u00f4ng.<\/figcaption><\/figure>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Vay_thi_Dynamic_Array_la_gi_va_no_da_thay_doi_nguoi_dung_ra_sao\"><\/span>V\u1eady th\u00ec Dynamic Array l\u00e0 g\u00ec v\u00e0 n\u00f3 \u0111\u00e3 thay \u0111\u1ed5i ng\u01b0\u1eddi d\u00f9ng ra sao?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div>Trong kho\u1ea3ng th\u1eddi gian 2 n\u0103m t\u1eeb 2018 t\u1edbi 2020 khi m\u00e0 Microsoft ho\u00e0n t\u1ea5t vi\u1ec7c tri\u1ec3n khai Dynamic Array t\u1edbi c\u00e1c <a href=\"https:\/\/insider.office.com\/en-us\/handbook#Office-Insider-levels\" target=\"_blank\" rel=\"noopener noreferrer\">k\u00eanh<\/a> trong d\u1ef1 \u00e1n Office Insider (Hi\u1ec7n t\u1ea1i Dynamic Array m\u1edbi xu\u1ea5t hi\u1ec7n tr\u00ean Office 365), v\u00f4 v\u00e0n cu\u1ed9c th\u1ea3o lu\u1eadn \u0111\u00e3 n\u1ed5 ra tr\u00ean kh\u1eafp c\u00e1c di\u1ec5n \u0111\u00e0n l\u1edbn nh\u01b0 Microsoft, Reddit c\u0169ng nh\u01b0 tr\u00ean c\u00e1c cu\u1ed9c Techtalk c\u1ee7a nh\u1eefng b\u1eadc th\u1ea7y v\u1ec1 s\u1eed d\u1ee5ng Excel. T\u1ea5t c\u1ea3 \u0111\u1ec1u c\u00f4ng nh\u1eadn r\u1eb1ng, \u0111\u00e2y kh\u00f4ng ch\u1ec9 l\u00e0 b\u01b0\u1edbc ti\u1ebfn m\u1ea1nh m\u1ebd nh\u1ea5t, l\u00e0 c\u1ea3i ti\u1ebfn l\u1edbn nh\u1ea5t c\u1ee7a Excel m\u00e0 c\u00f2n l\u00e0 m\u1ed9t s\u1ef1 ph\u00e1 b\u1ecf gi\u1edbi h\u1ea1n \u00f4 t\u00ednh l\u00e0m thay \u0111\u1ed5i ho\u00e0n to\u00e0n nh\u1eadn th\u1ee9c c\u1ee7a ng\u01b0\u1eddi s\u1eed d\u1ee5ng t\u1eeb tr\u01b0\u1edbc t\u1edbi nay. Bill Jelen \u2013 ch\u1ee7 di\u1ec5n \u0111\u00e0n MrExcel \u0111\u00e3 \u0111\u1ec3 c\u1eadp trong quy\u1ec3n \u201c<strong>Dynamic Arrays: Straight to the Point\u201d<\/strong> c\u1ee7a \u00f4ng r\u1eb1ng v\u1edbi m\u1ea3ng \u0111\u1ed9ng, ng\u01b0\u1eddi ta c\u00f3 th\u1ec3 thu g\u1ecdn c\u1ea3 m\u1ed9t ch\u01b0\u01a1ng s\u00e1ch h\u01b0\u1edbng d\u1eabn t\u00ecm gi\u00e1 tr\u1ecb \u0111\u1ed9c nh\u1ea5t theo c\u00e1ch c\u0169 v\u1ec1 trong ch\u1ec9 m\u1ed9t c\u00e2u.<\/div>\n<blockquote>\n<div>The chapter of Mike Girvin\u2019s <strong>Ctrl+Shift+Enter<\/strong> book on getting unique values just became one \u00a0sentence. I love his book (and I am the publisher of that book), but it is about to become a \u00a0pamphlet with all of these simplications!<\/div>\n<\/blockquote>\n<div>V\u1edbi ng\u01b0\u1eddi d\u00f9ng Excel l\u00e2u n\u0103m, kh\u00e1i ni\u1ec7m m\u1ea3ng (array) kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t kh\u00e1i ni\u1ec7m qu\u00e1 xa l\u1ea1. N\u00f3i n\u00f4m na th\u00ec, n\u1ebfu b\u1ea1n nh\u1eadp m\u1ed9t m\u1ea3ng ={1,2} v\u00e0o \u00f4 A1 trong Excel, th\u00ec ph\u1ea3i \u1ea5n Ctrl + Shift + Enter thay v\u00ec Enter \u0111\u1ec3 k\u1ebft th\u00fac c\u00f4ng th\u1ee9c. V\u00e0 m\u1ed7i \u00f4 (cell) trong Excel ch\u1ec9 th\u1ec3 hi\u1ec7n \u0111\u01b0\u1ee3c 1 gi\u00e1 tr\u1ecb duy nh\u1ea5t, n\u00ean k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean, t\u1ee9c s\u1ed1 1. V\u1eady n\u00ean, \u0111\u1ec3 th\u1ec3 hi\u1ec7n \u0111\u1ea7y \u0111\u1ee7 m\u1ea3ng tr\u00ean, c\u1ea7n ph\u1ea3i b\u00f4i ch\u1ecdn \u00f4 A1 v\u00e0 B1 tr\u01b0\u1edbc, r\u1ed3i sau \u0111\u00f3 m\u1edbi nh\u1eadp m\u1ea3ng v\u00e0o.<\/div>\n<div>\n<figure class=\"aligncenter\"><img decoding=\"async\" class=\"fr-fic fr-dib fr-draggable\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%200%200'%3E%3C\/svg%3E\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/15024ae092c011eb97ddd92022686715.png\"><img decoding=\"async\" class=\"fr-fic fr-dib fr-draggable\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/15024ae092c011eb97ddd92022686715.png\" title=\"15024ae092c011eb97ddd92022686715\"><figcaption class=\"image-description\">X\u1eed l\u00fd array trong Excel kh\u00f4ng ph\u1ea3i chuy\u1ec7n d\u1ec5<\/figcaption><\/figure>\n<\/div>\n<div>\u1ea4y m\u1edbi l\u00e0 n\u00f3i n\u00f4m na, c\u00f2n c\u1ee5 th\u1ec3 th\u00ec m\u1ea3ng trong Excel l\u00e0 m\u1ed9t ph\u1ea1m tr\u00f9 kh\u00e1 r\u1eafc r\u1ed1i v\u00e0 th\u01b0\u1eddng ch\u1ec9 nh\u1eefng ng\u01b0\u1eddi l\u00e0m vi\u1ec7c l\u00e2u n\u0103m m\u1edbi c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o, c\u0169ng nh\u01b0 n\u1ebfu b\u1ea1n c\u00f3 th\u1ec3 \u201cm\u00faa\u201d \u0111\u01b0\u1ee3c m\u1ea3ng trong v\u0103n ph\u00f2ng, th\u00ec b\u1ea1n s\u1ebd l\u00e0 ph\u00f9 th\u1ee7y Excel trong m\u1eaft m\u1ecdi ng\u01b0\u1eddi.<\/div>\n<div>Tr\u1edf l\u1ea1i v\u1edbi Dynamic Array, \u0111\u00e2y d\u01b0\u1eddng nh\u01b0 l\u00e0 m\u1ed9t s\u1ef1 \u201cb\u00ecnh d\u00e2n h\u00f3a\u201d gi\u00fap ai c\u0169ng s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c m\u1ea3ng m\u00e0 kh\u00f4ng c\u1ea7n qu\u00e1 quan t\u00e2m t\u1edbi logic nh\u01b0 tr\u01b0\u1edbc. B\u1ea1n nh\u1eadp m\u1ea3ng ={1,2} v\u00e0o \u00f4 A1, \u1ea5n Enter \u0111\u1ec3 k\u1ebft th\u00fac c\u00f4ng th\u1ee9c. Ta-daa! \u1ede \u00f4 A1 ch\u00fang ta c\u00f3 s\u1ed1 1, v\u00e0 Excel t\u1ef1 m\u1edf r\u1ed9ng m\u1ea3ng sang \u00f4 B1 th\u1ebf l\u00e0 ch\u00fang ta c\u00f3 s\u1ed1 2.<\/div>\n<div>\n<figure class=\"aligncenter\"><img decoding=\"async\" class=\"fr-fic fr-dib fr-draggable\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%200%200'%3E%3C\/svg%3E\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/39a25c5092c011eba843f1dd7af1ef93.png\"><img decoding=\"async\" class=\"fr-fic fr-dib fr-draggable\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/39a25c5092c011eba843f1dd7af1ef93.png\" title=\"39a25c5092c011eba843f1dd7af1ef93\"><figcaption class=\"image-description\">C\u00f9ng c\u00f4ng th\u1ee9c, v\u1edbi Dynamic Array<\/figcaption><\/figure>\n<\/div>\n<div>V\u1eady Dynamic Array l\u00e0 g\u00ec? <a href=\"https:\/\/spiderum.com\/Ablebits.com\" target=\"_blank\" rel=\"noopener noreferrer\">Ablebits.com<\/a> \u0111\u00e3 \u0111\u1ecbnh ngh\u0129a nh\u01b0 sau:<\/div>\n<blockquote>\n<div>Dynamic Arrays are resizable arrays that calculate automatically and return values into multiple cells based on a formula entered in a single cell.<\/div>\n<\/blockquote>\n<div><em>Dynamic Array l\u00e0 m\u1ea3ng co b\u00f3p \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n t\u1ef1 \u0111\u1ed9ng v\u00e0 tr\u1ea3 gi\u00e1 tr\u1ecb v\u1ec1 nhi\u1ec1u \u00f4 d\u1ef1a tr\u00ean c\u00f4ng th\u1ee9c nh\u1eadp v\u00e0o trong m\u1ed9t \u00f4.<\/em><\/div>\n<div><\/div>\n<div>V\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n v\u1ec1 \u1ee9ng d\u1ee5ng c\u1ee7a Dynamic Array c\u00f3 th\u1ec3 k\u1ec3 \u0111\u1ebfn nh\u01b0 sau: Cho m\u1ed9t b\u1ea3ng bao g\u1ed3m c\u1ed9t <strong>\u0110\u01a1n gi\u00e1<\/strong> (A2:A10), <strong>S\u1ed1 l\u01b0\u1ee3ng<\/strong> (B2:B10) v\u00e0 <strong>Th\u00e0nh ti\u1ec1n<\/strong> (C2:C10 \u2013 b\u1ecf tr\u1ed1ng). Y\u00eau c\u1ea7u l\u00e0 t\u00ednh to\u00e1n c\u1ed9t th\u00e0nh ti\u1ec1n c\u1ee7a m\u1ed7i s\u1ea3n ph\u1ea9m.<\/div>\n<div>\n<figure class=\"aligncenter\"><img decoding=\"async\" class=\"fr-fic fr-dib fr-draggable\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%200%200'%3E%3C\/svg%3E\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/d66c4cd092c011ebae4497023313aff9.png\"><img decoding=\"async\" class=\"fr-fic fr-dib fr-draggable\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/d66c4cd092c011ebae4497023313aff9.png\" title=\"d66c4cd092c011ebae4497023313aff9\"><figcaption class=\"image-description\"><\/figcaption><\/figure>\n<\/div>\n<div><strong>V\u1edbi Excel kh\u00f4ng c\u00f3 Dynamic Array:<\/strong><\/div>\n<div>-Nh\u1eadp v\u00e0o \u00f4 C2: =A2*B2, \u1ea5n Enter<\/div>\n<div>-S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Fill \u0111\u1ec3 k\u00e9o xu\u1ed1ng c\u00e1c \u00f4 c\u00f2n l\u1ea1i (C3: =A3*B3, C4: =A4*B4\u2026)<\/div>\n<div>Ho\u1eb7c:<\/div>\n<div>-Ch\u1ecdn t\u1eeb \u00f4 C2 \u0111\u1ebfn C10<\/div>\n<div>-Nh\u1eadp v\u00e0o \u00f4 C2: =A2:A10*B2:B10, \u1ea5n Ctrl + Shift +Enter \u0111\u1ec3 k\u1ebft th\u00fac c\u00f4ng th\u1ee9c<\/div>\n<div><\/div>\n<div><strong>V\u1edbi Dynamic Array:<\/strong><\/div>\n<div>-Nh\u1eadp v\u00e0o \u00f4 C2: =A2:A10*B2:B10, \u1ea5n Enter. Xong.<\/div>\n<div>\n<figure class=\"aligncenter\"><img decoding=\"async\" class=\"fr-fic fr-dib fr-draggable\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%200%200'%3E%3C\/svg%3E\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1aea05a092c111eb97313f9292002fd4.png\"><img decoding=\"async\" class=\"fr-fic fr-dib fr-draggable\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1aea05a092c111eb97313f9292002fd4.png\" title=\"1aea05a092c111eb97313f9292002fd4\"><figcaption class=\"image-description\">\u0110\u1ee1 ph\u1ea3i ngh\u0129<\/figcaption><\/figure>\n<\/div>\n<div>T\u1ea5t nhi\u00ean tr\u00ean \u0111\u00e2y m\u1edbi ch\u1ec9 l\u00e0 m\u1ed9t v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n nh\u1ea5t c\u1ee7a vi\u1ec7c \u1ee9ng d\u1ee5ng Dynamic Array. B\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 t\u1ea1o ra m\u1ed9t b\u1ea3ng, ho\u1eb7c th\u1eadm ch\u00ed l\u00e0 m\u1ed9t b\u00e1o c\u00e1o c\u00f4ng vi\u1ec7c ch\u1ec9 v\u1edbi vi\u1ec7c Enter m\u1ed9t v\u00e0i c\u00f4ng th\u1ee9c ng\u1eafn g\u1ecdn v\u00e0 d\u1ec5 hi\u1ec3u h\u01a1n tr\u01b0\u1edbc \u0111\u00e2y r\u1ea5t nhi\u1ec1u. V\u1edbi c\u00e1 nh\u00e2n ng\u01b0\u1eddi vi\u1ebft, m\u00ecnh \u0111\u00e3 t\u1eebng \u1ee9ng d\u1ee5ng Dynamic Array \u0111\u1ec3 t\u1ea1o ra m\u1ed9t b\u00e1o c\u00e1o tr\u00edch l\u1ecdc d\u1eef li\u1ec7u b\u00e1n h\u00e0ng \u0111\u01a1n gi\u1ea3n nh\u01b0 h\u00ecnh:<\/div>\n<div>\n<figure class=\"aligncenter\"><img decoding=\"async\" class=\"fr-fic fr-dib fr-draggable\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%200%200'%3E%3C\/svg%3E\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3b539c8092c511eba843f1dd7af1ef93.png\"><img decoding=\"async\" class=\"fr-fic fr-dib fr-draggable\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3b539c8092c511eba843f1dd7af1ef93.png\" title=\"3b539c8092c511eba843f1dd7af1ef93\"><figcaption class=\"image-description\">1 c\u00f4ng th\u1ee9c ra 1 b\u1ea3ng<\/figcaption><\/figure>\n<\/div>\n<div>C\u1ee5 th\u1ec3, c\u00e1c b\u1ea1n h\u00e3y th\u1eed t\u1ef1 tr\u1ea3i nghi\u1ec7m xem sao nh\u00e9!<\/div>\n<hr>\n<div>Xem th\u00eam:<\/div>\n<div><\/div>\n<div><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\">Dynamic Array trong Excel<\/a><\/div>\n<div><\/div>\n<div><\/div>\n<div><\/div>\n<div><\/div>\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>T\u1eeb tr\u01b0\u1edbc \u0111\u1ebfn nay ch\u00fang ta \u0111\u00e3 qu\u00e1 quen thu\u1ed9c v\u1edbi Microsoft Excel (Excel) \u2013..<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1861","post","type-post","status-publish","format-standard","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1861","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=1861"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1861\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1861"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}