{"id":4143,"date":"2024-12-04T10:23:33","date_gmt":"2024-12-04T10:23:33","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/cach-group-doi-tuong-su-dung-fuzzy-matching-trong-power-query\/"},"modified":"2024-12-04T10:23:33","modified_gmt":"2024-12-04T10:23:33","slug":"cach-group-doi-tuong-su-dung-fuzzy-matching-trong-power-query","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/cach-group-doi-tuong-su-dung-fuzzy-matching-trong-power-query\/","title":{"rendered":"C\u00e1ch group \u0111\u1ed1i t\u01b0\u1ee3ng s\u1eed d\u1ee5ng Fuzzy Matching trong Power Query"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-h4k0Fa0I#1\">\n<p><em>Trong b\u00e0i vi\u1ebft n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a> <\/strong>s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n m\u1ed9t c\u00e1ch \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c d\u1eef li\u1ec7u \u201cna n\u00e1\u201d nhau b\u1eb1ng t\u00ednh n\u0103ng Fuzzy Matching trong Power Query, nh\u1eb1m m\u1ee5c \u0111\u00edch Group c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng l\u1ea1i ph\u1ee5c v\u1ee5 cho c\u00e1c report.<\/em><\/p>\n<p><em>(M\u1ed9t b\u00e0i vi\u1ebft kh\u00e1c \u0111\u1ec3 tham kh\u1ea3o v\u00e0 hi\u1ec3u r\u00f5 h\u01a1n: <a href=\"http:\/\/blog.ezworkapp.com\/sanh-chuoi-tim-chuoi-gan-dung-trong-excel.html\">Levenshtein Distance trong VBA \u2013 t\u00ecm chu\u1ed7i g\u1ea7n \u0111\u00fang<\/a>)<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-67502da47f497\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/group-doi-tuong-fuzzy-matching-trong-power-query.html#%E2%80%9CLoi%E2%80%9D_ki_tu_%E2%80%93_%E2%80%9Cloi%E2%80%9D_bo_go\" title=\"\u201cL\u1ed7i\u201d k\u00ed t\u1ef1 \u2013 \u201cl\u1ed7i\u201d b\u1ed9 g\u00f5?\">\u201cL\u1ed7i\u201d k\u00ed t\u1ef1 \u2013 \u201cl\u1ed7i\u201d b\u1ed9 g\u00f5?<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/group-doi-tuong-fuzzy-matching-trong-power-query.html#Fuzzy_matching_trong_Power_Query_tim_kiem_va_nhom_cac_gia_tri_gan_giong_nhau\" title=\"Fuzzy matching trong Power Query t\u00ecm ki\u1ebfm v\u00e0 nh\u00f3m c\u00e1c gi\u00e1 tr\u1ecb g\u1ea7n gi\u1ed1ng nhau\">Fuzzy matching trong Power Query t\u00ecm ki\u1ebfm v\u00e0 nh\u00f3m c\u00e1c gi\u00e1 tr\u1ecb g\u1ea7n gi\u1ed1ng nhau<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E2%80%9CLoi%E2%80%9D_ki_tu_%E2%80%93_%E2%80%9Cloi%E2%80%9D_bo_go\"><\/span>\u201cL\u1ed7i\u201d k\u00ed t\u1ef1 \u2013 \u201cl\u1ed7i\u201d b\u1ed9 g\u00f5?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi vi\u1ebft b\u00e0i n\u00e0y, m\u00ecnh \u0111ang l\u00e0m m\u1ed9t b\u00e1o c\u00e1o. M\u00ecnh c\u1ea7n th\u1ed1ng k\u00ea d\u1eef li\u1ec7u c\u1ee7a c\u00e1c t\u1ec9nh, nh\u01b0ng khi group \u0111\u1ed1i t\u01b0\u1ee3ng th\u00ec c\u00f3 v\u1ea5n \u0111\u1ec1 nh\u01b0 sau:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"419\" height=\"450\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fuzzy-matching-pq-1.png\" class=\"wp-image-33937\" title=\"fuzzy-matching-pq-1\"><\/figure>\n<\/div>\n<p>B\u1eb1ng m\u1ed9t c\u00e1ch n\u00e0o \u0111\u00f3, t\u00ean c\u1ee7a c\u00e1c t\u1ec9nh b\u1ecb nh\u00e2n \u0111\u00f4i\u00a0<em>(duplicate),\u00a0<\/em>d\u00f9 trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n, c\u00e1c \u0111\u1ed3ng \u0111\u1ed9i c\u1ee7a m\u00ecnh \u0111\u00e3 s\u1eed d\u1ee5ng h\u00e0m COUNTIF \u0111\u1ec3 \u0111\u1ebfm t\u1ec9nh, v\u00e0 d\u1eef li\u1ec7u tr\u1ea3 v\u1ec1 v\u1eabn ch\u00ednh x\u00e1c.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"487\" height=\"126\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fuzzy-matching-pq-12.png\" class=\"wp-image-33951\" title=\"fuzzy-matching-pq-12\"><\/figure>\n<\/div>\n<blockquote class=\"wp-block-quote\">\n<p><strong>B\u00e0i h\u1ecdc r\u00fat ra<\/strong>: N\u00ean xem x\u00e9t khi d\u00f9ng COUNTIF v\u1edbi d\u1eef li\u1ec7u Text.<\/p>\n<\/blockquote>\n<p>Khi \u0111\u00f3, m\u00ecnh \u0111\u00e3 \u0111\u01b0a d\u1eef li\u1ec7u l\u00ean Diff Checker (<em><a href=\"https:\/\/www.diffchecker.com\/diff\">Computed Diff \u2013 Diff Checker<\/a>)<\/em> \u0111\u1ec3 ki\u1ec3m tra. V\u00e0 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 th\u1ec3 hi\u1ec7n \u1edf h\u00ecnh d\u01b0\u1edbi:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"308\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fuzzy-matching-pq-2-1024x308-1.png\" class=\"wp-image-33938\" title=\"fuzzy-matching-pq-2-1024x308-1\"><\/figure>\n<\/div>\n<p>V\u1eady l\u00e0 r\u00f5 r\u00e0ng \u0111\u00e3 c\u00f3 m\u1ed9t s\u1ef1 kh\u00e1c bi\u1ec7t n\u00e0o \u0111\u00f3 gi\u1eefa 2 t\u1eeb \u201cH\u1ea3i\u201d. M\u00ecnh \u0111o\u00e1n r\u1eb1ng s\u1ebd c\u00f3 th\u1ec3 t\u00ecm ra nguy\u00ean nh\u00e2n ch\u00ednh x\u00e1c h\u01a1n b\u1eb1ng c\u00e1ch b\u00f3c t\u00e1ch k\u00ed t\u1ef1.<\/p>\n<p>\u0110\u1ea7u ti\u00ean, m\u00ecnh th\u1eed ki\u1ec3m tra v\u1edbi m\u1ed9t h\u00e0m \u201cch\u00ednh x\u00e1c h\u01a1n\u201d so v\u1edbi ph\u01b0\u01a1ng th\u1ee9c COUNTIF th\u01b0\u1eddng s\u1eed d\u1ee5ng:\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/38-%e2%97%8f-cac-ham-xu-ly-chuoi-ki-tu-trong-excel.html\">H\u00e0m EXACT<\/a>.\u00a0<\/strong>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 kh\u00f4ng ngo\u00e0i d\u1ef1 \u0111o\u00e1n: FALSE<\/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-331.gif\" title=\"ex101_92019-nho-331\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"382\" height=\"120\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fuzzy-matching-pq-3.png\" class=\"wp-image-33940\" title=\"fuzzy-matching-pq-3\"><\/figure>\n<\/div>\n<p>M\u1ed9t ph\u01b0\u01a1ng ph\u00e1p kh\u00e1c \u0111\u1ec3 ki\u1ec3m tra: S\u1eed d\u1ee5ng SEARCH.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"452\" height=\"91\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fuzzy-matching-pq-13.png\" class=\"wp-image-33953\" title=\"fuzzy-matching-pq-13\"><\/figure>\n<\/div>\n<blockquote class=\"wp-block-quote\">\n<p><strong>B\u00e0i h\u1ecdc r\u00fat ra<\/strong>: S\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/38-%e2%97%8f-cac-ham-xu-ly-chuoi-ki-tu-trong-excel.html\">c\u00e1c h\u00e0m x\u1eed l\u00fd chu\u1ed7i k\u00ed t\u1ef1<\/a> s\u1ebd t\u1ed1t h\u01a1n<\/p>\n<\/blockquote>\n<p>B\u01b0\u1edbc ti\u1ebfp theo l\u00e0 b\u00f3c t\u00e1ch. M\u00ecnh \u0111o\u00e1n r\u1eb1ng, s\u1ef1 kh\u00e1c bi\u1ec7t n\u1eb1m \u1edf t\u1eeb \u201c\u1ea3\u201d, v\u00ec th\u1ebf m\u00ecnh \u0111\u00e3 s\u1eed d\u1ee5ng h\u00e0m UNICODE \u0111\u1ec3 ki\u1ec3m tra.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"534\" height=\"112\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fuzzy-matching-pq-4.png\" class=\"wp-image-33941\" title=\"fuzzy-matching-pq-4\"><\/figure>\n<\/div>\n<p>V\u1eady l\u00e0 \u0111\u00e3 r\u00f5! C\u00f3 l\u1ebd nguy\u00ean nh\u00e2n \u1edf \u0111\u00e2y l\u00e0 do b\u1ed9 g\u00f5, c\u00e1ch b\u1ecf d\u1ea5u kh\u00e1c nhau n\u00ean \u0111\u00e3 x\u1ea3y ra v\u1ea5n \u0111\u1ec1.<\/p>\n<p>V\u1eady l\u00e0m sao \u0111\u1ec3 s\u1eeda v\u1ea5n \u0111\u1ec1 n\u00e0y?<\/p>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Fuzzy_matching_trong_Power_Query_tim_kiem_va_nhom_cac_gia_tri_gan_giong_nhau\"><\/span>Fuzzy matching trong Power Query t\u00ecm ki\u1ebfm v\u00e0 nh\u00f3m c\u00e1c gi\u00e1 tr\u1ecb g\u1ea7n gi\u1ed1ng nhau<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><em>T\u1ea1i th\u1eddi \u0111i\u1ec3m vi\u1ebft b\u00e0i, kh\u00f4ng r\u00f5 t\u1ea1i sao h\u00e0m Table.FuzzyGroup c\u0169ng nh\u01b0 t\u00ednh n\u0103ng Group By v\u1edbi Fuzzy Matching ng\u1eebng ho\u1ea1t \u0111\u1ed9ng. B\u1edfi v\u1eady, m\u00ecnh \u0111\u00e3 s\u1eed d\u1ee5ng m\u1ed9t c\u00e1ch kh\u00e1c \u0111i \u0111\u01b0\u1eddng d\u00e0i h\u01a1n.\u00a0<strong>C\u00e1c b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 x\u1eed l\u00fd nhanh g\u1ecdn h\u01a1n b\u1eb1ng vi\u1ec7c ch\u1ecdn Group =&gt; ch\u1ecdn t\u00ednh n\u0103ng Fuzzy Grouping c\u00f3 s\u1eb5n.<\/strong><\/em><\/p>\n<p>\u0110\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u n\u00e0y, m\u00ecnh \u0111\u00e3 c\u00f3 \u00fd \u0111\u1ecbnh s\u1ebd Find &amp; Replace, nh\u01b0ng b\u1ecf \u0111i ngay sau \u0111\u00f3 v\u00ec kh\u00f4ng ch\u1ec9 c\u00f3 h\u01a1n 60 t\u1ec9nh th\u00e0nh m\u00e0 c\u00f2n r\u1ea5t nhi\u1ec1u d\u1eef li\u1ec7u nh\u1ecf h\u01a1n \u1edf c\u00e1c c\u1ea5p Qu\u1eadn\/huy\u1ec7n, Ph\u01b0\u1eddng\/X\u00e3 b\u1ecb sai. Thay v\u00e0o \u0111\u00f3, m\u00ecnh \u0111\u00e3 t\u00ecm ki\u1ebfm tr\u00ean web c\u0169ng nh\u01b0 tr\u00ean google, v\u00e0 m\u00ecnh ch\u1ee3t nh\u1edb ra b\u00e0i vi\u1ebft c\u1ee7a anh Thanh v\u1ec1 m\u1ed9t v\u1ea5n \u0111\u1ec1 t\u01b0\u01a1ng t\u1ef1: <a href=\"http:\/\/blog.ezworkapp.com\/sanh-chuoi-tim-chuoi-gan-dung-trong-excel.html\">SO S\u00c1NH CHU\u1ed6I, T\u00ccM CHU\u1ed6I G\u1ea6N \u0110\u00daNG TRONG EXCEL<\/a>.<\/p>\n<p>C\u00f3 ch\u0103ng l\u00e0, m\u00ecnh s\u1ebd kh\u00f4ng s\u1eed d\u1ee5ng c\u00e1ch \u0111\u00f3, m\u00e0 \u201cm\u01b0\u1ee3n\u201d Fuzzy Matching trong Power Query \u0111\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1.<\/p>\n<p>C\u00e1c b\u01b0\u1edbc m\u00ecnh l\u00e0m, c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n<p>1. \u0110\u1ea9y d\u1eef li\u1ec7u v\u00e0o trong Excel, format d\u01b0\u1edbi d\u1ea1ng Table \u0111\u1ec3 d\u1ec5 x\u1eed l\u00fd<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"355\" height=\"463\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fuzzy-matching-pq-5.png\" class=\"wp-image-33942\" title=\"fuzzy-matching-pq-5\"><\/figure>\n<\/div>\n<p>2. \u0110\u1ea9y d\u1eef li\u1ec7u v\u00e0o trong Power Query<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"439\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fuzzy-matching-pq-6-1024x439-1.png\" class=\"wp-image-33943\" title=\"fuzzy-matching-pq-6-1024x439-1\"><\/figure>\n<\/div>\n<p>3. S\u1eed d\u1ee5ng t\u00ednh n\u0103ng\u00a0<em>Merge Queries\u00a0<\/em>v\u1edbi\u00a0<strong>Fuzzy matching<\/strong><\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"702\" height=\"637\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fuzzy-matching-pq-7.png\" class=\"wp-image-33944\" title=\"fuzzy-matching-pq-7\"><\/figure>\n<\/div>\n<p>4. T\u1ea1o m\u1ed9t Custom Column \u0111\u1ec3 l\u1ea5y \u00f4 \u0111\u1ea7u ti\u00ean trong d\u1eef li\u1ec7u self-merge sau \u0111\u00f3 Expand Column<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"693\" height=\"434\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fuzzy-matching-pq-8.png\" class=\"wp-image-33945\" title=\"fuzzy-matching-pq-8\"><\/figure>\n<\/div>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"424\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fuzzy-matching-pq-9-1024x424-1.png\" class=\"wp-image-33946\" title=\"fuzzy-matching-pq-9-1024x424-1\"><\/figure>\n<\/div>\n<p>5. X\u00f3a c\u1ed9t c\u0169, gi\u1eef c\u1ed9t m\u1edbi, ti\u1ebfn h\u00e0nh <strong>Group\u00a0<\/strong>v\u1edbi\u00a0Operation\u00a0<strong>All rows.<\/strong><\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"441\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fuzzy-matching-pq-10-1024x441-1.png\" class=\"wp-image-33947\" title=\"fuzzy-matching-pq-10-1024x441-1\"><\/figure>\n<\/div>\n<p>6. K\u1ebft qu\u1ea3:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"503\" height=\"358\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fuzzy-matching-pq-11.png\" class=\"wp-image-33948\" title=\"fuzzy-matching-pq-11\"><\/figure>\n<\/div>\n<p>V\u1eady l\u00e0 c\u00e1c d\u1eef li\u1ec7u \u0111\u00e3 kh\u00f4ng c\u00f2n \u201csai\u201d n\u1eefa.<\/p>\n<p>_____________<br \/>Kh\u00f4ng bi\u1ebft \u1ee9ng d\u1ee5ng \u201chay ho\u201d n\u00e0y c\u1ee7a Power Query c\u00f3 khi\u1ebfn c\u00e1c b\u1ea1n \u2013 nh\u1eefng ng\u01b0\u1eddi \u0111\u1ecdc \u2013 c\u1ea3m th\u1ea5y h\u1ee9ng th\u00fa ch\u01b0a? \u0110\u1ec3 hi\u1ec3u nhi\u1ec1u h\u01a1n v\u1ec1 Power Query c\u0169ng nh\u01b0 \u1ee9ng d\u1ee5ng c\u1ee7a n\u00f3, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecdc th\u00eam c\u00e1c b\u00e0i vi\u1ebft t\u1ea1i blog.hocexcel.online v\u1ec1 ch\u1ee7 \u0111\u1ec1 Power Query, ch\u1eb3ng h\u1ea1n nh\u01b0 b\u00e0i vi\u1ebft n\u00e0y:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/tim-hieu-ve-power-query.html\">T\u00ecm hi\u1ec3u v\u1ec1 Power Query \u2013 H\u1ecdc Excel Online Mi\u1ec5n Ph\u00ed (hocexcel.online)<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/power-query-la-gi.html\">Power Query l\u00e0 g\u00ec? \u2013 H\u1ecdc Excel Online Mi\u1ec5n Ph\u00ed \u2013 \u1ee8ng d\u1ee5ng Power Query (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\/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-331.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4144,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4143","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\/4143","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=4143"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4143\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4144"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}