{"id":893,"date":"2024-12-02T03:00:45","date_gmt":"2024-12-02T03:00:45","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tong-hop-cac-ham-mang-va-van-ban-moi-duoc-excel-ra-mat\/"},"modified":"2024-12-02T03:00:45","modified_gmt":"2024-12-02T03:00:45","slug":"tong-hop-cac-ham-mang-va-van-ban-moi-duoc-excel-ra-mat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tong-hop-cac-ham-mang-va-van-ban-moi-duoc-excel-ra-mat\/","title":{"rendered":"T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m m\u1ea3ng v\u00e0 v\u0103n b\u1ea3n m\u1edbi \u0111\u01b0\u1ee3c Excel ra m\u1eaft"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>V\u00e0o ng\u00e0y 16 th\u00e1ng 3 v\u1eeba qua, Excel \u0111\u00e3 \u0111\u01b0\u1ee3c b\u1ed5 sung th\u00eam 14 h\u00e0m m\u1edbi li\u00ean quan t\u1edbi m\u1ea3ng v\u00e0 x\u1eed l\u00fd v\u0103n b\u1ea3n. H\u1ecdc Excel Online s\u1ebd t\u00f3m t\u1eaft th\u00f4ng tin c\u01a1 b\u1ea3n v\u1ec1 c\u00e1c h\u00e0m m\u1ea3ng v\u00e0 v\u0103n b\u1ea3n m\u1edbi k\u1ec3 tr\u00ean. <em>L\u01b0\u1ee3c d\u1ecbch t\u1eeb trang c\u1ed9ng \u0111\u1ed3ng Microsoft.<\/em><\/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-674d22dc273d0\" 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\/tong-hop-ham-mang-va-van-ban-moi-ra-mat.html#Danh_sach_cac_ham_mang_va_van_ban_moi_thang_32022\" title=\"Danh s\u00e1ch c\u00e1c h\u00e0m m\u1ea3ng v\u00e0 v\u0103n b\u1ea3n m\u1edbi (th\u00e1ng 3\/2022)\">Danh s\u00e1ch c\u00e1c h\u00e0m m\u1ea3ng v\u00e0 v\u0103n b\u1ea3n m\u1edbi (th\u00e1ng 3\/2022)<\/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\/tong-hop-ham-mang-va-van-ban-moi-ra-mat.html#Nhom_ham_xu_ly_chuoi_ky_tu\" title=\"Nh\u00f3m h\u00e0m x\u1eed l\u00fd chu\u1ed7i k\u00fd t\u1ef1\">Nh\u00f3m h\u00e0m x\u1eed l\u00fd chu\u1ed7i k\u00fd 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\/tong-hop-ham-mang-va-van-ban-moi-ra-mat.html#Nhom_ham_xu_ly_mang\" title=\"Nh\u00f3m h\u00e0m x\u1eed l\u00fd m\u1ea3ng\">Nh\u00f3m h\u00e0m x\u1eed l\u00fd m\u1ea3ng<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Danh_sach_cac_ham_mang_va_van_ban_moi_thang_32022\"><\/span>Danh s\u00e1ch c\u00e1c h\u00e0m m\u1ea3ng v\u00e0 v\u0103n b\u1ea3n m\u1edbi (th\u00e1ng 3\/2022)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong \u0111\u1ee3t b\u1ed5 sung n\u00e0y, c\u00e1c h\u00e0m m\u1edbi t\u1eadp trung v\u00e0o x\u1eed l\u00fd v\u0103n b\u1ea3n\/chu\u1ed7i k\u00ed t\u1ef1 c\u0169ng nh\u01b0 x\u1eed l\u00fd m\u1ea3ng. \u0110i\u1ec1u n\u00e0y khi\u1ebfn ta li\u00ean t\u01b0\u1edfng t\u1edbi vi\u1ec7c \u201cc\u1ea1nh tranh tr\u1ef1c ti\u1ebfp\u201d v\u1edbi Google Sheets \u2013 khi m\u00e0 Google Sheets \u0111\u00e3 l\u00e0m kh\u00e1 t\u1ed1t vi\u1ec7c \u0111\u01b0a v\u00e0 tr\u1ef1c quan h\u00f3a m\u1ea3ng v\u00e0o trong trang t\u00ednh th\u00ec Excel ch\u1ec9 m\u1edbi b\u1eaft \u0111\u1ea7u khi\u1ebfn cho m\u1ea3ng tr\u1edf n\u00ean th\u00e2n thi\u1ec7n h\u01a1n nh\u1eefng n\u0103m g\u1ea7n \u0111\u00e2y v\u1edbi Dynamic Array, v\u00e0 t\u00ednh n\u0103ng n\u00e0y hi\u1ec7n ch\u1ec9 c\u00f3 tr\u00ean Office 365.<\/p>\n<p>Danh s\u00e1ch c\u00e1c h\u00e0m m\u1edbi chi ti\u1ebft:<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Nhom_ham_xu_ly_chuoi_ky_tu\"><\/span>Nh\u00f3m h\u00e0m x\u1eed l\u00fd chu\u1ed7i k\u00fd t\u1ef1<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>3 h\u00e0m m\u1edbi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o \u0111\u1ee3t n\u00e0y nh\u1eb1m 1 m\u1ee5c \u0111\u00edch chung, \u0111\u00f3 l\u00e0 t\u00e1ch chu\u1ed7i k\u00ed t\u1ef1. Tr\u01b0\u1edbc \u0111\u00e2y, vi\u1ec7c x\u1eed l\u00fd chu\u1ed7i k\u00fd t\u1ef1 trong Excel th\u01b0\u1eddng kh\u00e1 kh\u00f3 kh\u0103n. Tr\u01b0\u1edbc \u0111\u00e2y, \u0111\u1ec3 chia nh\u1ecf, t\u00e1ch m\u1ed9t chu\u1ed7i k\u00ed t\u1ef1 th\u00e0nh nhi\u1ec1u chu\u1ed7i con ta th\u01b0\u1eddng ph\u1ea3i k\u1ebft h\u1ee3p nhi\u1ec1u h\u00e0m nh\u01b0 SEARCH, FIND, LEFT, RIGHT, MID, SUBSTITUTE\u2026 nh\u01b0ng \u0111\u1ec3 v\u1eadn d\u1ee5ng \u0111\u01b0\u1ee3c nh\u1eefng h\u00e0m n\u00e0y l\u00e0 m\u1ed9t c\u00f4ng vi\u1ec7c kh\u00f3 kh\u0103n. Gi\u1edd \u0111\u00e2y, m\u1ecdi th\u1ee9 \u0111\u00e3 tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n v\u1edbi:<\/p>\n<ul>\n<li>TEXTBEFORE \u2013 Tr\u1ea3 v\u1ec1 chu\u1ed7i k\u00ed t\u1ef1 \u0111\u1eb1ng tr\u01b0\u1edbc d\u1ea5u ph\u00e2n t\u00e1ch<\/li>\n<li>TEXTAFTER \u2013 Tr\u1ea3 v\u1ec1 chu\u1ed7i k\u00ed t\u1ef1 \u0111\u1eb1ng sau d\u1ea5u ph\u00e2n t\u00e1ch<\/li>\n<li>TEXTSPLIT \u2013 T\u00e1ch chu\u1ed7i v\u1edbi c\u00e1c d\u1ea5u ph\u00e2n t\u00e1ch<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/techcommunity.microsoft.com\/t5\/image\/serverpage\/image-id\/356029i8F1E90237F9993B4\/image-size\/large?v=v2&amp;px=999\" alt=\"h\u00e0m m\u1ea3ng v\u00e0 v\u0103n b\u1ea3n\" width=\"556\" height=\"202\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Nhom_ham_xu_ly_mang\"><\/span>Nh\u00f3m h\u00e0m x\u1eed l\u00fd m\u1ea3ng<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>11 h\u00e0m m\u1edbi c\u00f2n l\u1ea1i khi\u1ebfn vi\u1ec7c x\u1eed l\u00fd m\u1ea3ng trong Excel tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n r\u1ea5t nhi\u1ec1u. Gi\u1edd \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 t\u1eeb m\u1ed9t c\u00f4ng th\u1ee9c hi\u1ec3n th\u1ecb ra c\u1ea3 m\u1ed9t m\u1ea3ng d\u1eef li\u1ec7u kh\u1ed5ng l\u1ed3.<\/p>\n<p>\u0110\u1ec3 g\u1ed9p 2 m\u1ea3ng l\u1ea1i v\u1edbi nhau, ch\u00fang ta c\u00f3 VSTACK v\u00e0 HSTACK:<\/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-54.gif\" title=\"ex101_92019-nho-54\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>VSTACK \u2013 x\u1ebfp c\u00e1c m\u1ea3ng theo chi\u1ec1u d\u1ecdc<\/li>\n<li>HSTACK \u2013 x\u1ebfp c\u00e1c m\u1ea3ng theo chi\u1ec1u ngang<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/techcommunity.microsoft.com\/t5\/image\/serverpage\/image-id\/356030iA12199D1E662C9A4\/image-size\/large?v=v2&amp;px=999\" alt=\"Vstack hstack\" width=\"448\" height=\"246\"><\/p>\n<p>\u0110\u1ec3 \u201c\u0111\u1ecbnh h\u00ecnh\u201d l\u1ea1i m\u1ea3ng d\u1eef li\u1ec7u, ta c\u00f3 4 h\u00e0m:<\/p>\n<ul>\n<li>TOROW \u2013 chuy\u1ec3n 1 m\u1ea3ng th\u00e0nh 1 h\u00e0ng duy nh\u1ea5t<\/li>\n<li>TOCOL \u2013 chuy\u1ec3n 1 m\u1ea3ng th\u00e0nh 1 c\u1ed9t duy nh\u1ea5t<\/li>\n<li>WRAPROWS \u2013 chuy\u1ec3n 1 vector th\u00e0nh 1 m\u1ea3ng 2D theo h\u00e0ng<\/li>\n<li>WRAPCOLS \u2013 chuy\u1ec3n 1 vector th\u00e0nh 1 m\u1ea3ng 2D theo c\u1ed9t<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/techcommunity.microsoft.com\/t5\/image\/serverpage\/image-id\/356032iAE5BCE0E5B439DDF\/image-size\/large?v=v2&amp;px=999\" alt=\"shaping array\" width=\"442\" height=\"306\"><\/p>\n<p>\u0110\u1ec3 thay \u0111\u1ed5i k\u00edch c\u1ee1 m\u1ea3ng, 5 h\u00e0m m\u1edbi s\u1ebd gi\u00fap b\u1ea1n:<\/p>\n<ul>\n<li>TAKE \u2013 Tr\u1ea3 v\u1ec1 h\u00e0ng ho\u1eb7c c\u1ed9t li\u1ec1n k\u1ec1 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh t\u1eeb \u0111\u1ea7u ho\u1eb7c cu\u1ed1i c\u1ee7a m\u1ed9t m\u1ea3ng<\/li>\n<li>DROP \u2013 Lo\u1ea1i tr\u1eeb h\u00e0ng ho\u1eb7c c\u1ed9t li\u1ec1n k\u1ec1 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh t\u1eeb \u0111\u1ea7u ho\u1eb7c cu\u1ed1i c\u1ee7a m\u1ed9t m\u1ea3ng<\/li>\n<li>CHOOSEROWS \u2013 Tr\u1ea3 v\u1ec1 m\u1ed9t m\u1ea3ng ch\u1ec9 ch\u1ee9a c\u00e1c h\u00e0ng \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh t\u1eeb m\u1ea3ng kh\u00e1c<\/li>\n<li>CHOOSECOLS \u2013 Tr\u1ea3 v\u1ec1 m\u1ed9t m\u1ea3ng ch\u1ec9 ch\u1ee9a c\u00e1c c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh t\u1eeb m\u1ea3ng kh\u00e1c<\/li>\n<li>EXPAND \u2013 M\u1edf r\u1ed9ng ho\u1eb7c \u0111i\u1ec1n th\u00eam m\u1ed9t m\u1ea3ng t\u1edbi k\u00edch th\u01b0\u1edbc h\u00e0ng v\u00e0 c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/techcommunity.microsoft.com\/t5\/image\/serverpage\/image-id\/356033iE26DBE476DCCC5E4\/image-size\/large?v=v2&amp;px=999\" alt=\"resizing array\" width=\"430\" height=\"288\"><\/p>\n<p>Hi\u1ec7n t\u1ea1i, c\u00e1c h\u00e0m tr\u00ean v\u1eabn \u0111ang trong giai \u0111o\u1ea1n th\u1eed nghi\u1ec7m v\u00e0 ch\u1ec9 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel Beta Channel, Version 2203 (Build 15104.20004) tr\u1edf l\u00ean trong Windows, ho\u1eb7c Version 16.60 (Build 22030400) trong Mac.<\/p>\n<hr>\n<p>Xem th\u00eam c\u00e1c h\u00e0m m\u1edbi kh\u00e1c c\u1ee7a Excel:<\/p>\n<p><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\"><strong>H\u00e0m m\u1ea3ng \u0111\u1ed9ng trong Excel<\/strong><\/a><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tu-dong-sap-xep-du-lieu-bang-ham-sort.html\">T\u1ef1 \u0111\u1ed9ng s\u1eafp x\u1ebfp d\u1eef li\u1ec7u v\u1edbi h\u00e0m SORT<\/a><\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/loc-du-lieu-theo-dieu-kien-duy-nhat-ket-hop-ham-unique-filter.html\"><strong>S\u1eed d\u1ee5ng h\u00e0m FILTER k\u1ebft h\u1ee3p UNIQUE \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u<\/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-54.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":894,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-893","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\/893","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=893"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/893\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/894"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=893"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=893"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=893"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}