{"id":873,"date":"2024-12-02T02:58:55","date_gmt":"2024-12-02T02:58:55","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-gop-nhieu-mang-vung-du-lieu-voi-ham-vstack-va-hstack-trong-excel\/"},"modified":"2024-12-02T02:58:55","modified_gmt":"2024-12-02T02:58:55","slug":"cach-gop-nhieu-mang-vung-du-lieu-voi-ham-vstack-va-hstack-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-gop-nhieu-mang-vung-du-lieu-voi-ham-vstack-va-hstack-trong-excel\/","title":{"rendered":"C\u00e1ch g\u1ed9p nhi\u1ec1u m\u1ea3ng, v\u00f9ng d\u1eef li\u1ec7u v\u1edbi h\u00e0m VSTACK v\u00e0 HSTACK trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch g\u1ed9p nhi\u1ec1u m\u1ea3ng v\u00e0 v\u00f9ng d\u1eef li\u1ec7u theo chi\u1ec1u d\u1ecdc ho\u1eb7c chi\u1ec1u ngang s\u1eed d\u1ee5ng h\u00e0m VSTACK v\u00e0 HSTACK trong Excel 365.<\/p>\n<p>Vi\u1ec7c g\u1ed9p d\u1eef li\u1ec7u v\u00e0 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u t\u1eeb l\u00e2u v\u1eabn l\u00e0 m\u1ed9t c\u00f4ng vi\u1ec7c l\u00e0m m\u1ea5t nhi\u1ec1u th\u1eddi gian c\u1ee7a ch\u00fang ta, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y b\u1eb1ng tay, c\u1eaft, d\u00e1n d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng ho\u1eb7c <a href=\"http:\/\/blog.ezworkapp.com\/vba-la-gi-toi-da-su-dung-vba-de-lam-nhung-cong-viec-gi.html\" target=\"_blank\" rel=\"noopener\">s\u1eed d\u1ee5ng VBA Macro<\/a> \u0111\u1ec3 ho\u00e0n th\u00e0nh c\u00f4ng vi\u1ec7c n\u00e0y t\u1ef1 \u0111\u1ed9ng. Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o ch\u00fang ta c\u0169ng c\u00f3 th\u1eddi gian \u0111\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y b\u1eb1ng tay, ho\u1eb7c c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng VBA. Hai h\u00e0m m\u1edbi \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u trong phi\u00ean b\u1ea3n Excel 365 l\u00e0 VSTACK v\u00e0 HSTACK s\u1ebd gi\u00fap c\u00e1c b\u1ea1n g\u1ed9p d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.<\/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-674d226e6ad61\" 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\/cach-gop-nhieu-mang-vung-du-lieu-voi-ham-vstack-va-hstack-trong-excel.html#Ham_VSTACK_trong_Excel\" title=\"H\u00e0m VSTACK trong Excel\">H\u00e0m VSTACK trong Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-nhieu-mang-vung-du-lieu-voi-ham-vstack-va-hstack-trong-excel.html#Cu_phap_cua_ham_VSTACK_trong_Excel\" title=\"C\u00fa ph\u00e1p c\u1ee7a h\u00e0m VSTACK trong Excel\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m VSTACK trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-nhieu-mang-vung-du-lieu-voi-ham-vstack-va-hstack-trong-excel.html#Ket_qua_cua_ham_VSTACK_trong_Excel\" title=\"K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m VSTACK trong Excel\">K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m VSTACK trong Excel<\/a><\/li>\n<\/ul>\n<\/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\/cach-gop-nhieu-mang-vung-du-lieu-voi-ham-vstack-va-hstack-trong-excel.html#Ham_HSTACK_trong_Excel\" title=\"H\u00e0m HSTACK trong Excel\">H\u00e0m HSTACK trong Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-nhieu-mang-vung-du-lieu-voi-ham-vstack-va-hstack-trong-excel.html#Cu_phap_cua_ham_HSTACK_trong_Excel\" title=\"C\u00fa ph\u00e1p c\u1ee7a h\u00e0m HSTACK trong Excel\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m HSTACK trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-nhieu-mang-vung-du-lieu-voi-ham-vstack-va-hstack-trong-excel.html#Ket_qua_cua_ham_HSTACK_trong_Excel\" title=\"K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m HSTACK trong Excel\">K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m HSTACK trong Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-nhieu-mang-vung-du-lieu-voi-ham-vstack-va-hstack-trong-excel.html#Phien_ban_Excel_nao_co_the_su_dung_ham_VSTACK_va_HSTACK\" title=\"Phi\u00ean b\u1ea3n Excel n\u00e0o c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VSTACK v\u00e0 HSTACK\">Phi\u00ean b\u1ea3n Excel n\u00e0o c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VSTACK v\u00e0 HSTACK<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-nhieu-mang-vung-du-lieu-voi-ham-vstack-va-hstack-trong-excel.html#Mot_so_luu_y_khi_dung_ham_VSTACK_va_HSTACK\" title=\"M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi d\u00f9ng h\u00e0m VSTACK v\u00e0 HSTACK\">M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi d\u00f9ng h\u00e0m VSTACK v\u00e0 HSTACK<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-nhieu-mang-vung-du-lieu-voi-ham-vstack-va-hstack-trong-excel.html#Mot_so_vi_du_ap_dung_ham_VSTACK_va_HSTACK\" title=\"M\u1ed9t s\u1ed1 v\u00ed d\u1ee5 \u00e1p d\u1ee5ng h\u00e0m VSTACK v\u00e0 HSTACK\">M\u1ed9t s\u1ed1 v\u00ed d\u1ee5 \u00e1p d\u1ee5ng h\u00e0m VSTACK v\u00e0 HSTACK<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-nhieu-mang-vung-du-lieu-voi-ham-vstack-va-hstack-trong-excel.html#Gop_vung_du_lieu_va_mang_tinh_ngay_trong_cong_thuc_VSTACK\" title=\"G\u1ed9p v\u00f9ng d\u1eef li\u1ec7u v\u00e0 m\u1ea3ng t\u0129nh ngay trong c\u00f4ng th\u1ee9c VSTACK\">G\u1ed9p v\u00f9ng d\u1eef li\u1ec7u v\u00e0 m\u1ea3ng t\u0129nh ngay trong c\u00f4ng th\u1ee9c VSTACK<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-nhieu-mang-vung-du-lieu-voi-ham-vstack-va-hstack-trong-excel.html#Gop_nhieu_bang_trong_Excel_voi_VSTACK_hoac_HSTACK\" title=\"G\u1ed9p nhi\u1ec1u b\u1ea3ng trong Excel v\u1edbi VSTACK ho\u1eb7c HSTACK\">G\u1ed9p nhi\u1ec1u b\u1ea3ng trong Excel v\u1edbi VSTACK ho\u1eb7c HSTACK<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-nhieu-mang-vung-du-lieu-voi-ham-vstack-va-hstack-trong-excel.html#Gop_mang_du_lieu_la_ket_qua_cua_ham_khac\" title=\"G\u1ed9p m\u1ea3ng d\u1eef li\u1ec7u l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m kh\u00e1c\">G\u1ed9p m\u1ea3ng d\u1eef li\u1ec7u l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m kh\u00e1c<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ham_VSTACK_trong_Excel\"><\/span>H\u00e0m VSTACK trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m VSTACK trong Excel s\u1ebd g\u1ed9p nhi\u1ec1u v\u00f9ng d\u1eef li\u1ec7u theo chi\u1ec1u d\u1ecdc. H\u00ecnh minh ho\u1ea1 sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u ngay l\u1eadp t\u1ee9c v\u1ec1 t\u00e1c d\u1ee5ng c\u1ee7a h\u00e0m VSTACK n\u00e0y:<\/p>\n<figure class=\"wp-block-image alignnone size-full wp-image-39389\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"405\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-vstack-trong-excel-1.png\" alt=\"Minh ho\u1ea1 h\u00e0m vstack trong Excel\" class=\"wp-image-39389\" title=\"ham-vstack-trong-excel-1\"><figcaption class=\"wp-element-caption\">Minh ho\u1ea1 h\u00e0m vstack trong Excel<\/figcaption><\/figure>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cu_phap_cua_ham_VSTACK_trong_Excel\"><\/span>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m VSTACK trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<pre class=\"wp-block-code\"><code>=VSTACK(m\u1ea3ng_1, [m\u1ea3ng_2], ...)<\/code><\/pre>\n<p>Trong c\u00fa ph\u00e1p tr\u00ean: <code>m\u1ea3ng_1<\/code>\u00a0l\u00e0 tham chi\u1ebfu t\u1edbi v\u00f9ng d\u1eef li\u1ec7u, ho\u1eb7c l\u00e0 m\u1ed9t m\u1ea3ng k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c kh\u00e1c. <code>m\u1ea3ng_1<\/code>\u00a0l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3, c\u00e1c m\u1ea3ng sau \u0111\u00f3 c\u00f3 th\u1ec3 c\u00f3 ho\u1eb7c kh\u00f4ng c\u00f3 \u0111\u1ec1u \u0111\u01b0\u1ee3c.<\/p>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ket_qua_cua_ham_VSTACK_trong_Excel\"><\/span>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m VSTACK trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m VSTACK s\u1ebd l\u00e0 m\u1ed9t m\u1ea3ng:<\/p>\n<ul>\n<li>c\u00f3 s\u1ed1 c\u1ed9t b\u1eb1ng v\u1edbi s\u1ed1 c\u1ed9t c\u1ee7a m\u1ea3ng th\u00e0nh ph\u1ea7n c\u00f3 s\u1ed1 c\u1ed9t l\u1edbn nh\u1ea5t<\/li>\n<li>c\u00f3 s\u1ed1 h\u00e0ng b\u1eb1ng t\u1ed5ng s\u1ed1 h\u00e0ng c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c m\u1ea3ng th\u00e0nh ph\u1ea7n<\/li>\n<li>n\u1ebfu s\u1ed1 c\u1ed9t c\u1ee7a c\u00e1c m\u1ea3ng th\u00e0nh ph\u1ea7n kh\u00f4ng gi\u1ed1ng nhau, m\u1ea3ng k\u1ebft qu\u1ea3 s\u1ebd c\u00f3 gi\u00e1 tr\u1ecb <code>#N\/A<\/code><\/li>\n<\/ul>\n<figure class=\"wp-block-image alignnone size-full wp-image-39390\"><img loading=\"lazy\" decoding=\"async\" width=\"893\" height=\"272\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-cua-ham-vstack-trong-excel-1.png\" alt=\"K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m vstack trong Excel\" class=\"wp-image-39390\" title=\"ket-qua-cua-ham-vstack-trong-excel-1\"><figcaption class=\"wp-element-caption\">K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m vstack trong Excel<\/figcaption><\/figure>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ham_HSTACK_trong_Excel\"><\/span>H\u00e0m HSTACK trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m HSTACK trong Excel 365 s\u1ebd \u0111\u1eb7t c\u00e1c v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn b\u00ean c\u1ea1nh nhau (sang b\u00ean ph\u1ea3i)<\/p>\n<figure class=\"wp-block-image alignnone size-full wp-image-39391\"><img loading=\"lazy\" decoding=\"async\" width=\"998\" height=\"608\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-hstack-trong-excel-1.png\" alt=\"H\u00e0m HSTACK trong Excel\" class=\"wp-image-39391\" title=\"ham-hstack-trong-excel-1\"><figcaption class=\"wp-element-caption\">H\u00e0m HSTACK trong Excel<\/figcaption><\/figure>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cu_phap_cua_ham_HSTACK_trong_Excel\"><\/span>C\u00fa ph\u00e1p c\u1ee7a h\u00e0m HSTACK trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<pre class=\"wp-block-code\"><code>=HSTACK(m\u1ea3ng_1, [m\u1ea3ng_2], ...)<\/code><\/pre>\n<p>Trong c\u00fa ph\u00e1p tr\u00ean: <code>m\u1ea3ng_1<\/code>\u00a0l\u00e0 tham chi\u1ebfu t\u1edbi v\u00f9ng d\u1eef li\u1ec7u, ho\u1eb7c l\u00e0 m\u1ed9t m\u1ea3ng k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c kh\u00e1c. <code>m\u1ea3ng_1<\/code>\u00a0l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3, c\u00e1c m\u1ea3ng sau \u0111\u00f3 c\u00f3 th\u1ec3 c\u00f3 ho\u1eb7c kh\u00f4ng c\u00f3 \u0111\u1ec1u \u0111\u01b0\u1ee3c.<\/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-52.gif\" title=\"ex101_92019-nho-52\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ket_qua_cua_ham_HSTACK_trong_Excel\"><\/span>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m HSTACK trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m HSTACK s\u1ebd l\u00e0 m\u1ed9t m\u1ea3ng:<\/p>\n<ul>\n<li>c\u00f3 s\u1ed1 h\u00e0ng b\u1eb1ng v\u1edbi s\u1ed1 h\u00e0ng c\u1ee7a m\u1ea3ng th\u00e0nh ph\u1ea7n c\u00f3 s\u1ed1 h\u00e0ng l\u1edbn nh\u1ea5t (m\u1ea3ng th\u00e0nh ph\u1ea7n \u201ccao nh\u1ea5t\u201d)<\/li>\n<li>c\u00f3 s\u1ed1 c\u1ed9t b\u1eb1ng t\u1ed5ng s\u1ed1 c\u1ed9t c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c m\u1ea3ng th\u00e0nh ph\u1ea7n<\/li>\n<li>n\u1ebfu s\u1ed1 h\u00e0ng c\u1ee7a c\u00e1c m\u1ea3ng th\u00e0nh ph\u1ea7n kh\u00f4ng gi\u1ed1ng nhau, m\u1ea3ng k\u1ebft qu\u1ea3 s\u1ebd c\u00f3 gi\u00e1 tr\u1ecb <code>#N\/A<\/code><\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Phien_ban_Excel_nao_co_the_su_dung_ham_VSTACK_va_HSTACK\"><\/span>Phi\u00ean b\u1ea3n Excel n\u00e0o c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m VSTACK v\u00e0 HSTACK<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Hi\u1ec7n t\u1ea1i, h\u00e0m VSTACK v\u00e0 HSTACK ch\u1ec9 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c tr\u00ean phi\u00ean b\u1ea3n Excel 365<\/p>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Mot_so_luu_y_khi_dung_ham_VSTACK_va_HSTACK\"><\/span>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi d\u00f9ng h\u00e0m VSTACK v\u00e0 HSTACK<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 \u00e1p d\u1ee5ng h\u00e0m VSTACK v\u00e0 HSTACK trong Excel m\u1ed9t c\u00e1ch th\u00e0nh c\u00f4ng, b\u1ea1n h\u00e3y ghi nh\u1edb m\u1ed9t s\u1ed1 l\u01b0u \u00fd sau \u0111\u00e2y:<\/p>\n<ul>\n<li>Tham s\u1ed1 c\u1ee7a h\u00e0m c\u00f3 th\u1ec3 l\u00e0 v\u00f9ng tr\u00ean b\u1ea3ng t\u00ednh Excel, b\u1ea3ng, v\u00f9ng \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean, m\u1ea3ng d\u1eef li\u1ec7u t\u0129nh ho\u1eb7c m\u1ea3ng d\u1eef li\u1ec7u \u0111\u1ed9ng \u0111\u01b0\u1ee3c t\u1ea1o ra t\u1eeb k\u1ebft qu\u1ea3 c\u1ee7a c\u00e1c h\u00e0m kh\u00e1c.<\/li>\n<li>H\u00e0m c\u1ea7n \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o 1 \u00f4 duy nh\u1ea5t, k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m s\u1ebd t\u1ef1 \u0111\u1ed9ng m\u1edf r\u1ed9ng ra t\u1edbi v\u00f9ng c\u1ea7n thi\u1ebft v\u1edbi k\u00edch th\u01b0\u1edbc c\u1ea7n thi\u1ebft<\/li>\n<li>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m ho\u00e0n to\u00e0n \u201c\u0111\u1ed9ng\u201d, ngh\u0129a l\u00e0, khi b\u1ea1n thay \u0111\u1ed5i c\u00e1c m\u1ea3ng th\u00e0nh ph\u1ea7n, m\u1ea3ng k\u1ebft qu\u1ea3 c\u0169ng t\u1ef1 \u0111\u1ed9ng \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt ngay l\u1eadp t\u1ee9c.<\/li>\n<li>\u0110\u1ec3 d\u1eef li\u1ec7u k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt m\u00e0 kh\u00f4ng c\u1ea7n ch\u1ec9nh l\u1ea1i c\u00f4ng th\u1ee9c, b\u1ea1n h\u00e3y \u0111\u1ecbnh d\u1ea1ng m\u1ea3ng th\u00e0nh ph\u1ea7n \u1edf d\u1ea1ng b\u1ea3ng (T\u00ednh n\u0103ng Format As Table)<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Mot_so_vi_du_ap_dung_ham_VSTACK_va_HSTACK\"><\/span>M\u1ed9t s\u1ed1 v\u00ed d\u1ee5 \u00e1p d\u1ee5ng h\u00e0m VSTACK v\u00e0 HSTACK<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Gop_vung_du_lieu_va_mang_tinh_ngay_trong_cong_thuc_VSTACK\"><\/span>G\u1ed9p v\u00f9ng d\u1eef li\u1ec7u v\u00e0 m\u1ea3ng t\u0129nh ngay trong c\u00f4ng th\u1ee9c VSTACK<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong v\u00ed d\u1ee5 sau \u0111\u00e2y, ch\u00fang ta s\u1ebd \u0111i g\u1ed9p 2 v\u00f9ng d\u1eef li\u1ec7u tr\u00ean Sheet v\u00e0 ti\u00eau \u0111\u1ec1 \u0111\u01b0\u1ee3c l\u01b0u d\u01b0\u1edbi d\u1ea1ng m\u1ed9t m\u1ea3ng t\u0129nh. C\u00f4ng th\u1ee9c VSTACK b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng nh\u01b0 sau:<\/p>\n<pre class=\"wp-block-code\"><code>=VSTACK({\"Item\",\"Color\",\"Size\"}, A2:C6, A10:C14)<\/code><\/pre>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<figure class=\"wp-block-image alignnone\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2022\/09\/gop-mang-vstack-va-mang-tinh.webp\"><img loading=\"lazy\" decoding=\"async\" width=\"625\" height=\"356\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/gop-mang-vstack-va-mang-tinh-1.webp\" alt=\"G\u1ed9p m\u1ea3ng v\u1edbi vstack v\u00e0 m\u1ea3ng t\u0129nh\" class=\"wp-image-39392\" title=\"gop-mang-vstack-va-mang-tinh-1\"><\/a><figcaption class=\"wp-element-caption\">G\u1ed9p m\u1ea3ng v\u1edbi vstack v\u00e0 m\u1ea3ng t\u0129nh<\/figcaption><\/figure>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Gop_nhieu_bang_trong_Excel_voi_VSTACK_hoac_HSTACK\"><\/span>G\u1ed9p nhi\u1ec1u b\u1ea3ng trong Excel v\u1edbi VSTACK ho\u1eb7c HSTACK<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong v\u00ed d\u1ee5 tr\u01b0\u1edbc, ch\u00fang ta c\u00f3 th\u1ec3 g\u1ed9p d\u1eef li\u1ec7u t\u1eeb v\u00f9ng (range) v\u00e0 m\u1ea3ng d\u1eef li\u1ec7u, trong v\u00ed d\u1ee5 sau \u0111\u00e2y, c\u00e1c b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 g\u1ed9p b\u1ea3ng d\u1eef li\u1ec7u trong Excel b\u1eb1ng h\u00e0m VSTACK ho\u1eb7c HSTACK m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. \u01afu \u0111i\u1ec3m c\u1ee7a vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u th\u00e0nh d\u1ea1ng b\u1ea3ng \u0111\u00f3 l\u00e0 khi d\u1eef li\u1ec7u m\u1edbi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o ph\u00eda d\u01b0\u1edbi c\u1ee7a b\u1ea3ng, th\u00ec v\u00f9ng d\u1eef li\u1ec7u s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt, d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m VSTACK v\u00e0 HSTACK c\u0169ng t\u1ef1 \u0111\u1ed9ng \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt theo.<\/p>\n<pre class=\"wp-block-code\"><code>=VSTACK(Table1, Table2)<\/code><\/pre>\n<figure class=\"wp-block-image alignnone\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2022\/09\/Gop-bang-table-trong-Excel-voi-VSTACK-HSTACK.webp\"><img loading=\"lazy\" decoding=\"async\" width=\"671\" height=\"398\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/gop-bang-table-trong-excel-voi-vstack-hstack-1.webp\" alt=\"G\u1ed9p b\u1ea3ng (table) trong Excel v\u1edbi VSTACK HSTACK\" class=\"wp-image-39393\" title=\"gop-bang-table-trong-excel-voi-vstack-hstack-1\"><\/a><figcaption class=\"wp-element-caption\">G\u1ed9p b\u1ea3ng (table) trong Excel v\u1edbi VSTACK HSTACK<\/figcaption><\/figure>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Gop_mang_du_lieu_la_ket_qua_cua_ham_khac\"><\/span>G\u1ed9p m\u1ea3ng d\u1eef li\u1ec7u l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m kh\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ngo\u00e0i kh\u1ea3 n\u0103ng g\u1ed9p d\u1eef li\u1ec7u t\u1eeb v\u00f9ng, m\u1ea3ng, b\u1ea3ng trong Excel, h\u00e0m VSTACK hay HSTACK c\u00f2n c\u00f3 th\u1ec3 g\u1ed9p d\u1eef li\u1ec7u \u0111\u1ebfn t\u1eeb k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m kh\u00e1c.<\/p>\n<p>Trong v\u00ed d\u1ee5 sau \u0111\u00e2y, ch\u00fang ta s\u1ebd \u0111i g\u1ed9p d\u1eef li\u1ec7u \u0111\u1ebfn t\u1eeb k\u1ebft qu\u1ea3 c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/ham-unique-trong-excel-loc-gia-tri-duy-nhat-trong-vung.html\" target=\"_blank\" rel=\"noopener\">h\u00e0m Unique<\/a><\/p>\n<pre class=\"wp-block-code\"><code>=VSTACK(E3#, E12#)<\/code><\/pre>\n<figure class=\"wp-block-image alignnone\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2022\/09\/Gop-mang-tu-ket-qua-cua-ham-khac.webp\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"420\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/gop-mang-tu-ket-qua-cua-ham-khac-1.webp\" alt=\"G\u1ed9p m\u1ea3ng t\u1eeb k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m kh\u00e1c\" class=\"wp-image-39394\" title=\"gop-mang-tu-ket-qua-cua-ham-khac-1\"><\/a><figcaption class=\"wp-element-caption\">G\u1ed9p m\u1ea3ng t\u1eeb k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m kh\u00e1c<\/figcaption><\/figure>\n<p>\u01afu \u0111i\u1ec3m c\u1ee7a c\u00e1ch l\u00e0m n\u00e0y l\u00e0, khi b\u1ea1n thay \u0111\u1ed5i d\u1eef li\u1ec7u \u1edf c\u00e1c v\u00f9ng d\u1eef li\u1ec7u g\u1ed1c, th\u00ec c\u00f4ng th\u1ee9c s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n v\u00e0 c\u1eadp nh\u1eadt k\u1ebft qu\u1ea3 theo ngay l\u1eadp t\u1ee9c.<\/p>\n<p>Nh\u01b0 v\u1eady, trong b\u00e0i vi\u1ebft n\u00e0y, b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c c\u00e1ch \u00e1p d\u1ee5ng c\u01a1 b\u1ea3n c\u1ee7a h\u00e0m VSTACK v\u00e0 HSTACK trong Excel. Hi v\u1ecdng nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y s\u1ebd gi\u00fap b\u1ea1n \u00e1p d\u1ee5ng th\u00e0nh c\u00f4ng trong c\u00f4ng vi\u1ec7c.<\/p>\n<p>Thanh xin h\u1eb9n g\u1eb7p l\u1ea1i c\u00e1c b\u1ea1n trong c\u00e1c chia s\u1ebb ti\u1ebfp theo.<\/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-52.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":874,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-873","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\/873","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=873"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/873\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/874"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=873"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=873"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=873"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}