{"id":5816,"date":"2024-12-21T08:15:33","date_gmt":"2024-12-21T08:15:33","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/excel-add-in-ham-vlookupmax-cai-tien-hoan-hao-cho-ham-vlookup\/"},"modified":"2024-12-21T08:15:33","modified_gmt":"2024-12-21T08:15:33","slug":"excel-add-in-ham-vlookupmax-cai-tien-hoan-hao-cho-ham-vlookup","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/excel-add-in-ham-vlookupmax-cai-tien-hoan-hao-cho-ham-vlookup\/","title":{"rendered":"Excel Add-in: H\u00e0m VLOOKUPMAX \u2013 C\u1ea3i ti\u1ebfn ho\u00e0n h\u1ea3o cho h\u00e0m VLOOKUP"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Ch\u1eafc h\u1eb3n c\u00e1c b\u1ea1n\u00a0\u0111\u00e3 qu\u00e1 quen thu\u1ed9c v\u1edbi h\u00e0m VLOOKUP\u00a0\u0111\u00fang kh\u00f4ng? H\u00e0m vlookup c\u00f3 th\u1ec3 n\u00f3i l\u00e0 h\u00e0m th\u00f4ng d\u1ee5ng nh\u1ea5t trong\u00a0excel, tuy nhi\u00ean h\u00e0m n\u00e0y l\u1ea1i c\u00f3 r\u1ea5t nhi\u1ec1u\u00a0\u0111i\u1ec3m h\u1ea1n ch\u1ebf m\u00e0 m\u00ecnh c\u00f3 th\u1ec3 k\u1ec3 t\u00ean ra nh\u01b0:<\/p>\n<ul>\n<li>Kh\u00f4ng t\u00ecm ki\u1ebfm\u00a0\u0111\u01b0\u1ee3c n\u1ebfu nh\u01b0 gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm (lookup_value) xu\u1ea5t hi\u1ec7n nhi\u1ec1u l\u1ea7n trong v\u00f9ng t\u00ecm ki\u1ebfm c\u1ee7a b\u1ea3ng t\u00ecm ki\u1ebfm\u00a0\u00a0(Table_Array) (hay n\u00f3i c\u00e1ch kh\u00e1c l\u00e0 1 gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm c\u00f3 nhi\u1ec1u h\u01a1n 1 k\u1ebft qu\u1ea3)<\/li>\n<li>C\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm b\u1eaft bu\u1ed9c ph\u1ea3i l\u00e0 c\u1ed9t\u00a0\u0111\u1ea7u ti\u00ean b\u00ean tr\u00e1i trong b\u1ea3ng ch\u1ee9a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm. C\u00e1c c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3 ph\u1ea3i n\u1eb1m b\u00ean ph\u1ea3i c\u1ed9t gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm.<\/li>\n<\/ul>\n<p>Nh\u1eefng h\u1ea1n ch\u1ebf n\u00e0y khi\u1ebfn cho h\u00e0m Vlookup t\u1eeb m\u1ed9t h\u00e0m d\u1ec5 s\u1eed d\u1ee5ng b\u1ed7ng tr\u1edf n\u00ean r\u1ea5t d\u1ec5 m\u1eafc l\u1ed7i v\u00e0 kh\u00f4ng\u00a0\u1ee9ng d\u1ee5ng\u00a0\u0111\u01b0\u1ee3c trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p.<\/p>\n<p>V\u00e0 gi\u1edd\u00a0\u0111\u00e2y ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 m\u1ed9t gi\u1ea3i ph\u00e1p ho\u00e0n h\u1ea3o cho h\u00e0m Vlookup,\u00a0\u0111\u00f3 l\u00e0 Add-in h\u00e0m VlookupMAX, gi\u00fap gi\u1ea3i quy\u1ebft m\u1ecdi v\u1ea5n\u00a0\u0111\u1ec1 b\u1ee9c x\u00fac m\u00e0 ch\u00fang ta g\u1eb7p ph\u1ea3i v\u1edbi h\u00e0m Vlookup.<\/p>\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y m\u00ecnh s\u1ebd n\u00f3i 2 v\u1ea5n\u00a0\u0111\u1ec1: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VlookupMAX v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng Add-in.<\/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-6766792470b60\" 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\/excel-add-ham-vlookupmax-cai-tien-hoan-hao-cho-ham-vlookup.html#1_Cach_dua_Add-in_nay_vao_Excel\" title=\"1. C\u00e1ch\u00a0\u0111\u01b0a Add-in n\u00e0y v\u00e0o\u00a0Excel\">1. C\u00e1ch\u00a0\u0111\u01b0a Add-in n\u00e0y v\u00e0o\u00a0Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/excel-add-ham-vlookupmax-cai-tien-hoan-hao-cho-ham-vlookup.html#2_Cach_su_dung_ham_VlookupMAX\" title=\"2. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VlookupMAX\">2. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VlookupMAX<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"1_Cach_dua_Add-in_nay_vao_Excel\"><\/span>1. C\u00e1ch\u00a0\u0111\u01b0a Add-in n\u00e0y v\u00e0o\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ea7u ti\u00ean c\u00e1c b\u1ea1n ph\u1ea3i t\u1ea3i Add-in n\u00e0y v\u1ec1 m\u00e1y. C\u00e1c b\u1ea1n t\u1ea3i\u00a0\u1edf link sau:<\/p>\n<p><a href=\"http:\/\/bit.ly\/2AroPvx\">Link t\u1ea3i Add-in VlookupMAX<\/a><\/p>\n<p>Sau\u00a0\u0111\u00f3 c\u00e1c b\u1ea1n m\u1edf\u00a0Excel l\u00ean, b\u1ea5m v\u00e0o tab Developer, ch\u1ecdn\u00a0Excel Add-in<\/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\/2024\/12\/vba101_92019-nho-216.gif\" title=\"vba101_92019-nho-216\"><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\/2024\/12\/ex101_92019-nho-511.gif\" title=\"ex101_92019-nho-511\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u0110\u1ec3 m\u1edf tab Developer b\u1ea1n l\u00e0m nh\u01b0 sau<\/p>\n<p>Click chu\u1ed9t ph\u1ea3i l\u00ean thanh c\u00f4ng c\u1ee5, ch\u1ecdn Customize the Ribbon.<\/p>\n<p>Trong m\u1ee5c Customize the Ribbon, b\u1ea1n\u00a0\u0111\u00e1nh d\u1ea5u ch\u1ecdn v\u00e0o tab Developer<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11783 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic0-1024x842-1.png\" width=\"1024\" height=\"842\" title=\"pic0-1024x842-1\"><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11782 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic1-1024x259-1.png\" width=\"1024\" height=\"259\" title=\"pic1-1024x259-1\"><\/p>\n<p>Khi b\u1ea5m v\u00e0o\u00a0Excel Add-ins th\u00ec ch\u01b0a c\u00f3 s\u1eb5n add-in n\u00e0y. C\u00e1c b\u1ea1n b\u1ea5m v\u00e0o n\u00fat Browse\u2026 , ch\u1ecdn n\u01a1i ch\u1ee9a file Add-in v\u1eeba download tr\u01b0\u1edbc \u0111\u00f3, b\u1ea5m ok \u0111\u1ec3 th\u00eam add-in v\u00e0o.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11784 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic2-1024x518-1.png\" width=\"1024\" height=\"518\" title=\"pic2-1024x518-1\"><\/p>\n<p>Sau khi\u00a0\u0111\u01b0a\u00a0Excel Add-in l\u00ean, ch\u00fang ta v\u00e0o Option\/Trust Center\/Trust Center setting v\u00e0 thi\u1ebft l\u1eadp\u00a0\u0111\u01b0\u1eddng d\u1eabn n\u01a1i ch\u1ee9a Add-in VlookUpMax v\u00e0o\u00a0 ph\u1ea7n Trusted locations c\u1ee7a\u00a0Excel, gi\u00fap cho Add-in lu\u00f4n ho\u1ea1t\u00a0\u0111\u1ed9ng\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11843 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic6-1-1.png\" width=\"1679\" height=\"686\" title=\"pic6-1-1\"><\/p>\n<p>L\u01b0u\u00a0\u00fd: Khi thay\u00a0\u0111\u1ed5i\u00a0\u0111\u01b0\u1eddng d\u1eabn\u00a0\u0111\u1ebfn Add-in th\u00ec c\u00e1c b\u1ea1n c\u1ea7n thi\u1ebft l\u1eadp l\u1ea1i\u00a0\u0111\u01b0\u1eddng d\u1eabn v\u00e0o\u00a0 m\u1ee5c Trusted Locations<\/p>\n<p>Nh\u01b0 v\u1eady l\u00e0 ch\u00fang ta \u0111\u00e3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c h\u00e0m VlookupMAX r\u1ed3i. B\u00e2y gi\u1edd c\u00f9ng t\u00ecm hi\u1ec3u c\u1ea5u tr\u00fac c\u1ee7a h\u00e0m n\u00e0y nh\u00e9:<\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_Cach_su_dung_ham_VlookupMAX\"><\/span>2. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m VlookupMAX<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11786 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/23406009_10203981241047566_3522506946704125883_o.jpg\" width=\"1343\" height=\"541\" title=\"23406009_10203981241047566_3522506946704125883_o\"><\/p>\n<p style=\"text-align: center\">(Ngu\u1ed3n:\u00a0Excel for Freelancers Group)<\/p>\n<p>=VLOOKUP(Lookup Value, Lookup in Range, column no for lookup, column no\u00a0of data required,0,0)<\/p>\n<p>Lookup Value: l\u00e0 gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm (gi\u1ed1ng vlookup)<\/p>\n<p>Lookup in Range: l\u00e0 v\u00f9ng t\u00ecm ki\u1ebfm (gi\u1ed1ng Table_array c\u1ee7a vlookup, nh\u01b0ng kh\u00f4ng b\u1eaft bu\u1ed9c Lookup_value ph\u1ea3i n\u1eb1m trong c\u1ed9t\u00a0\u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng)<\/p>\n<p>Column no for lookup: (m\u1edbi) l\u00e0 <strong><em>th\u1ee9 t\u1ef1 c\u1ed9t ch\u1ee9a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm<\/em><\/strong> trong V\u00f9ng\u00a0t\u00ecm ki\u1ebfm\u00a0(t\u00ednh t\u1eeb c\u1ed9t\u00a0\u0111\u1ea7u ti\u00ean b\u00ean tr\u00e1i trong v\u00f9ng Lookup in Range).<\/p>\n<p>Column no\u00a0of data required: (m\u1edbi) l\u00e0 <strong><em>th\u1ee9 t\u1ef1 c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm<\/em><\/strong> trong V\u00f9ng t\u00ecm ki\u1ebfm\u00a0(t\u00ednh t\u1eeb c\u1ed9t\u00a0\u0111\u1ea7u ti\u00ean b\u00ean tr\u00e1i trong v\u00f9ng Lookup in Range).<\/p>\n<p>Gi\u00e1 tr\u1ecb o th\u1ee9 nh\u1ea5t: l\u00e0 gi\u1edbi h\u1ea1n\u00a0\u0111\u1ea7u hay cu\u1ed1i c\u1ee7a k\u1ebft qu\u1ea3 t\u00ecm\u00a0\u0111\u01b0\u1ee3c trong V\u00f9ng t\u00ecm ki\u1ebfm<\/p>\n<ul>\n<li>=0 : Kh\u00f4ng gi\u1edbi h\u1ea1n s\u1ed1 k\u1ebft qu\u1ea3 t\u00ecm\u00a0\u0111\u01b0\u1ee3c<\/li>\n<li>=1:\u00a0Gi\u1edbi h\u1ea1n nh\u1eefng gi\u00e1 tr\u1ecb t\u00ecm\u00a0\u0111\u01b0\u1ee3c theo th\u1ee9 t\u1ef1 t\u1eeb tr\u00ean xu\u1ed1ng<\/li>\n<li>=2:\u00a0Gi\u1edbi h\u1ea1n nh\u1eefng gi\u00e1 tr\u1ecb t\u00ecm\u00a0\u0111\u01b0\u1ee3c theo th\u1ee9 t\u1ef1 t\u1eeb d\u01b0\u1edbi l\u00ean<\/li>\n<\/ul>\n<p>Gi\u00e1 tr\u1ecb 0 th\u1ee9 hai: l\u00e0 gi\u1edbi h\u1ea1n s\u1ed1 k\u1ebft qu\u1ea3 t\u00ecm\u00a0\u0111\u01b0\u1ee3c<\/p>\n<ul>\n<li>=0: Kh\u00f4ng gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng k\u1ebft qu\u1ea3 t\u00ecm\u00a0\u0111\u01b0\u1ee3c<\/li>\n<li>= s\u1ed1 b\u1ea5t k\u1ef3: gi\u1edbi h\u1ea1n t\u1edbi s\u1ed1 l\u01b0\u1ee3ng k\u1ebft qu\u1ea3\u00a0\u0111\u00f3.<\/li>\n<\/ul>\n<p>Ch\u00fang ta x\u00e9t v\u00ed d\u1ee5\u00a0\u0111\u1ec3 hi\u1ec3u:<\/p>\n<p>V\u00ed d\u1ee5 1: l\u00e0m r\u00f5 2 th\u00e0nh ph\u1ea7n cu\u1ed1i c\u1ee7a h\u00e0m<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11789 size-large aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic5-1024x268-1.png\" width=\"1024\" height=\"268\" title=\"pic5-1024x268-1\"><\/p>\n<p>\u00a0<\/p>\n<p>K\u1ebft qu\u1ea3\u00a0\u00f4 E2:<\/p>\n<ul>\n<li>M\u00e3 A c\u00f3 5 k\u1ebft qu\u1ea3\u00a0\u1edf c\u1ed9t s\u1ed1 l\u01b0\u1ee3ng, t\u01b0\u01a1ng\u00a0\u1ee9ng l\u00e0 2 ; 5 ; 4 ; 10 ; 14<\/li>\n<li>C\u1ed9t ch\u1ee9a m\u00e3 A l\u00e0 c\u1ed9t th\u1ee9 2\u00a0\u1edf trong v\u00f9ng b\u1ea3ng t\u1eeb A2:C10 (c\u1ed9t ch\u1ee9a Lookup_value\u00a0\u1edf gi\u1eefa c\u1ee7a v\u00f9ng t\u00ecm ki\u1ebfm)<\/li>\n<li>C\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3 s\u1ed1 l\u01b0\u1ee3ng l\u00e0 c\u1ed9t th\u1ee9 3\u00a0\u1edf trong v\u00f9ng b\u1ea3ng t\u1eeb A2:C10 (b\u00ean ph\u1ea3i c\u1ed9t ch\u1ee9a lookup_value)<\/li>\n<li>2 gi\u00e1 tr\u1ecb cu\u1ed1i c\u1ee7a h\u00e0m\u00a0\u0111\u1ec1u l\u00e0 0 \u0111\u1ec3 kh\u00f4ng gi\u1edbi h\u1ea1n c\u00e1c k\u1ebft qu\u1ea3 t\u00ecm\u00a0\u0111\u01b0\u1ee3c.<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3\u00a0\u00f4 E3<\/p>\n<ul>\n<li>C\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3 C\u00f4ng ty l\u00e0 c\u1ed9t th\u1ee9 1\u00a0\u1edf trong v\u00f9ng b\u1ea3ng t\u1eeb A2:C10 (c\u1ed9t ch\u1ee9a lookup_value\u00a0\u1edf b\u00ean ph\u1ea3i, c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm\u00a0\u1edf b\u00ean tr\u00e1i)<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3\u00a0\u00f4 E4<\/p>\n<ul>\n<li>Gi\u1edbi h\u1ea1n k\u1ebft qu\u1ea3\u00a0\u0111\u1ea7u \/ cu\u1ed1i: s\u1ed1 1 l\u00e0 gi\u1edbi h\u1ea1n\u00a0\u0111\u1ea7u, x\u00e9t t\u1eeb tr\u00ean xu\u1ed1ng, tr\u1ea3 v\u1ec1 s\u1ed1 k\u1ebft qu\u1ea3 l\u00e0 2<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3\u00a0\u00f4 E5<\/p>\n<ul>\n<li>Gi\u1edbi h\u1ea1n k\u1ebft qu\u1ea3\u00a0\u0111\u1ea7u \/ cu\u1ed1i: s\u1ed1\u00a02 l\u00e0 gi\u1edbi h\u1ea1n\u00a0cu\u1ed1i, x\u00e9t t\u1eeb\u00a0d\u01b0\u1edbi l\u00ean, tr\u1ea3 v\u1ec1 s\u1ed1 k\u1ebft qu\u1ea3 l\u00e0 2<\/li>\n<\/ul>\n<p>\u2014<\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 t\u00ecm hi\u1ec3u xong v\u1ec1 h\u00e0m VlookupMAX v\u00e0 c\u00e1ch\u00a0\u0111\u1ec3\u00a0\u0111\u01b0a Add-in n\u00e0y v\u00e0o\u00a0excel\u00a0\u0111\u1ec3 s\u1eed d\u1ee5ng. Gi\u1edd\u00a0\u0111\u00e2y vi\u1ec7c truy v\u1ea5n b\u1eb1ng Vlookup ch\u01b0a bao gi\u1edd d\u1ec5 d\u00e0ng v\u00e0 m\u1ea1nh m\u1ebd\u00a0\u0111\u1ebfn v\u1eady.<\/p>\n<p>C\u1ea3m\u00a0\u01a1n c\u00e1c b\u1ea1n\u00a0\u0111\u00e3 ch\u00fa\u00a0\u00fd theo d\u00f5i.<\/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\/2024\/12\/vba101_92019-nho-216.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5817,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5816","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5816","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=5816"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5816\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5817"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5816"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5816"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}