{"id":9745,"date":"2025-01-02T13:53:22","date_gmt":"2025-01-02T13:53:22","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/tinh-toan-va-su-dung-ham-mang-se-don-gian-hon-voi-excel-trong-nam-2019\/"},"modified":"2025-01-02T13:53:22","modified_gmt":"2025-01-02T13:53:22","slug":"tinh-toan-va-su-dung-ham-mang-se-don-gian-hon-voi-excel-trong-nam-2019","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/tinh-toan-va-su-dung-ham-mang-se-don-gian-hon-voi-excel-trong-nam-2019\/","title":{"rendered":"T\u00ednh to\u00e1n v\u00e0 s\u1eed d\u1ee5ng h\u00e0m m\u1ea3ng s\u1ebd \u0111\u01a1n gi\u1ea3n h\u01a1n v\u1edbi Excel trong n\u0103m 2019"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p style=\"text-align: justify\">T\u1ea1i th\u1eddi \u0111i\u1ec3m vi\u1ebft b\u00e0i, n\u1ebfu b\u1ea1n \u1edf trong ch\u01b0\u01a1ng tr\u00ecnh Office Insider c\u1ee7a Microsoft th\u00ec b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 nghi\u1ec7m 1 trong nh\u1eefng thay \u0111\u1ed5i l\u1edbn nh\u1ea5t li\u00ean quan t\u1edbi engine t\u00ednh to\u00e1n c\u1ee7a Excel. V\u1edbi engine t\u00ednh to\u00e1n n\u00e0y, c\u00f4ng th\u1ee9c hay h\u00e0m Excel vi\u1ebft v\u00e0o 1 \u00f4 c\u00f3 th\u1ec3 ghi d\u1eef li\u1ec7u sang c\u1ea3 nh\u1eefng \u00f4 kh\u00e1c, trong ti\u1ebfng anh, lo\u1ea1i h\u00e0m n\u00e0y \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 Excel Dynamic Array Functions, d\u1ecbch ra ti\u1ebfng vi\u1ec7t l\u00e0 <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=\"noopener noreferrer\">h\u00e0m m\u1ea3ng \u0111\u1ed9ng<\/a>.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu kh\u00f4ng c\u00f3 h\u00e0m m\u1ea3ng \u0111\u1ed9ng, th\u00ec trong v\u00ed d\u1ee5 sau \u0111\u00e2y, b\u1ea1n s\u1ebd ph\u1ea3i \u0111i\u1ec1n v\u00e0o m\u1ed7i \u00f4 trong v\u00f9ng <strong>E10:J22<\/strong> 1 c\u00f4ng th\u1ee9c, v\u00e0 nh\u01b0 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u0111\u00e3 g\u1eb7p ph\u1ea3i, n\u1ebfu file Excel c\u00f3 qu\u00e1 nhi\u1ec1u c\u00f4ng th\u1ee9c n\u00f3 s\u1ebd tr\u1edf n\u00ean c\u1ed3ng k\u1ec1nh v\u00e0 r\u1ea5t n\u1eb7ng n\u1ec1 \u0111\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng. D\u00f9 b\u1ea1n c\u00f3 t\u00ecm m\u1ecdi <a href=\"http:\/\/blog.ezworkapp.com\/file-excel-bi-nang-lam-sao-de-giam-dung-luong.html\" target=\"_blank\" rel=\"noopener noreferrer\">c\u00e1ch \u0111\u1ec3 gi\u1ea3m dung l\u01b0\u1ee3ng file Excel<\/a> \u0111i n\u1eefa, c\u00f3 th\u1ec3 trong 1 v\u00e0i tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n v\u1eabn kh\u00f4ng nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 \u00fd mu\u1ed1n.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/ham-mang-dong-excel-365-01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23641\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-mang-dong-excel-365-01.png\" alt=\"ham-mang-dong-excel-365-01\" width=\"1775\" height=\"732\" title=\"ham-mang-dong-excel-365-01\"><\/a><\/p>\n<p style=\"text-align: justify\">V\u1edbi <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=\"noopener noreferrer\">h\u00e0m m\u1ea3ng \u0111\u1ed9ng trong Excel<\/a>\u00a0th\u00ec b\u1ea1n s\u1ebd kh\u00f4ng c\u1ea7n \u0111i\u1ec1n r\u1ea5t nhi\u1ec1u c\u00f4ng th\u1ee9c cho v\u00f9ng <strong>E10:J22<\/strong> n\u1eefa, m\u00e0 ch\u1ec9 c\u1ea7n 1 c\u00f4ng th\u1ee9c \/ h\u00e0m m\u1ea3ng \u0111\u1ed9ng duy nh\u1ea5t t\u1ea1i \u00f4 <strong>E10\u00a0<\/strong>m\u00e0 th\u00f4i, v\u00e0 c\u00f4ng th\u1ee9c n\u00e0y k\u1ebft h\u1ee3p v\u1edbi engine t\u00ednh to\u00e1n m\u1edbi c\u1ee7a Excel 365 s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng cho to\u00e0n b\u1ed9 c\u00e1c \u00f4 c\u00f2n l\u1ea1i trong v\u00f9ng <strong>E10:J22<\/strong><\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/ham-mang-dong-excel-365-02.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23642\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-mang-dong-excel-365-02.png\" alt=\"ham-mang-dong-excel-365-02\" width=\"1648\" height=\"678\" title=\"ham-mang-dong-excel-365-02\"><\/a><\/p>\n<p style=\"text-align: justify\">Video minh h\u1ecda:<\/p>\n<p style=\"text-align: justify\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/FzdRvPyIBFw\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p style=\"text-align: justify\">Theo k\u1ebf ho\u1ea1ch, Microsoft s\u1ebd ch\u00ednh th\u1ee9c \u0111\u01b0a t\u00ednh n\u0103ng n\u00e0y t\u1edbi ng\u01b0\u1eddi d\u00f9ng Excel 365 v\u00e0o \u0111\u1ea7u n\u0103m 2019, n\u1ebfu b\u1ea1n mu\u1ed1n trang b\u1ecb cho m\u00ecnh nh\u1eefng ki\u1ebfn th\u1ee9c m\u1edbi nh\u1ea5t ngay b\u00e2y gi\u1edd, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o <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=\"noopener noreferrer\">series h\u01b0\u1edbng d\u1eabn h\u00e0m m\u1ea3ng \u0111\u1ed9ng c\u1ee7a H\u1ecdc Excel Online<\/a>. Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-1.gif\" title=\"vba101_92019-nho-1\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-85.gif\" title=\"ex101_92019-nho-85\"><br \/>\n<\/a>\n<\/div>\n<\/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":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-1.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9746,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9745","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\/9745","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=9745"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9745\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9746"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9745"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}