{"id":11840,"date":"2025-01-15T05:27:59","date_gmt":"2025-01-15T05:27:59","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du\/"},"modified":"2025-01-15T05:27:59","modified_gmt":"2025-01-15T05:27:59","slug":"ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du\/","title":{"rendered":"H\u00e0m OFFSET v\u00e0 c\u00e1c k\u1ebft h\u1ee3p h\u00e0m c\u1ee7a n\u00f3 trong Excel, c\u00f4ng th\u1ee9c v\u00ed d\u1ee5"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <strong>h\u1ecdc excel n\u00e2ng cao online<\/strong>\u00a0s\u1ebd h\u01b0\u1edbng d\u1eabn v\u1ec1 h\u00e0m OFFSET.<\/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-6787475d798bd\" 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\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#Ham_OFFSET_%E2%80%93_cu_phap_va_su_dung_co_ban\" title=\"H\u00e0m OFFSET \u2013 c\u00fa ph\u00e1p v\u00e0 s\u1eed d\u1ee5ng c\u01a1 b\u1ea3n:\">H\u00e0m OFFSET \u2013 c\u00fa ph\u00e1p v\u00e0 s\u1eed d\u1ee5ng c\u01a1 b\u1ea3n:<\/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\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#Nhung_doi_so_bat_buoc\" title=\"Nh\u1eefng \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c:\">Nh\u1eefng \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c:<\/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\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#Nhung_doi_so_tuy_chon\" title=\"Nh\u1eefng \u0111\u1ed1i s\u1ed1 t\u00f9y ch\u1ecdn:\">Nh\u1eefng \u0111\u1ed1i s\u1ed1 t\u00f9y ch\u1ecdn:<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#Vi_du_cong_thuc_OFFSET\" title=\"V\u00ed d\u1ee5 c\u00f4ng th\u1ee9c OFFSET:\">V\u00ed d\u1ee5 c\u00f4ng th\u1ee9c OFFSET:<\/a><\/li>\n<\/ul>\n<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#Cong_thuc_Excel_OFFSET_%E2%80%93_nhung_dieu_can_nho\" title=\"C\u00f4ng th\u1ee9c Excel OFFSET \u2013 nh\u1eefng \u0111i\u1ec1u c\u1ea7n nh\u1edb:\">C\u00f4ng th\u1ee9c Excel OFFSET \u2013 nh\u1eefng \u0111i\u1ec1u c\u1ea7n nh\u1edb:<\/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-6\" href=\"https:\/\/blog.hocexcel.online\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#Su_dung_OFFSET_trong_truong_hop_nao\" title=\"S\u1eed d\u1ee5ng OFFSET \u00a0trong tr\u01b0\u1eddng h\u1ee3p n\u00e0o:\">S\u1eed d\u1ee5ng OFFSET \u00a0trong tr\u01b0\u1eddng h\u1ee3p n\u00e0o:<\/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\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#Lam_the_nao_de_su_dung_ham_OFFSET_trong_Excel_%E2%80%93_cac_cong_thuc_vi_du\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m OFFSET trong Excel \u2013 c\u00e1c c\u00f4ng th\u1ee9c v\u00ed d\u1ee5:\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m OFFSET trong Excel \u2013 c\u00e1c c\u00f4ng th\u1ee9c v\u00ed d\u1ee5:<\/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-8\" href=\"https:\/\/blog.hocexcel.online\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#Ham_OFFSET_va_ham_SUM\" title=\"H\u00e0m OFFSET v\u00e0 \u00a0h\u00e0m SUM:\">H\u00e0m OFFSET v\u00e0 \u00a0h\u00e0m SUM:<\/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-9\" href=\"https:\/\/blog.hocexcel.online\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#Vi_du_1_Mot_cong_thuc_ham_SUM_OFFSET_thay_doi\" title=\"V\u00ed d\u1ee5 1. M\u1ed9t c\u00f4ng th\u1ee9c h\u00e0m SUM \/ OFFSET thay \u0111\u1ed5i:\">V\u00ed d\u1ee5 1. M\u1ed9t c\u00f4ng th\u1ee9c h\u00e0m SUM \/ OFFSET thay \u0111\u1ed5i:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#Vi_du_2_Cong_thuc_OFFSET_de_tong_hop_N_cac_dong_cuoi_danh_sach\" title=\"V\u00ed d\u1ee5 2. C\u00f4ng th\u1ee9c OFFSET \u00a0\u0111\u1ec3 t\u1ed5ng h\u1ee3p N c\u00e1c d\u00f2ng cu\u1ed1i danh s\u00e1ch:\">V\u00ed d\u1ee5 2. C\u00f4ng th\u1ee9c OFFSET \u00a0\u0111\u1ec3 t\u1ed5ng h\u1ee3p N c\u00e1c d\u00f2ng cu\u1ed1i danh s\u00e1ch:<\/a><\/li>\n<\/ul>\n<\/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\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#Su_dung_ham_OFFSET_voi_AVERAGE_MAX_MIN\" title=\"S\u1eed d\u1ee5ng h\u00e0m OFFSET v\u1edbi AVERAGE, MAX, MIN\">S\u1eed d\u1ee5ng h\u00e0m OFFSET v\u1edbi AVERAGE, MAX, MIN<\/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-12\" href=\"https:\/\/blog.hocexcel.online\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#Cong_thuc_OFFSET_de_tao_ra_mot_dai_dong\" title=\"C\u00f4ng th\u1ee9c OFFSET \u0111\u1ec3 t\u1ea1o ra m\u1ed9t d\u1ea3i \u0111\u1ed9ng\">C\u00f4ng th\u1ee9c OFFSET \u0111\u1ec3 t\u1ea1o ra m\u1ed9t d\u1ea3i \u0111\u1ed9ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#Ham_OFFSET_VLOOKUP\" title=\"H\u00e0m OFFSET &amp; VLOOKUP:\">H\u00e0m OFFSET &amp; VLOOKUP:<\/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-14\" href=\"https:\/\/blog.hocexcel.online\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#Vi_du_1_Cong_thuc_OFFSET_cho_mot_Vlookup_do_ben_trai_trong_Excel\" title=\"V\u00ed d\u1ee5 1. C\u00f4ng th\u1ee9c OFFSET cho m\u1ed9t Vlookup d\u00f2 b\u00ean tr\u00e1i trong Excel\">V\u00ed d\u1ee5 1. C\u00f4ng th\u1ee9c OFFSET cho m\u1ed9t Vlookup d\u00f2 b\u00ean tr\u00e1i trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#Vi_du_2_Lam_the_nao_su_dung_Vlookup_do_ben_tren_trong_Excel\" title=\"V\u00ed d\u1ee5 2. L\u00e0m th\u1ebf n\u00e0o s\u1eed d\u1ee5ng Vlookup d\u00f2 b\u00ean tr\u00ean trong Excel\">V\u00ed d\u1ee5 2. L\u00e0m th\u1ebf n\u00e0o s\u1eed d\u1ee5ng Vlookup d\u00f2 b\u00ean tr\u00ean trong Excel<\/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-16\" href=\"https:\/\/blog.hocexcel.online\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#Vi_du_3_tra_cuu_hai_chieu_theo_cot_va_gia_tri_hang\" title=\"V\u00ed d\u1ee5 3. tra c\u1ee9u hai chi\u1ec1u (theo c\u1ed9t v\u00e0 gi\u00e1 tr\u1ecb h\u00e0ng)\">V\u00ed d\u1ee5 3. tra c\u1ee9u hai chi\u1ec1u (theo c\u1ed9t v\u00e0 gi\u00e1 tr\u1ecb h\u00e0ng)<\/a><\/li>\n<\/ul>\n<\/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-17\" href=\"https:\/\/blog.hocexcel.online\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#Ham_OFFSET_%E2%80%93_han_che_va_cac_lua_chon_thay_the\" title=\"H\u00e0m OFFSET \u2013 h\u1ea1n ch\u1ebf v\u00e0 c\u00e1c l\u1ef1a ch\u1ecdn thay th\u1ebf\">H\u00e0m OFFSET \u2013 h\u1ea1n ch\u1ebf v\u00e0 c\u00e1c l\u1ef1a ch\u1ecdn thay th\u1ebf<\/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-18\" href=\"https:\/\/blog.hocexcel.online\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#Nhung_han_che_quan_trong_nhat_cua_ham_OFFSET_nhu_sau\" title=\"Nh\u1eefng h\u1ea1n ch\u1ebf quan tr\u1ecdng nh\u1ea5t c\u1ee7a h\u00e0m OFFSET nh\u01b0 sau:\">Nh\u1eefng h\u1ea1n ch\u1ebf quan tr\u1ecdng nh\u1ea5t c\u1ee7a h\u00e0m OFFSET nh\u01b0 sau:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/blog.hocexcel.online\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#Cac_lua_chon_thay_the_cho_viec_su_dung_OFFSET_trong_Excel\" title=\"C\u00e1c l\u1ef1a ch\u1ecdn thay th\u1ebf cho vi\u1ec7c s\u1eed d\u1ee5ng OFFSET trong Excel\">C\u00e1c l\u1ef1a ch\u1ecdn thay th\u1ebf cho vi\u1ec7c s\u1eed d\u1ee5ng OFFSET trong Excel<\/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-20\" href=\"https:\/\/blog.hocexcel.online\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#1_Cac_bang_trong_Excel\" title=\"1. C\u00e1c b\u1ea3ng trong Excel:\">1. C\u00e1c b\u1ea3ng trong Excel:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/blog.hocexcel.online\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#2_Ham_INDEX\" title=\"2. H\u00e0m INDEX\">2. H\u00e0m INDEX<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/blog.hocexcel.online\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html#3_Ham_INDIRECT\" title=\"3. H\u00e0m INDIRECT\">3. H\u00e0m INDIRECT<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_OFFSET_%E2%80%93_cu_phap_va_su_dung_co_ban\"><\/span>H\u00e0m <strong>OFFSET<\/strong> \u2013 c\u00fa ph\u00e1p v\u00e0 s\u1eed d\u1ee5ng c\u01a1 b\u1ea3n:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m OFFSET nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>OFFSET(reference, rows, cols, [height], [width])<\/strong><\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3, 3 \u0111\u1ed1i s\u1ed1 \u0111\u1ea7u ti\u00ean l\u00e0 b\u1eaft bu\u1ed9c c\u00f2n 2 c\u00e1i sau th\u00ec kh\u00f4ng. T\u1ea5t c\u1ea3 c\u00e1c \u0111\u1ed1i s\u1ed1 c\u00f3 th\u1ec3 l\u00e0 c\u00e1c tham chi\u1ebfu \u0111\u1ebfn c\u00e1c \u00f4 kh\u00e1c ho\u1eb7c l\u00e0 c\u00e1c k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi c\u00e1c c\u00f4ng th\u1ee9c Excel kh\u00e1c.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Nhung_doi_so_bat_buoc\"><\/span>Nh\u1eefng \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul style=\"text-align: justify\">\n<li><strong> Reference<\/strong>\u2013 m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t d\u1ea3i \u00f4 li\u1ec1n k\u1ec1 m\u00e0 sau \u0111\u00f3 n\u00f3 c\u00f3 th\u1ec3 b\u1ecb th\u00eam\/b\u1edbt (C\u00f3 th\u1ec3 n\u00f3i \u0111\u00f3 l\u00e0 \u0111i\u1ec3m kh\u1edfi \u0111\u1ea7u\/l\u00e0m m\u1ed1c)<\/li>\n<li><strong> Rows<\/strong> \u2013 S\u1ed1 h\u00e0ng di chuy\u1ec3n t\u1eeb \u0111i\u1ec3m l\u00e0m g\u1ed1c, l\u00ean ho\u1eb7c xu\u1ed1ng. N\u1ebfu c\u00e1c h\u00e0ng l\u00e0 m\u1ed9t s\u1ed1 d\u01b0\u01a1ng, ngh\u0129a l\u00e0 c\u00f4ng th\u1ee9c di chuy\u1ec3n xu\u1ed1ng ph\u00eda d\u01b0\u1edbi tham chi\u1ebfu, trong tr\u01b0\u1eddng h\u1ee3p m\u1ed9t s\u1ed1 \u00e2m th\u00ec di chuy\u1ec3n l\u00ean ph\u00eda tr\u00ean tham chi\u1ebfu.<\/li>\n<li><strong>Cols<\/strong> \u2013 S\u1ed1 c\u1ed9t b\u1ea1n mu\u1ed1n c\u00f4ng th\u1ee9c di chuy\u1ec3n, l\u1ea5y g\u1ed1c l\u00e0 t\u1eeb \u0111i\u1ec3m xu\u1ea5t ph\u00e1t. C\u0169ng nh\u01b0 rows, cols c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 d\u01b0\u01a1ng (\u1edf b\u00ean ph\u1ea3i tham chi\u1ebfu) ho\u1eb7c s\u1ed1 \u00e2m (\u1edf b\u00ean tr\u00e1i tham chi\u1ebfu).<\/li>\n<\/ul>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Nhung_doi_so_tuy_chon\"><\/span>Nh\u1eefng \u0111\u1ed1i s\u1ed1 t\u00f9y ch\u1ecdn:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul style=\"text-align: justify\">\n<li><strong> height <\/strong>\u2013 chi\u1ec1u cao, t\u00ednh b\u1eb1ng s\u1ed1 h\u00e0ng, m\u00e0 b\u1ea1n mu\u1ed1n tham chi\u1ebfu tr\u1ea3 v\u1ec1<\/li>\n<li><strong> Width <\/strong>\u2013 chi\u1ec1u r\u1ed9ng, t\u00ednh b\u1eb1ng s\u1ed1 c\u1ed9t, m\u00e0 b\u1ea1n mu\u1ed1n tham chi\u1ebfu tr\u1ea3 v\u1ec1.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">C\u1ea3 hai \u0111\u1ed1i s\u1ed1 height v\u00e0 width lu\u00f4n ph\u1ea3i l\u00e0 s\u1ed1 d\u01b0\u01a1ng. N\u1ebfu m\u1ed9t trong hai b\u1ecb b\u1ecf qua, th\u00ec height ho\u1eb7c width c\u1ee7a tham chi\u1ebfu g\u1ed1c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng.<\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, t\u00f4i c\u00f3 m\u1ed9t v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n v\u1ec1 c\u00f4ng th\u1ee9c OFFSET nh\u1eb1m minh ho\u1ea1 l\u00fd thuy\u1ebft tr\u00ean:<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_cong_thuc_OFFSET\"><\/span>V\u00ed d\u1ee5 c\u00f4ng th\u1ee9c <strong>OFFSET:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c <strong>OFFSET<\/strong> sau tr\u1ea3 v\u1ec1 m\u1ed9t tham chi\u1ebfu \u00f4 d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec3m l\u00e0m m\u1ed1c, c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh:<\/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-63.gif\" title=\"vba101_92019-nho-63\"><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-329.gif\" title=\"ex101_92019-nho-329\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><strong>= OFFSET (A1,3,1)<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c \u00a0l\u1ea5y \u00f4 A1 l\u00e0m \u0111i\u1ec3m l\u00e0m m\u1ed1c (tham chi\u1ebfu), sau \u0111\u00f3 di chuy\u1ec3n 3 h\u00e0ng xu\u1ed1ng (\u0111\u1ed1i s\u1ed1 rows) v\u00e0 1 c\u1ed9t b\u00ean tr\u00e1i (\u0111\u1ed1i s\u1ed1 cols). K\u1ebft qu\u1ea3 l\u00e0, c\u00f4ng th\u1ee9c OFFSET n\u00e0y tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb trong \u00f4 B4.<\/p>\n<p style=\"text-align: justify\">H\u00ecnh \u1ea3nh \u1edf b\u00ean tr\u00e1i cho th\u1ea5y c\u00e1ch th\u1ee9c h\u00e0m ho\u1ea1t \u0111\u1ed9ng v\u00e0 \u1edf b\u00ean ph\u1ea3i th\u1ec3 hi\u1ec7n c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c OFFSET tr\u00ean d\u1eef li\u1ec7u th\u1ef1c t\u1ebf. S\u1ef1 kh\u00e1c bi\u1ec7t duy nh\u1ea5t gi\u1eefa hai c\u00f4ng th\u1ee9c l\u00e0 c\u00f4ng th\u1ee9c th\u1ee9 hai (b\u00ean ph\u1ea3i) bao g\u1ed3m m\u1ed9t tham chi\u1ebfu \u00f4 (E1) trong \u0111\u1ed1i s\u1ed1 h\u00e0ng (rows). Nh\u01b0ng n\u1ebfu \u00f4 E1 c\u00f3 ch\u1ee9a s\u1ed1 3 v\u00e0 ch\u00ednh x\u00e1c c\u00f9ng m\u1ed9t s\u1ed1 xu\u1ea5t hi\u1ec7n trong c\u00e1c \u0111\u1ed1i s\u1ed1 h\u00e0ng c\u1ee7a c\u00f4ng th\u1ee9c \u0111\u1ea7u ti\u00ean, th\u00ec c\u1ea3 hai s\u1ebd \u0111\u1ec1u tr\u1ea3 v\u1ec1 c\u00f9ng m\u1ed9t k\u1ebft qu\u1ea3 \u2013 gi\u00e1 tr\u1ecb trong B4.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-offset-function.png\" alt=\"Excel OFFSET formula example\" title=\"excel-offset-function\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0T\u00e0i li\u1ec7u <a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">excel c\u01a1 b\u1ea3n<\/a> 2018<\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_Excel_OFFSET_%E2%80%93_nhung_dieu_can_nho\"><\/span>C\u00f4ng th\u1ee9c Excel <strong>OFFSET<\/strong> \u2013 nh\u1eefng \u0111i\u1ec1u c\u1ea7n nh\u1edb:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify\">\n<li>H\u00e0m <strong>OFFSET<\/strong> trong Excel kh\u00f4ng th\u1ef1c s\u1ef1 di chuy\u1ec3n b\u1ea5t k\u1ef3 \u00f4 ho\u1eb7c d\u1ea3i n\u00e0o, m\u00e0 \u0111i\u1ec1u n\u00f3 l\u00e0m ch\u1ec9 l\u00e0 tr\u1ea3 v\u1ec1 m\u1ed9t tham chi\u1ebfu.<\/li>\n<li>Khi m\u1ed9t c\u00f4ng th\u1ee9c<strong> OFFSET<\/strong> tr\u1ea3 v\u1ec1 m\u1ed9t d\u1ea3i \u00f4, c\u00e1c \u0111\u1ed1i s\u1ed1 rows v\u00e0 cols lu\u00f4n lu\u00f4n \u0111\u1ec1 c\u1eadp \u0111\u1ebfn \u00f4 ph\u00eda tr\u00ean b\u00ean tr\u00e1i.<\/li>\n<li>\u0110\u1ed1i s\u1ed1 tham chi\u1ebfu ph\u1ea3i bao g\u1ed3m m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t d\u1ea3i \u00f4 li\u1ec1n k\u1ec1, n\u1ebfu kh\u00f4ng c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n s\u1ebd tr\u1ea3 v\u1ec1 <strong>#VALUE!<\/strong> l\u1ed7i.<\/li>\n<li>N\u1ebfu c\u00e1c h\u00e0ng (<strong>rows<\/strong>) \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh v\u00e0\/ho\u1eb7c c\u1ed9t (<strong>cols<\/strong>) di chuy\u1ec3n m\u1ed9t tham chi\u1ebfu \u0111\u1ebfn r\u00eca c\u1ee7a b\u1ea3ng t\u00ednh, th\u00ec c\u00f4ng th\u1ee9c Excel <strong>OFFSET<\/strong> c\u1ee7a b\u1ea1n s\u1ebd tr\u1ea3 v\u1ec1 <strong>#REF!<\/strong> l\u1ed7i.<\/li>\n<li>H\u00e0m OFFSET c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong b\u1ea5t k\u1ef3 h\u00e0m Excel n\u00e0o kh\u00e1c m\u00e0 c\u00f3 ch\u1ea5p nh\u1eadn m\u1ed9t tham chi\u1ebfu \u00f4 ho\u1eb7c d\u1ea3i trong c\u00e1c \u0111\u1ed1i s\u1ed1 c\u1ee7a n\u00f3.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n c\u1ed1 g\u1eafng s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 th\u1ebf n\u00e0y: = OFFSET (A1,3,1,1,3), th\u00ec n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 # VALUE! L\u1ed7i, v\u00ec m\u1ed9t d\u1ea3i \u0111\u1ec3 chuy\u1ec3n th\u00e0nh (1 h\u00e0ng, 3 c\u1ed9t) kh\u00f4ng ph\u00f9 h\u1ee3p v\u1edbi vi\u1ec7c \u0111\u1eb7t ch\u1ec9 trong m\u1ed9t \u00f4 duy nh\u1ea5t. Tuy nhi\u00ean, n\u1ebfu b\u1ea1n nh\u00fang n\u00f3 v\u00e0o h\u00e0m <strong>SUM, <\/strong>nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><strong>= SUM (OFFSET (A1,3,1,1,3))<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 l\u1ea1i t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong d\u1ea3i c\u00f3 1 h\u00e0ng b\u1eb1ng d\u1ea3i g\u1ed3m 3 c\u1ed9t, bao g\u1ed3m 3 h\u00e0ng b\u00ean d\u01b0\u1edbi v\u00e0 1 c\u1ed9t b\u00ean ph\u1ea3i \u00f4 A1, t\u1ee9c l\u00e0 t\u1ed5ng gi\u00e1 tr\u1ecb c\u00f3 trong c\u00e1c \u00f4 B4: D4.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-offset-sum.png\" alt=\"Using OFFSET with the SUM function\" title=\"excel-offset-sum\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_OFFSET_trong_truong_hop_nao\"><\/span>S\u1eed d\u1ee5ng <strong>OFFSET<\/strong> \u00a0trong tr\u01b0\u1eddng h\u1ee3p n\u00e0o:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd b\u1ea1n \u0111\u00e3 bi\u1ebft h\u00e0m OFFSET l\u00e0m \u0111\u01b0\u1ee3c nh\u1eefng g\u00ec, v\u1eady n\u00ean b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 h\u1ecfi m\u00ecnh \u201cT\u1ea1i sao l\u1ea1i ph\u1ea3i d\u00f9ng n\u00f3?\u201d T\u1ea1i sao kh\u00f4ng ch\u1ec9 \u0111\u01a1n gi\u1ea3n l\u00e0 vi\u1ebft m\u1ed9t tham chi\u1ebfu tr\u1ef1c ti\u1ebfp nh\u01b0 B4: D4?<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c <strong>OFFSET<\/strong> r\u1ea5t h\u1eefu \u00edch n\u1ebfu b\u1ea1n mu\u1ed1n:<\/p>\n<p style=\"text-align: justify\">T\u1ea1o c\u00e1c d\u1ea3i \u0111\u1ed9ng: C\u00e1c tham chi\u1ebfu nh\u01b0 B1: C4 l\u00e0 t\u0129nh, c\u00f3 ngh\u0129a l\u00e0 ch\u00fang lu\u00f4n tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t d\u1ea3i nh\u1ea5t \u0111\u1ecbnh. Nh\u01b0ng v\u1edbi m\u1ed9t s\u1ed1 c\u00f4ng vi\u1ec7c th\u00ec s\u1ebd d\u1ec5 th\u1ef1c hi\u1ec7n h\u01a1n khi l\u00e0m v\u1edbi d\u1ea3i \u0111\u1ed9ng. \u0110\u00e2y l\u00e0 tr\u01b0\u1eddng h\u1ee3p \u0111\u1eb7c bi\u1ec7t khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi vi\u1ec7c thay \u0111\u1ed5i d\u1eef li\u1ec7u, v\u00ed d\u1ee5: B\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh, v\u00e0 m\u1ed7i tu\u1ea7n s\u1ebd c\u00f3 m\u1ed9t h\u00e0ng ho\u1eb7c c\u1ed9t m\u1edbi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o trong \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">L\u1ea5y d\u1ea3i t\u1eeb \u00f4 g\u1ed1c: \u0110\u00f4i khi, b\u1ea1n c\u00f3 th\u1ec3 kh\u00f4ng bi\u1ebft \u0111\u1ecba ch\u1ec9 th\u1ef1c c\u1ee7a c\u1ea3 d\u1ea3i, m\u1eb7c d\u00f9 b\u1ea1n c\u00f3 bi\u1ebft r\u1eb1ng n\u00f3 b\u1eaft \u0111\u1ea7u t\u1eeb m\u1ed9t s\u1ed1 \u00f4. Trong c\u00e1c t\u00ecnh hu\u1ed1ng nh\u01b0 v\u1eady, s\u1eed d\u1ee5ng OFFSET trong Excel l\u00e0 1 c\u00e1ch l\u00e0m \u0111\u00fang.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_su_dung_ham_OFFSET_trong_Excel_%E2%80%93_cac_cong_thuc_vi_du\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m <strong>OFFSET<\/strong> trong Excel \u2013 c\u00e1c c\u00f4ng th\u1ee9c v\u00ed d\u1ee5:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">T\u00f4i hy v\u1ecdng b\u1ea1n \u0111\u00e3 kh\u00f4ng c\u1ea3m th\u1ea5y n\u1ea3n v\u1edbi \u0111\u1ed1ng l\u00fd thuy\u1ebft \u1edf tr\u00ean. D\u00f9 sao, b\u00e2y gi\u1edd ch\u00fang ta \u0111ang th\u1ef1c hi\u1ec7n ph\u1ea7n th\u00fa v\u1ecb nh\u1ea5t \u2013 \u00e1p d\u1ee5ng h\u00e0m OFFSET trong t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_OFFSET_va_ham_SUM\"><\/span>H\u00e0m <strong>OFFSET<\/strong> v\u00e0 \u00a0h\u00e0m <strong>SUM:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 ch\u00fang ta \u0111\u00e3 th\u1ea3o lu\u1eadn c\u00e1ch \u0111\u00e2y m\u1ed9t ph\u00fat th\u1ec3 hi\u1ec7n c\u00e1ch s\u1eed d\u1ee5ng <strong>OFFSET<\/strong> v\u00e0 <strong>SUM <\/strong>trong <strong>Excel <\/strong>\u0111\u01a1n gi\u1ea3n nh\u1ea5t. B\u00e2y gi\u1edd, ch\u00fang ta h\u00e3y nh\u00ecn v\u00e0o nh\u1eefng h\u00e0m n\u00e0y \u1edf m\u1ed9t g\u00f3c \u0111\u1ed9 kh\u00e1c v\u00e0 xem nh\u1eefng g\u00ec ch\u00fang c\u00f3 th\u1ec3 l\u00e0m.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_1_Mot_cong_thuc_ham_SUM_OFFSET_thay_doi\"><\/span>V\u00ed d\u1ee5 1. M\u1ed9t c\u00f4ng th\u1ee9c h\u00e0m <strong>SUM \/ OFFSET <\/strong>thay \u0111\u1ed5i:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">V\u1ea5n \u0111\u1ec1 n\u1eefa l\u00e0 khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh c\u1eadp nh\u1eadt li\u00ean t\u1ee5c, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n c\u00f3 m\u1ed9t c\u00f4ng th\u1ee9c SUM t\u1ef1 \u0111\u1ed9ng ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng m\u1edbi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o?<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 d\u1eef li\u1ec7u ngu\u1ed3n t\u01b0\u01a1ng t\u1ef1 nh\u01b0 nh\u1eefng g\u00ec b\u1ea1n th\u1ea5y trong h\u00ecnh b\u00ean d\u01b0\u1edbi. M\u1ed7i th\u00e1ng s\u1ebd c\u00f3 m\u1ed9t d\u00f2ng m\u1edbi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o ngay ph\u00eda tr\u00ean c\u00f4ng th\u1ee9c <strong>SUM<\/strong>, v\u00e0 t\u1ef1 nhi\u00ean, b\u1ea1n mu\u1ed1n n\u00f3 \u0111\u01b0\u1ee3c bao g\u1ed3m trong t\u1ed5ng s\u1ed1. Tr\u00ean to\u00e0n b\u1ed9, c\u00f3 hai l\u1ef1a ch\u1ecdn \u2013 ho\u1eb7c c\u1eadp nh\u1eadt c\u00e1c d\u1ea3i trong c\u00f4ng th\u1ee9c SUM m\u1ed7i l\u1ea7n thay \u0111\u1ed5i b\u1eb1ng tay ho\u1eb7c b\u1ea1n s\u1ebd d\u00f9ng h\u00e0m OFFSET l\u00e0m \u0111i\u1ec1u n\u00e0y cho b\u1ea1n.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-offset-sum-data.png\" alt=\"A usual SUM formula\" title=\"excel-offset-sum-data\"><\/p>\n<p style=\"text-align: justify\">Khi \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a d\u1ea3i \u0111\u01b0\u1ee3c t\u00ednh t\u1ed5ng (<strong>SUM<\/strong>) m\u00e0 \u0111\u01b0\u1ee3c tham chi\u1ebfu tr\u1ef1c ti\u1ebfp trong c\u00f4ng th\u1ee9c SUM, b\u1ea1n ch\u1ec9 ph\u1ea3i \u0111\u01b0a ra c\u00e1c tham s\u1ed1 cho h\u00e0m <strong>OFFSET,<\/strong> v\u00e0 sau \u0111\u00f3 n\u00f3 s\u1ebd tham chi\u1ebfu cho \u0111\u1ebfn \u00f4 cu\u1ed1i c\u00f9ng c\u1ee7a d\u1ea3i:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong> Reference<\/strong> \u2013 \u00f4 ch\u1ee9a t\u1ed5ng s\u1ed1, trong v\u00ed d\u1ee5 \u1edf \u0111\u00e2y l\u00e0 \u00f4 B9.<\/li>\n<li><strong> Rows<\/strong> \u2013 \u00f4 tr\u00ean \u00f4 ch\u1ee9a t\u1ed5ng s\u1ed1 v\u00e0 n\u1eb1m b\u00ean ph\u1ea3i, b\u1eaft bu\u1ed9c 1 s\u1ed1 \u00e2m: -1.<\/li>\n<li><strong> Cols<\/strong> \u2013 l\u00e0 0 v\u00ec b\u1ea1n kh\u00f4ng mu\u1ed1n thay \u0111\u1ed5i c\u1ed9t.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">T\u1eeb \u0111\u00f3, ta c\u00f3 m\u1eabu c\u00f4ng th\u1ee9c <strong>SUM \/ OFFSET<\/strong>:<\/p>\n<p style=\"text-align: justify\"><strong>= SUM (first cell: (OFFSET (cell with total, -1,0)<\/strong><\/p>\n<p style=\"text-align: justify\">R\u00fat g\u1ecdn v\u00ed d\u1ee5 tr\u00ean, ta s\u1ebd c\u00f3 c\u00f4ng th\u1ee9c tr\u00f4ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>= SUM (B2: (OFFSET (B9, -1, 0)))<\/strong><\/p>\n<p style=\"text-align: justify\">V\u00e0 n\u00f3 th\u1ef1c s\u1ef1 ho\u1ea1t \u0111\u1ed9ng t\u1ed1t nh\u01b0 trong h\u00ecnh \u0111\u01b0\u1ee3c minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-offset-sum-formula.png\" alt=\"A dynamic SUM \/ OFFSET formula in Excel\" title=\"excel-offset-sum-formula\"><\/p>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cac-vi-du-ve-ham-sum-trong-excel-cach-chi-tinh-tong-cac-cot-hang-hoac-o-duoc-hien-thi.html\">C\u00e1c v\u00ed d\u1ee5 v\u1ec1 h\u00e0m Sum trong Excel \u2013 C\u00e1ch ch\u1ec9 t\u00ednh t\u1ed5ng c\u00e1c c\u1ed9t, h\u00e0ng ho\u1eb7c \u00f4 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb<\/a><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_2_Cong_thuc_OFFSET_de_tong_hop_N_cac_dong_cuoi_danh_sach\"><\/span>V\u00ed d\u1ee5 2. C\u00f4ng th\u1ee9c <strong>OFFSET <\/strong>\u00a0\u0111\u1ec3 t\u1ed5ng h\u1ee3p N c\u00e1c d\u00f2ng cu\u1ed1i danh s\u00e1ch:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 tr\u00ean, gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n bi\u1ebft s\u1ed1 ti\u1ec1n th\u01b0\u1edfng (Bonus) cho N th\u00e1ng g\u1ea7n nh\u1ea5t ch\u1ee9 kh\u00f4ng ph\u1ea3i l\u00e0 t\u1ea5t c\u1ea3. V\u00e0 b\u1ea1n c\u0169ng mu\u1ed1n c\u00f4ng th\u1ee9c ch\u1ea1y t\u1ef1 \u0111\u1ed9ng (kh\u00f4ng quan t\u00e2m \u0111\u1ebfn li\u1ec7u c\u00f3 b\u1ea5t k\u1ef3 h\u00e0ng m\u1edbi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o trang t\u00ednh hay kh\u00f4ng).<\/p>\n<p style=\"text-align: justify\">V\u1edbi nhi\u1ec7m v\u1ee5 n\u00e0y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng Excel <strong>OFFSET<\/strong> k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m <strong>SUM<\/strong> v\u00e0 h\u00e0m\u00a0<strong>COUNT \/ COUNTA<\/strong>:<\/p>\n<p style=\"text-align: justify\"><strong>= SUM (OFFSET (B1, COUNT (B: B) -E1 + 1,0, E1,1))<\/strong><\/p>\n<p style=\"text-align: justify\">ho\u1eb7c l\u00e0<\/p>\n<p style=\"text-align: justify\"><strong>= SUM (OFFSET (B1, COUNTA (B: B) -E1,0, E1,1)))<\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/offset-sum-count.png\" alt=\"Excel OFFSET formula to sum the last N rows\" title=\"offset-sum-count\"><\/p>\n<p style=\"text-align: justify\">C\u00e1c th\u00f4ng tin sau \u0111\u00e2y c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 c\u00e1c c\u00f4ng th\u1ee9c t\u1ed1t h\u01a1n:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong> Reference<\/strong> \u2013 ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t c\u00f3 c\u00e1c gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng, trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 \u00f4 B1.<\/li>\n<li><strong> Rows<\/strong> \u2013 \u0111\u1ec3 t\u00ednh s\u1ed1 h\u00e0ng \u0111\u1ec3 t\u00ednh offset, v\u00e0 b\u1ea1n s\u1eed d\u1ee5ng th\u00eam h\u00e0m COUNT ho\u1eb7c COUNTA.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>COUNTA<\/strong> tr\u1ea3 v\u1ec1 s\u1ed1 \u00f4 trong c\u1ed9t B c\u00f3 ch\u1ee9a s\u1ed1, t\u1eeb \u0111\u00f3 b\u1ea1n tr\u1eeb \u0111i c\u00e1c N th\u00e1ng cu\u1ed1i c\u00f9ng (gi\u00e1 tr\u1ecb \u1edf trong \u00f4 E1) v\u00e0 th\u00eam 1.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n ch\u1ecdn h\u00e0m <strong>COUNTA,<\/strong> th\u00ec khi \u0111\u00f3 b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i th\u00eam 1, v\u00ec h\u00e0m n\u00e0y t\u00ednh t\u1ea5t c\u1ea3 c\u00e1c \u00f4 kh\u00f4ng ch\u1ee9a gi\u00e1 tr\u1ecb r\u1ed7ng, v\u00e0 h\u00e0ng ti\u00eau \u0111\u1ec1 c\u00f3 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c th\u00eam m\u1ed9t \u00f4 th\u00eam m\u1edbi m\u00e0 c\u00f4ng th\u1ee9c c\u1ea7n \u0111\u1ebfn. Xin l\u01b0u \u00fd r\u1eb1ng c\u00f4ng th\u1ee9c n\u00e0y s\u1ebd ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c tr\u00ean m\u1ed9t c\u1ea5u tr\u00fac b\u1ea3ng t\u00ednh t\u01b0\u01a1ng t\u1ef1 \u2013 v\u00e0 d\u00f2ng ti\u00eau \u0111\u1ec1 ti\u1ebfp theo l\u00e0 h\u00e0ng c\u00f3 s\u1ed1. \u0110\u1ed1i v\u1edbi c\u00e1c c\u1ea5u tr\u00fac b\u1ea3ng kh\u00e1c nhau, b\u1ea1n c\u00f3 th\u1ec3 c\u1ea7n th\u1ef1c hi\u1ec7n m\u1ed9t s\u1ed1 \u0111i\u1ec1u ch\u1ec9nh trong c\u00f4ng th\u1ee9c OFFSET \/ COUNTA.<\/p>\n<ul style=\"text-align: justify\">\n<li><strong> Cols<\/strong> \u2013 s\u1ed1 c\u1ed9t \u0111i\u1ec1u ch\u1ec9nh l\u00e0 0.<\/li>\n<li><strong> Chi\u1ec1u cao<\/strong> \u2013 s\u1ed1 h\u00e0ng \u0111\u01b0\u1ee3c t\u1ed5ng h\u1ee3p \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh trong E1.<\/li>\n<li><strong> Chi\u1ec1u r\u1ed9ng<\/strong> \u2013 1 c\u1ed9t.<\/li>\n<\/ul>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_OFFSET_voi_AVERAGE_MAX_MIN\"><\/span>S\u1eed d\u1ee5ng h\u00e0m <strong>OFFSET<\/strong> v\u1edbi <strong>AVERAGE, MAX, MIN<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Theo c\u00e1ch t\u01b0\u01a1ng t\u1ef1 nh\u01b0 ch\u00fang t\u00f4i c\u00f3 th\u1ec3 t\u00ednh ti\u1ec1n th\u01b0\u1edfng cho N th\u00e1ng qua, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb trung b\u00ecnh cho N ng\u00e0y, tu\u1ea7n ho\u1eb7c n\u0103m cu\u1ed1i c\u00f9ng c\u0169ng nh\u01b0 t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb t\u1ed1i \u0111a ho\u1eb7c t\u1ed1i thi\u1ec3u. S\u1ef1 kh\u00e1c bi\u1ec7t duy nh\u1ea5t gi\u1eefa c\u00e1c c\u00f4ng th\u1ee9c l\u00e0 t\u00ean c\u1ee7a h\u00e0m \u0111\u1ea7u ti\u00ean:<\/p>\n<p style=\"text-align: justify\"><strong>= AVERAGE (OFFSET (B1, COUNT (B: B) -E1 + 1,0, E1,1))<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>= MAX (OFFSET (B1, COUNT (B: B) -E1 + 1,0, E1,1))<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>= MIN (OFFSET (B1, COUNT (B: B) -E1 + 1,0, E1,1))<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-offset-average.png\" alt=\"Using OFFSET with the AVERAGE, MAX and MIN functions\" title=\"excel-offset-average\"><\/strong><\/p>\n<p style=\"text-align: justify\">L\u1ee3i \u00edch ch\u00ednh m\u00e0 c\u00e1c c\u00f4ng th\u1ee9c n\u00e0y h\u01a1n h\u00e0m <strong>AVERAGE(B5: B8) ho\u1eb7c MAX (B5: B8)<\/strong> l\u00e0 b\u1ea1n s\u1ebd kh\u00f4ng ph\u1ea3i c\u1eadp nh\u1eadt c\u00f4ng th\u1ee9c m\u1ed7i khi b\u1ea3ng g\u1ed1c c\u1ee7a b\u1ea1n \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt. B\u1ea1n s\u1ebd kh\u00f4ng c\u1ea7n ph\u1ea3i quan t\u00e2m r\u1eb1ng bao nhi\u00eau d\u00f2ng m\u1edbi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o ho\u1eb7c x\u00f3a trong b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n, m\u00e0 s\u1ebd c\u00f3 c\u00e1c c\u00f4ng th\u1ee9c OFFSET s\u1ebd lu\u00f4n lu\u00f4n tham chi\u1ebfu \u0111\u1ebfn t\u1eadn nh\u1eefng \u00f4 cu\u1ed1i c\u00f9ng (\u0111\u00e3 quy \u0111\u1ecbnh tr\u01b0\u1edbc gi\u1edbi h\u1ea1n nh\u1ecf nh\u1ea5t v\u00e0 l\u1edbn nh\u1ea5t) trong c\u1ed9t.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_OFFSET_de_tao_ra_mot_dai_dong\"><\/span>C\u00f4ng th\u1ee9c <strong>OFFSET<\/strong> \u0111\u1ec3 t\u1ea1o ra m\u1ed9t d\u1ea3i \u0111\u1ed9ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u00f9ng v\u1edbi COUNTA, h\u00e0m OFFSET c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n t\u1ea1o m\u1ed9t d\u1ea3i \u0111\u1ed9ng h\u1eefu \u00edch trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng, v\u00ed d\u1ee5 nh\u01b0 khi b\u1ea1n mu\u1ed1n t\u1ea1o danh s\u00e1ch theo m\u1ee5c c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c OFFSET cho m\u1ed9t d\u1ea3i \u0111\u1ed9ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">=<strong> OFFSET (Sheet_Name! $A$1, 0, 0, COUNTA (Sheet_Name! $A:$A), 1)<\/strong><\/p>\n<p style=\"text-align: justify\"><u>Trong \u0111\u00f3:<\/u><\/p>\n<ul style=\"text-align: justify\">\n<li><strong> Reference:<\/strong> \u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n d\u01b0\u1edbi d\u1ea1ng t\u00ean b\u1ea3ng v\u00e0 theo sau l\u00e0 d\u1ea5u ch\u1ea5m than, v\u00e0 \u0111\u1ecba ch\u1ec9 c\u1ee7a \u00f4 c\u00f3 ch\u1ee9a m\u1ee5c \u0111\u1ea7u ti\u00ean c\u00f3 m\u1eb7t trong trong d\u1ea3i (-\u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean). Xin l\u01b0u \u00fd vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i ($), v\u00ed d\u1ee5 Sheet1! $A$1.<\/li>\n<li>C\u00e1c tham s\u1ed1 <strong>Rows<\/strong> and <strong>Cols<\/strong> \u0111\u1ec1u l\u00e0 0, v\u00ec kh\u00f4ng c\u00f3 c\u00e1c c\u1ed9t ho\u1eb7c c\u00e1c h\u00e0ng \u0111\u01b0\u1ee3c th\u00eam v\u00e0o.<\/li>\n<li><strong> Height<\/strong> l\u00e0 \u0111i\u1ec3m m\u1ea5u ch\u1ed1t \u1edf \u0111\u00e2y. T\u00ecnh hu\u1ed1ng l\u00e0 b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m COUNTA \u0111\u1ec3 t\u00ednh to\u00e1n s\u1ed1 \u00f4 kh\u00f4ng r\u1ed7ng trong c\u1ed9t c\u00f3 ch\u1ee9a c\u00e1c m\u1ee5c c\u1ee7a d\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean. V\u1edbi \u0111\u00f3, h\u00e3y l\u01b0u \u00fd r\u1eb1ng trong tham s\u1ed1 c\u1ee7a COUNTA, b\u1ea1n n\u00ean ch\u1ec9 \u0111\u1ecbnh t\u00ean b\u1ea3ng b\u00ean c\u1ea1nh t\u00ean c\u1ed9t, v\u00ed d\u1ee5: COUNTA (Sheet_Name!$A: $A).<\/li>\n<li><strong> Width<\/strong> l\u00e0 1 c\u1ed9t.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">M\u1ed9t khi b\u1ea1n \u0111\u00e3 t\u1ea1o m\u1ed9t d\u1ea3i \u0111\u1ed9ng (\u0111\u00e3 \u0111\u1eb7t t\u00ean) v\u1edbi c\u00f4ng th\u1ee9c <strong>OFFSET<\/strong> \u1edf tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <strong>Excel Data Validation<\/strong> \u0111\u1ec3 t\u1ea1o danh s\u00e1ch theo m\u1ee5c \u2013 lu\u00f4n t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt ngay khi b\u1ea1n th\u00eam ho\u1eb7c xo\u00e1 c\u00e1c m\u1ee5c t\u1eeb Danh s\u00e1ch ngu\u1ed3n (b\u1ea3ng t\u00ednh g\u1ed1c).<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-offset-dynamic-range.png\" alt=\"Excel OFFSET formula to create a dynamic range\" title=\"excel-offset-dynamic-range\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_OFFSET_VLOOKUP\"><\/span>H\u00e0m <strong>OFFSET &amp; VLOOKUP:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, c\u00e1c tra c\u1ee9u \u0111\u01a1n gi\u1ea3n theo chi\u1ec1u d\u1ecdc v\u00e0 ngang trong Excel \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n v\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m <strong>VLOOKUP<\/strong> <\/a>ho\u1eb7c <a href=\"http:\/\/blog.ezworkapp.com\/ham-hlookup-nen-su-dung-hlookup-hay-index-ket-hop-match-se-hay-hon.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m\u00a0<strong>HLOOKUP<\/strong><\/a>. Tuy nhi\u00ean, c\u00e1c h\u00e0m n\u00e0y c\u00f3 qu\u00e1 nhi\u1ec1u h\u1ea1n ch\u1ebf v\u00e0 th\u01b0\u1eddng l\u00e0 r\u1eafc r\u1ed1i l\u1edbn trong vi\u1ec7c t\u1ea1o c\u00f4ng th\u1ee9c tra c\u1ee9u m\u1ea1nh h\u01a1n v\u00e0 ph\u1ee9c t\u1ea1p h\u01a1n. V\u00ec v\u1eady, \u0111\u1ec3 th\u1ef1c hi\u1ec7n tra c\u1ee9u \u201cm\u1ed9t c\u00e1ch tinh vi h\u01a1n\u201d trong c\u00e1c b\u1ea3ng Excel, b\u1ea1n ph\u1ea3i t\u00ecm ki\u1ebfm c\u00e1c l\u1ef1a ch\u1ecdn thay th\u1ebf nh\u01b0 <strong><a href=\"http:\/\/blog.ezworkapp.com\/6-tinh-nang-hieu-qua-nhat-cua-ham-index-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m INDEX<\/a>, MATCH v\u00e0 OFFSET<\/strong>.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_1_Cong_thuc_OFFSET_cho_mot_Vlookup_do_ben_trai_trong_Excel\"><\/span>V\u00ed d\u1ee5 1. C\u00f4ng th\u1ee9c <strong>OFFSET<\/strong> cho m\u1ed9t <strong>Vlookup<\/strong> d\u00f2 b\u00ean tr\u00e1i trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">M\u1ed9t trong nh\u1eefng h\u1ea1n ch\u1ebf \u0111\u00e1ng k\u1ec3 nh\u1ea5t c\u1ee7a h\u00e0m Excel VLOOKUP l\u00e0 kh\u00f4ng c\u00f3 kh\u1ea3 n\u0103ng d\u00f2 \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb b\u00ean tr\u00e1i c\u1ee7a n\u00f3, c\u00f3 ngh\u0129a l\u00e0 VLOOKUP ch\u1ec9 c\u00f3 th\u1ec3 tr\u1ea3 l\u1ea1i m\u1ed9t gi\u00e1 tr\u1ecb \u1edf b\u00ean ph\u1ea3i c\u1ed9t tra c\u1ee9u.<\/p>\n<p style=\"text-align: justify\">Trong b\u1ea3ng tra c\u1ee9u m\u1eabu c\u1ee7a ch\u00fang t\u00f4i, c\u00f3 hai c\u1ed9t \u2013 t\u00ean th\u00e1ng (month) (c\u1ed9t A) v\u00e0 ti\u1ec1n th\u01b0\u1edfng (Bonus) (c\u1ed9t B). N\u1ebfu b\u1ea1n mu\u1ed1n nh\u1eadn \u0111\u01b0\u1ee3c ti\u1ec1n th\u01b0\u1edfng cho m\u1ed9t th\u00e1ng nh\u1ea5t \u0111\u1ecbnh, c\u00f4ng th\u1ee9c VLOOKUP \u0111\u01a1n gi\u1ea3n n\u00e0y s\u1ebd ho\u1ea1t \u0111\u1ed9ng m\u00e0 kh\u00f4ng g\u1eb7p tr\u1edf ng\u1ea1i:<\/p>\n<p style=\"text-align: justify\"><strong>= VLOOKUP (B1, A5: B11, 2, FALSE)<\/strong><\/p>\n<p style=\"text-align: justify\">Tuy nhi\u00ean, ngay khi b\u1ea1n tr\u00e1o \u0111\u1ed5i c\u00e1c c\u1ed9t trong b\u1ea3ng tra c\u1ee9u, \u0111i\u1ec1u n\u00e0y s\u1ebd ngay l\u1eadp t\u1ee9c d\u1eabn \u0111\u1ebfn l\u1ed7i #N\/A:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/left-vlookup.png\" alt=\"The VLOOKUP function can only return a value to the right of the lookup column.\" title=\"left-vlookup\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 x\u1eed l\u00fd m\u1ed9t tra c\u1ee9u b\u00ean tr\u00e1i, b\u1ea1n c\u1ea7n m\u1ed9t h\u00e0m linh ho\u1ea1t h\u01a1n m\u00e0 kh\u00f4ng th\u1ef1c s\u1ef1 quan t\u00e2m \u0111\u1ebfn v\u1ecb tr\u00ed c\u1ee7a c\u1ed9t \u0111\u00f3 \u1edf \u0111\u00e2u. M\u1ed9t trong nh\u1eefng gi\u1ea3i ph\u00e1p c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u00ednh l\u00e0 k\u1ebft h\u1ee3p c\u00e1c h\u00e0m INDEX v\u00e0 MATCH. M\u1ed9t c\u00e1ch l\u00e0m kh\u00e1c ch\u00ednh l\u00e0 s\u1eed d\u1ee5ng <strong>OFFSET, MATCH v\u00e0 ROWS:<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>=OFFSET(<\/strong><strong>lookup table<\/strong><strong>, MATCH(<\/strong><strong>lookup value<\/strong><strong>, OFFSET(<\/strong><strong>lookup table<\/strong><strong>, 0, 1, ROWS(<\/strong><strong>lookup table<\/strong><strong>), 1) ,0) -1, 0, 1, 1)<\/strong><\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 c\u1ee7a ch\u00fang t\u00f4i, b\u1ea3ng tra c\u1ee9u l\u00e0 A5: B9 v\u00e0 gi\u00e1 tr\u1ecb tra c\u1ee9u n\u1eb1m trong \u00f4 B1, v\u00ec v\u1eady c\u00f4ng th\u1ee9c tr\u00ean s\u1ebd tri\u1ec3n khai th\u00e0nh:<\/p>\n<p style=\"text-align: justify\"><strong>= OFFSET (A5: B9, MATCH (B1, OFFSET (A5: B9, 0, 1, ROWS (A5: B9), 1), 0) -1, 0, 1, 1)<\/strong><\/p>\n<p style=\"text-align: justify\">T\u00f4i bi\u1ebft c\u00f4ng th\u1ee9c tr\u00f4ng h\u01a1i v\u1ee5ng v\u1ec1, nh\u01b0ng n\u00f3 th\u1ef1c s\u1ef1 \u0111\u01b0\u1ee3c vi\u1ec7c \ud83d\ude42<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-offset-lookup.png\" alt=\"The OFFSET formula for a left vlookup\" title=\"excel-offset-lookup\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_2_Lam_the_nao_su_dung_Vlookup_do_ben_tren_trong_Excel\"><\/span>V\u00ed d\u1ee5 2. L\u00e0m th\u1ebf n\u00e0o s\u1eed d\u1ee5ng <strong>Vlookup<\/strong> d\u00f2 b\u00ean tr\u00ean trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Nh\u01b0 tr\u01b0\u1eddng h\u1ee3p v\u1edbi Excel <strong>Vlookup <\/strong>kh\u00f4ng th\u1ec3 d\u00f2 gi\u00e1 tr\u1ecb b\u00ean tr\u00e1i, chi\u1ec1u ngang \u2013 v\u00e0 h\u00e0m HLOOKUP \u2013 kh\u00f4ng th\u1ec3 d\u00f2 gi\u00e1 tr\u1ecb b\u00ean tr\u00ean \u0111\u1ec3 xu\u1ea5t ra m\u1ed9t gi\u00e1 tr\u1ecb.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u1ea7n qu\u00e9t m\u1ed9t h\u00e0ng ph\u00eda tr\u00ean \u0111\u1ec3 t\u00ecm m\u1ed9t gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p, c\u00f4ng th\u1ee9c OFFSET \/ MATCH \/ ROWS c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n m\u1ed9t l\u1ea7n n\u1eefa, nh\u01b0ng l\u1ea7n n\u00e0y b\u1ea1n s\u1ebd ph\u1ea3i t\u0103ng c\u01b0\u1eddng h\u00e0m COLUMNS nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=OFFSET(<\/strong><strong>lookup table<\/strong><strong>, 0, MATCH(<\/strong><strong>lookup value<\/strong><strong>, OFFSET(<\/strong><strong>lookup table<\/strong><strong>, ROWS(<\/strong><strong>lookup table<\/strong><strong>) -1, 0, 1, COLUMNS(<\/strong><strong>lookup table<\/strong><strong>)), 0) -1, 1, 1)<\/strong><\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed r\u1eb1ng b\u1ea3ng tra c\u1ee9u l\u00e0 E4: I5 v\u00e0 gi\u00e1 tr\u1ecb tra c\u1ee9u l\u00e0 trong \u00f4 E1, c\u00f4ng th\u1ee9c \u0111i nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>= OFFSET (E4: I5, 0, MATCH (E1, OFFSET (E4: I5, ROWS (E4: I5) -1, 0, 1, COLUMNS (E4: I5)), 0) -1, 1, 1)<\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/offset-hlookup.png\" alt=\"The Excel OFFSET formula for an upper lookup\" title=\"offset-hlookup\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_3_tra_cuu_hai_chieu_theo_cot_va_gia_tri_hang\"><\/span>V\u00ed d\u1ee5 3. tra c\u1ee9u hai chi\u1ec1u (theo c\u1ed9t v\u00e0 gi\u00e1 tr\u1ecb h\u00e0ng)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">Tra c\u1ee9u hai chi\u1ec1u trong Excel tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean c\u00e1c k\u1ebft qu\u1ea3 tr\u00f9ng kh\u1edbp trong c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t. V\u00e0 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng tra c\u1ee9u 2 chi\u1ec1u sau \u0111\u1ec3 t\u00ecm m\u1ed9t gi\u00e1 tr\u1ecb t\u1ea1i giao \u0111i\u1ec3m c\u1ee7a m\u1ed9t h\u00e0ng v\u00e0 c\u1ed9t y\u00eau c\u1ea7u:<\/p>\n<p style=\"text-align: justify\"><strong>=OFFSET(<\/strong><strong>lookup table<\/strong><strong>, MATCH(<\/strong><strong>row lookup value<\/strong><strong>, OFFSET(<\/strong><strong>lookup table<\/strong><strong>, 0, 0, ROWS(<\/strong><strong>lookup table<\/strong><strong>), 1), 0) -1, MATCH(<\/strong><strong>column lookup value<\/strong><strong>, OFFSET(<\/strong><strong>lookup table<\/strong><strong>, 0, 0, 1, COLUMNS(<\/strong><strong>lookup table<\/strong><strong>)), 0) -1)<\/strong><\/p>\n<p style=\"text-align: justify\">Bi\u1ebft r\u1eb1ng:<\/p>\n<ul style=\"text-align: justify\">\n<li>B\u1ea3ng tra c\u1ee9u (lookup table) l\u00e0 A5: G9<\/li>\n<li>Gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p tr\u00ean c\u00e1c h\u00e0ng l\u00e0 B2<\/li>\n<li>Gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p tr\u00ean c\u00e1c c\u1ed9t l\u00e0 B1<\/li>\n<\/ul>\n<p style=\"text-align: justify\">B\u1ea1n s\u1ebd vi\u1ebft \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c tra c\u1ee9u hai chi\u1ec1u sau \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><strong>= OFFSET (A5: G9, MATCH (B2, OFFSET (A5: G9, 0, 0, ROWS (A5: G9), 1), 0) -1, MATCH (B1, T OFFT (A5: G9, 0, 0, 1, COLUMNS (A5: G9)), 0) -1)<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u00f3 kh\u00f4ng ph\u1ea3i l\u00e0 th\u1ee9 d\u1ec5 nh\u1edb, ph\u1ea3i kh\u00f4ng? Ngo\u00e0i ra, \u0111\u00e2y l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng, do \u0111\u00f3 \u0111\u1eebng qu\u00ean nh\u1ea5n Ctrl + Shift + Enter \u0111\u1ec3 nh\u1eadp ch\u00ednh x\u00e1c d\u1eef li\u1ec7u.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/offset-double-lookup.png\" alt=\"The OFFSET formula for a two-way lookup in Excel\" title=\"offset-double-lookup\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_OFFSET_%E2%80%93_han_che_va_cac_lua_chon_thay_the\"><\/span>H\u00e0m <strong>OFFSET<\/strong> \u2013 h\u1ea1n ch\u1ebf v\u00e0 c\u00e1c l\u1ef1a ch\u1ecdn thay th\u1ebf<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Hy v\u1ecdng r\u1eb1ng c\u00e1c v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c \u0111\u00e3 l\u00e0m s\u00e1ng t\u1ecf c\u00e1ch s\u1eed d\u1ee5ng OFFSET trong Excel. Tuy nhi\u00ean, \u0111\u1ec3 t\u1eadn d\u1ee5ng hi\u1ec7u qu\u1ea3 h\u00e0m n\u00e0y trong b\u1ea3ng t\u00ednh l\u00e0m vi\u1ec7c c\u1ee7a b\u1ea1n, th\u00ec b\u1ea1n kh\u00f4ng ch\u1ec9 n\u00ean hi\u1ec3u bi\u1ebft v\u1ec1 th\u1ebf m\u1ea1nh c\u1ee7a n\u00f3, m\u00e0 c\u00f2n ph\u1ea3i c\u1ea3nh gi\u00e1c v\u1edbi nh\u1eefng h\u1ea1n ch\u1ebf c\u1ee7a n\u00f3.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Nhung_han_che_quan_trong_nhat_cua_ham_OFFSET_nhu_sau\"><\/span>Nh\u1eefng h\u1ea1n ch\u1ebf quan tr\u1ecdng nh\u1ea5t c\u1ee7a h\u00e0m <strong>OFFSET<\/strong> nh\u01b0 sau:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul style=\"text-align: justify\">\n<li>Excel <strong>OFFSET<\/strong> l\u00e0 m\u1ed9t h\u00e0m r\u1ea5t \u201ckh\u00e1t d\u1eef li\u1ec7u\u201d: B\u1ea5t k\u00ec s\u1ef1 thay \u0111\u1ed5i d\u1eef li\u1ec7u g\u1ed1c n\u00e0o, c\u00e1c c\u00f4ng th\u1ee9c OFFSET c\u1ee7a b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh l\u1ea1i, khi\u1ebfn cho Excel c\u00e0ng b\u1eadn r\u1ed9n h\u01a1n. \u0110\u00e2y kh\u00f4ng ph\u1ea3i l\u00e0 v\u1ea5n \u0111\u1ec1 cho m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u01a1n l\u1ebb trong m\u1ed9t b\u1ea3ng t\u00ednh nh\u1ecf. Nh\u01b0ng n\u1ebfu c\u00f3 h\u00e0ng ch\u1ee5c ho\u1eb7c h\u00e0ng tr\u0103m c\u00f4ng th\u1ee9c trong m\u1ed9t b\u1ea3ng t\u00ednh, Microsoft Excel c\u00f3 th\u1ec3 m\u1ea5t m\u1ed9t th\u1eddi gian \u0111\u1ec3 t\u00ednh to\u00e1n l\u1ea1i.<\/li>\n<li>Excel c\u00f4ng th\u1ee9c <strong>OFFSET<\/strong> r\u1ea5t kh\u00f3 \u0111\u1ec3 xem l\u1ea1i. B\u1edfi v\u00ec c\u00e1c tham chi\u1ebfu \u0111\u01b0\u1ee3c tr\u1ea3 l\u1ea1i b\u1edfi h\u00e0m OFFSET Excel l\u00e0 \u0111\u1ed9ng, \u0111\u1eb7c bi\u1ec7t l\u00e0 v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c l\u1edbn (\u0111\u1eb7c bi\u1ec7t v\u1edbi c\u00e1c h\u00e0m OFFSET l\u1ed3ng nhau) c\u00f3 th\u1ec3 kh\u00e1 kh\u00f3 \u0111\u1ec3 g\u1ee1 l\u1ed7i.<\/li>\n<\/ul>\n<blockquote>\n<p>Ti\u0300m hi\u00ea\u0309u th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">H\u1ecdc VBA \u1edf \u0111\u00e2u<\/a>?<\/p>\n<\/blockquote>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cac_lua_chon_thay_the_cho_viec_su_dung_OFFSET_trong_Excel\"><\/span>C\u00e1c l\u1ef1a ch\u1ecdn thay th\u1ebf cho vi\u1ec7c s\u1eed d\u1ee5ng <strong>OFFSET<\/strong> trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110i\u1ec1u n\u00e0y l\u00e0 m\u1ed9t tr\u01b0\u1eddng h\u1ee3p th\u01b0\u1eddng x\u1ea3y ra trong Excel, nh\u1eefng k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 c\u00f3 th\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c qua m\u1ed9t s\u1ed1 c\u00e1ch kh\u00e1c nhau. V\u00e0 \u0111\u00e2y l\u00e0 ba l\u1ef1a ch\u1ecdn thay th\u1ebf \u0111\u01a1n gi\u1ea3n t\u1ed1i \u01b0u cho c\u00f4ng c\u1ee5 OFFSET:<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"1_Cac_bang_trong_Excel\"><\/span>1. C\u00e1c b\u1ea3ng trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">T\u1eeb sau \u0111\u1eddi Excel 2002, ch\u00fang t\u00f4i \u0111\u00e3 c\u00f3 m\u1ed9t t\u00ednh n\u0103ng th\u1ef1c s\u1ef1 tuy\u1ec7t v\u1eddi \u2013 v\u1edbi c\u00e1c b\u1ea3ng Excel \u0111\u1ea7y \u0111\u1ee7, kh\u00e1c h\u1eb3n v\u1edbi c\u00e1c d\u1ea3i th\u00f4ng th\u01b0\u1eddng. \u0110\u1ec3 t\u1ea1o b\u1ea3ng t\u1eeb d\u1eef li\u1ec7u c\u00f3 c\u1ea5u tr\u00fac, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o <strong>Insert &gt; Table<\/strong> <strong>tr\u00ean tab Home<\/strong> (Trang ch\u1ee7) ho\u1eb7c s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl + T.<\/p>\n<p style=\"text-align: justify\">B\u1eb1ng c\u00e1ch nh\u1eadp m\u1ed9t c\u00f4ng th\u1ee9c trong m\u1ed9t \u00f4 trong m\u1ed9t b\u1ea3ng Excel, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o ra m\u1ed9t c\u1ed9t \u0111\u01b0\u1ee3c t\u00ednh t\u1ef1 \u0111\u1ed9ng v\u1edbi c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c sao ch\u00e9p cho t\u1ea5t c\u1ea3 c\u00e1c \u00f4 kh\u00e1c trong c\u1ed9t \u0111\u00f3 v\u00e0 \u0111i\u1ec1u ch\u1ec9nh cho m\u1ed7i h\u00e0ng trong b\u1ea3ng.<\/p>\n<p style=\"text-align: justify\">H\u01a1n th\u1ebf n\u1eefa, b\u1ea5t k\u1ef3 c\u00f4ng th\u1ee9c n\u00e0o tham chi\u1ebfu \u0111\u1ebfn d\u1eef li\u1ec7u c\u1ee7a b\u1ea3ng m\u00e0 c\u00f3 \u0111i\u1ec1u ch\u1ec9nh t\u1ef1 \u0111\u1ed9ng, s\u1ebd bao g\u1ed3m t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng m\u1edbi n\u00e0o b\u1ea1n th\u00eam v\u00e0o b\u1ea3ng ho\u1eb7c lo\u1ea1i tr\u1eeb c\u00e1c h\u00e0ng \u0111\u00e3 \u0111\u01b0\u1ee3c x\u00f3a. V\u1ec1 m\u1eb7t k\u1ef9 thu\u1eadt, c\u00e1c c\u00f4ng th\u1ee9c nh\u01b0 v\u1eady ho\u1ea1t \u0111\u1ed9ng tr\u00ean c\u00e1c c\u1ed9t ho\u1eb7c h\u00e0ng c\u1ee7a b\u1ea3ng, g\u1ecdi l\u00e0 nh\u1eefng d\u1ea3i \u0111\u1ed9ng. M\u1ed7i b\u1ea3ng trong m\u1ed9t b\u1ea3ng t\u00ednh c\u00f3 m\u1ed9t t\u00ean duy nh\u1ea5t (m\u1eb7c \u0111\u1ecbnh l\u00e0 Table1, Table2, \u2026) v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ed5i t\u00ean b\u1ea3ng c\u1ee7a m\u00ecnh th\u00f4ng qua tab <strong>Design&gt; Properties group&gt; Table Name<\/strong>. H\u00ecnh \u1ea3nh d\u01b0\u1edbi \u0111\u00e2y th\u1ec3 hi\u1ec7n c\u00f4ng th\u1ee9c SUM c\u00f3 tham chi\u1ebfu \u0111\u1ebfn c\u1ed9t Bonus trong B\u1ea3ng 3. H\u00e3y ch\u00fa \u00fd r\u1eb1ng c\u00f4ng th\u1ee9c n\u00e0y c\u00f3 bao g\u1ed3m t\u00ean c\u1ed9t c\u1ee7a b\u1ea3ng thay v\u00ec m\u1ed9t d\u1ea3i \u00f4.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-table.png\" alt=\"Using Excel tables instead of ranges\" title=\"excel-table\"><\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"2_Ham_INDEX\"><\/span>2. H\u00e0m INDEX<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">M\u1eb7c d\u00f9 kh\u00f4ng gi\u1ed1ng y <strong>nh\u01b0 OFFSET<\/strong>, <strong>h\u00e0m INDEX<\/strong> c\u0169ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ea1o c\u00e1c tham chi\u1ebfu cho d\u1ea3i \u0111\u1ed9ng. Kh\u00f4ng gi\u1ed1ng nh\u01b0 OFFSET, h\u00e0m INDEX kh\u00f4ng t\u1ef1 thay \u0111\u1ed5i, v\u00ec v\u1eady n\u00f3 s\u1ebd kh\u00f4ng l\u00e0m ch\u1eadm Excel c\u1ee7a b\u1ea1n.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"3_Ham_INDIRECT\"><\/span>3. H\u00e0m INDIRECT<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">S\u1eed d\u1ee5ng h\u00e0m <strong>INDIRECT<\/strong> b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o tham chi\u1ebfu cho d\u1ea3i \u0111\u1ed9ng, t\u1eeb nhi\u1ec1u ngu\u1ed3n nh\u01b0 c\u00e1c \u00f4 gi\u00e1 tr\u1ecb, gi\u00e1 tr\u1ecb v\u00e0 v\u0103n b\u1ea3n c\u1ee7a \u00f4, v\u00e0 c\u00e1c d\u1ea3i \u00f4 \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean. N\u00f3 c\u0169ng c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng tham chi\u1ebfu m\u1ed9t b\u1ea3ng t\u00ednh ho\u1eb7c m\u1ed9t trang t\u00ednh Excel. B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm th\u1ea5y t\u1ea5t c\u1ea3 c\u00e1c v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c trong h\u01b0\u1edbng d\u1eabn v\u1ec1<a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-ham-indirect-trong-excel-cong-thuc-va-vi-du-minh-hoa.html\" target=\"_blank\" rel=\"noopener noreferrer\"> <strong>h\u00e0m INDIRECT<\/strong><\/a> c\u1ee7a Excel.<\/p>\n<p style=\"text-align: justify\"><em><strong>Ngu\u1ed3<\/strong><\/em><em><strong>n:<\/strong><\/em><em>\u00a0Ablebits, d\u1ecb<\/em><em>ch v\u00e0 bi\u00ean t\u1ead<\/em><em>p b\u1edf<\/em><em>i blog.hocexcel.online<\/em><\/p>\n<p><a href=\"http:\/\/bit.ly\/2mWmtzP\" target=\"_blank\" rel=\"noopener noreferrer\">\u00a0<\/a><\/p>\n<p>Ngo\u00e0i ra \u0111\u1ec3 \u1ee9ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 th\u00ec b\u1ea1n c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel.<\/p>\n<p>M\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n th\u01b0\u1eddng g\u1eb7p nh\u01b0:<\/p>\n<ul>\n<li>SUMIF, SUMIFS \u0111\u1ec3 t\u00ednh t\u1ed5ng theo 1 \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>COUNTIF, COUNTIFS \u0111\u1ec3 th\u1ed1ng k\u00ea, \u0111\u1ebfm theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>C\u00e1c h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i, d\u1ea1ng ng\u00e0y th\u00e1ng, d\u1ea1ng s\u1ed1\u2026<\/li>\n<li>C\u00e1c h\u00e0m d\u00f2 t\u00ecm tham chi\u1ebfu Index+Match, h\u00e0m SUMPRODUCT\u2026<\/li>\n<\/ul>\n<p>M\u1ed9t s\u1ed1 c\u00f4ng c\u1ee5 hay s\u1eed d\u1ee5ng nh\u01b0:<\/p>\n<ul>\n<li>\u0110\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n v\u1edbi Conditional formatting<\/li>\n<li>Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n nh\u1eadp d\u1eef li\u1ec7u v\u1edbi Data Validation<\/li>\n<li>C\u00e1ch \u0111\u1eb7t Name v\u00e0 s\u1eed d\u1ee5ng Name trong c\u00f4ng th\u1ee9c<\/li>\n<li>L\u1eadp b\u00e1o c\u00e1o v\u1edbi Pivot Table\u2026<\/li>\n<\/ul>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w9iHbh\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\">HocExcel.Online<\/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\/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-63.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11841,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11840","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\/11840","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=11840"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11840\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11841"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11840"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11840"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}