{"id":1564,"date":"2024-12-02T05:26:08","date_gmt":"2024-12-02T05:26:08","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-so-sanh-hai-cot-du-lieu-trong-excel-de-xoa-highlight-to-mau-du-lieu-trung-lap\/"},"modified":"2024-12-02T05:26:08","modified_gmt":"2024-12-02T05:26:08","slug":"cach-so-sanh-hai-cot-du-lieu-trong-excel-de-xoa-highlight-to-mau-du-lieu-trung-lap","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-so-sanh-hai-cot-du-lieu-trong-excel-de-xoa-highlight-to-mau-du-lieu-trung-lap\/","title":{"rendered":"C\u00e1ch so s\u00e1nh hai c\u1ed9t d\u1eef li\u1ec7u trong Excel \u0111\u1ec3 x\u00f3a, highlight, t\u00f4 m\u00e0u d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"so-s\u00e1nh-hai-c\u1ed9t-trong-excel\" cite=\"https:\/\/blog.hocexcel.online\/cach-so-sanh-hai-cot-du-lieu-trong-excel-de-xoa-highligh-to-mau-du-lieu-trung-lap.html?so-sanh-hai-cot-trong-excel\">\n<p style=\"text-align: justify\">C\u00e1ch <strong>so s\u00e1nh hai c\u1ed9t d\u1eef li\u1ec7u trong Excel<\/strong> \u0111\u1ec3 x\u00f3a, highlight, t\u00f4 m\u00e0u d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p la\u0300 m\u00f4\u0323t trong nh\u01b0\u0303ng c\u00e2u ho\u0309i \u0111ang \u0111\u01b0\u01a1\u0323c r\u00e2\u0301t nhi\u00ea\u0300u ba\u0323n quan t\u00e2m cu\u0303ng nh\u01b0 g\u01b0\u0309i c\u00e2u ho\u0309i v\u00ea\u0300 cho chu\u0301ng t\u00f4i. V\u01a1\u0301i ba\u0300i vi\u00ea\u0301t na\u0300y, Blog <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">h\u1ecdc excel c\u01a1 ba\u0309n online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch so s\u00e1nh hai c\u1ed9t Excel tr\u00f9ng l\u1eb7p v\u00e0 x\u00f3a ho\u1eb7c highlight nh\u1eefng ph\u1ea7n tr\u00f9ng l\u1eb7p \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y.<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/compare-2-columns-mark-duplicates.png\" alt=\"Compare two columns and find duplicates using Excel formulas\" title=\"compare-2-columns-mark-duplicates\"><\/p>\n<p style=\"text-align: justify\">Excel l\u00e0 m\u1ed9t \u1ee9ng d\u1ee5ng r\u1ea5t m\u1ea1nh v\u00e0 th\u1ef1c s\u1ef1 tuy\u1ec7t v\u1eddi \u0111\u1ec3 t\u1ea1o v\u00e0 x\u1eed l\u00fd c\u00e1c m\u1ea3ng d\u1eef li\u1ec7u l\u1edbn. B\u00e2y gi\u1edd, b\u1ea1n c\u00f3 r\u1ea5t nhi\u1ec1u b\u1ea3ng t\u00ednh v\u00e0 d\u1eef li\u1ec7u, ho\u1eb7c c\u00f3 th\u1ec3 ch\u1ec9 l\u00e0 m\u1ed9t b\u1ea3ng t\u00ednh r\u1ea5t l\u1edbn, b\u1ea1n mu\u1ed1n so s\u00e1nh 2 c\u1ed9t \u0111\u1ec3 t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eafp v\u00e0 thao t\u00e1c tr\u00ean nh\u1eefng ph\u1ea7n l\u1eb7p \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y, v\u00ed d\u1ee5 x\u00f3a h\u00e0ng b\u1ecb tr\u00f9ng, t\u00f4 m\u00e0u ph\u1ea7n tr\u00f9ng ho\u1eb7c x\u00f3a n\u1ed9i dung c\u1ee7a \u00f4 b\u1ecb tr\u00f9ng. Hai c\u1ed9t n\u00e0y c\u00f3 th\u1ec3 n\u1eb1m trong m\u1ed9t b\u1ea3ng, li\u1ec1n k\u1ec1 ho\u1eb7c kh\u00f4ng li\u1ec1n k\u1ec1, ho\u1eb7c ch\u00fang c\u00f3 th\u1ec3 n\u1eb1m trong 2 trang t\u00ednh kh\u00e1c nhau, th\u1eadm ch\u00ed l\u00e0 hai b\u1ea3ng t\u00ednh kh\u00e1c nhau.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 2 c\u1ed9t t\u00ean ng\u01b0\u1eddi \u2013 5 t\u00ean trong c\u1ed9t A v\u00e0 3 t\u00ean trong c\u1ed9t B. B\u1ea1n mu\u1ed1n so s\u00e1nh d\u1eef li\u1ec7u gi\u1eefa hai c\u1ed9t n\u00e0y \u0111\u1ec3 t\u00ecm c\u00e1c t\u00ean b\u1ecb tr\u00f9ng l\u1eafp. \u0110\u00e2y ch\u1ec9 l\u00e0 v\u00ed d\u1ee5. Trong c\u00e1c b\u1ea3ng t\u00ednh th\u1ef1c, d\u1eef li\u1ec7u \u0111\u1ec3 so s\u00e1nh th\u01b0\u1eddng c\u00f3 h\u00e0ng ng\u00e0n, h\u00e0ng v\u1ea1n m\u1ee5c.<\/p>\n<p style=\"text-align: justify\"><strong>Tr\u01b0\u1eddng h\u1ee3p A:<\/strong> C\u1ea3 hai c\u1ed9t \u0111\u1ec1u trong m\u1ed9t trang t\u00ednh, c\u00f9ng m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u: C\u1ed9t A v\u00e0 c\u1ed9t B.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/compare-2columns-same-worksheet.png\" alt=\"Both columns are located on one sheet\" title=\"compare-2columns-same-worksheet\"><\/p>\n<p style=\"text-align: justify\"><strong>Tr\u01b0\u1eddng h\u1ee3p B<\/strong>: Hai c\u1ed9t \u0111\u01b0\u1ee3c \u0111\u1eb7t tr\u00ean hai trang t\u00ednh kh\u00e1c nhau: c\u1ed9t A trong Sheet2 v\u00e0 c\u1ed9t A trong Sheet3.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/compare-columns-separate-worksheets.png\" alt=\"Two columns are located on different sheets\" title=\"compare-columns-separate-worksheets\"><\/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<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-113.gif\" title=\"ex101_92019-nho-113\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><label for=\"ez-toc-cssicon-toggle-item-674d44ef79ea7\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-so-sanh-hai-cot-du-lieu-trong-excel-de-xoa-highligh-to-mau-du-lieu-trung-lap.html#So_sanh_hai_cot_de_tim_gia_tri_trung_bang_cong_thuc\" title=\"So s\u00e1nh hai c\u1ed9t \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb tr\u00f9ng b\u1eb1ng c\u00f4ng th\u1ee9c:\">So s\u00e1nh hai c\u1ed9t \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb tr\u00f9ng b\u1eb1ng c\u00f4ng th\u1ee9c:<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-so-sanh-hai-cot-du-lieu-trong-excel-de-xoa-highligh-to-mau-du-lieu-trung-lap.html#Xu_ly_cac_gia_tri_trung_lap_duoc_tim_thay\" title=\"X\u1eed l\u00fd c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eafp \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y:\">X\u1eed l\u00fd c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eafp \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y:<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/cach-so-sanh-hai-cot-du-lieu-trong-excel-de-xoa-highligh-to-mau-du-lieu-trung-lap.html#Chi_hien_thi_hang_bi_trung_trong_cot_A\" title=\"Ch\u1ec9 hi\u1ec3n th\u1ecb h\u00e0ng b\u1ecb tr\u00f9ng trong c\u1ed9t A:\">Ch\u1ec9 hi\u1ec3n th\u1ecb h\u00e0ng b\u1ecb tr\u00f9ng trong c\u1ed9t A:<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/cach-so-sanh-hai-cot-du-lieu-trong-excel-de-xoa-highligh-to-mau-du-lieu-trung-lap.html#To_mau_hoac_highlight_nhung_gia_tri_trung_tim_thay\" title=\"T\u00f4 m\u00e0u ho\u1eb7c highlight nh\u1eefng gi\u00e1 tr\u1ecb tr\u00f9ng t\u00ecm th\u1ea5y:\">T\u00f4 m\u00e0u ho\u1eb7c highlight nh\u1eefng gi\u00e1 tr\u1ecb tr\u00f9ng t\u00ecm th\u1ea5y:<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/cach-so-sanh-hai-cot-du-lieu-trong-excel-de-xoa-highligh-to-mau-du-lieu-trung-lap.html#Loai_bo_gia_tri_trung_lap_tu_cot_dau_tien\" title=\"Lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p t\u1eeb c\u1ed9t \u0111\u1ea7u ti\u00ean:\">Lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p t\u1eeb c\u1ed9t \u0111\u1ea7u ti\u00ean:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"So_sanh_hai_cot_de_tim_gia_tri_trung_bang_cong_thuc\"><\/span><strong>So s\u00e1nh hai c\u1ed9t \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb tr\u00f9ng b\u1eb1ng c\u00f4ng th\u1ee9c:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Tr\u01b0\u1eddng h\u1ee3p 1: c\u1ea3 hai c\u1ed9t c\u00f9ng m\u1ed9t danh s\u00e1ch<\/p>\n<ol style=\"text-align: justify\">\n<li>Trong \u00f4 tr\u1ed1ng \u0111\u1ea7u ti\u00ean, \u00f4 C1, nh\u1eadp c\u00f4ng th\u1ee9c: <strong><em>=IF(ISERROR(MATCH(A1,$B$1:$B$10000,0)),\u201dUnique\u201d,\u201dDuplicate\u201d)<\/em><\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/compare-columns-excel-formula.png\" alt=\"Excel formula to compare data between 2 columns and find duplicate and unique entries\" title=\"compare-columns-excel-formula\"><\/p>\n<p style=\"text-align: justify\">Trong c\u00f4ng th\u1ee9c, A1 l\u00e0 \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t \u0111\u1ea7u ti\u00ean m\u00e0 ch\u00fang ta mu\u1ed1n s\u1eed d\u1ee5ng \u0111\u1ec3 so s\u00e1nh. <strong>$B$1<\/strong> v\u00e0 <strong>$B$10000<\/strong> l\u00e0 \u0111\u1ecba ch\u1ec9 c\u1ee7a \u00f4 \u0111\u1ea7u ti\u00ean v\u00e0 cu\u1ed1i c\u00f9ng c\u1ee7a c\u1ed9t th\u1ee9 hai m\u00e0 b\u1ea1n mu\u1ed1n so s\u00e1nh. H\u00e3y ch\u00fa \u00fd c\u1ed1 \u0111\u1ecbnh tham chi\u1ebfu \u00f4 \u2013 k\u00fd hi\u1ec7u \u0111\u00f4 la ($) tr\u01b0\u1edbc c\u00e1c k\u00fd t\u1ef1 c\u1ed9t v\u00e0 s\u1ed1 h\u00e0ng. T\u00f4i s\u1eed d\u1ee5ng tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i nh\u1eb1m gi\u1eef nguy\u00ean \u0111\u1ecba ch\u1ec9 \u00f4 khi sao ch\u00e9p c\u00f4ng th\u1ee9c.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng trong c\u1ed9t B, ho\u00e1n \u0111\u1ed5i t\u00ean c\u1ed9t nh\u01b0 sau: <strong><em>=IF(ISERROR(MATCH(B1,$A$1:$A$10000,0)),\u201dUnique\u201d,\u201dDuplicate\u201d)<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Thay v\u00ec \u201cUnique\u201d\/\u201dDuplicate\u201d (duy nh\u1ea5t\/tr\u00f9ng l\u1eafp), b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1eb7t nh\u00e3n cho m\u00ecnh nh\u01b0 \u201cNot found\u201d\/\u201dFound\u201d (T\u00ecm th\u1ea5y\/Kh\u00f4ng t\u00ecm th\u1ea5y) ho\u1eb7c \u201cDuplicate\u201d v\u00e0 g\u00f5 \u201c\u201d thay v\u00ec \u201cUnique\u201d. Trong c\u00e1ch th\u1ee9 hai, b\u1ea1n s\u1ebd c\u00f3 m\u1ed9t \u00f4 tr\u1ed1ng k\u1ebf b\u00ean \u00f4 m\u00e0 gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eafp kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y.<\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>B\u00e2y gi\u1edd h\u00e3y sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o t\u1ea5t c\u1ea3 c\u00e1c \u00f4 c\u1ee7a c\u1ed9t C cho \u0111\u1ebfn h\u00e0ng cu\u1ed1i c\u00f9ng c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u trong c\u1ed9t A. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, \u0111\u1eb7t con tr\u1ecf v\u00e0o g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4 \u04211, con tr\u1ecf s\u1ebd chuy\u1ec3n th\u00e0nh m\u1ed9t d\u1ea5u th\u1eadp ph\u00e2n \u0111en nh\u01b0 trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/copy-compare-columns-formula.png\" alt=\"Put the cursor to the lower right corner of the cell where you have written the formula\" title=\"copy-compare-columns-formula\"><\/p>\n<p style=\"text-align: justify\">Nh\u1ea5n gi\u1eef chu\u1ed9t tr\u00e1i, k\u00e9o \u0111\u01b0\u1eddng vi\u1ec1n \u00f4 xu\u1ed1ng \u0111\u1ec3 ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o. Khi t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn, th\u1ea3 chu\u1ed9t tr\u00e1i:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/paste-formula-other-cells.png\" alt=\"Copy the formula to other cells\" title=\"paste-formula-other-cells\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>Trong b\u1ea3ng l\u1edbn, c\u00f3 m\u1ed9t c\u00e1ch nhanh h\u01a1n \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c l\u00e0 s\u1eed d\u1ee5ng ph\u00edm t\u1eaft. Nh\u1ea5p v\u00e0o \u00f4 C1 \u0111\u1ec3 ch\u1ecdn n\u00f3 v\u00e0 nh\u1ea5n <strong><em>Ctrl + C <\/em><\/strong>(\u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o <strong><em>clipboard<\/em><\/strong>), sau \u0111\u00f3 nh\u1ea5n <strong><em>Ctrl + Shift + End <\/em><\/strong>(\u0111\u1ec3 ch\u1ecdn t\u1ea5t c\u1ea3 nh\u1eefng \u00f4 ch\u1ee9a d\u1eef li\u1ec7u trong c\u1ed9t C), cu\u1ed1i c\u00f9ng, nh\u1ea5n <strong><em>Ctrl + V <\/em><\/strong>(\u0111\u1ec3 d\u00e1n c\u00f4ng th\u1ee9c v\u00e0o t\u1ea5t c\u1ea3 \u00f4 t\u00ednh \u0111\u00e3 ch\u1ecdn).<\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>T\u1ea5t c\u1ea3 c\u00e1c \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb tr\u00f9ng \u0111\u1ec1u \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u l\u00e0 \u201cDuplicate\u201d.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5827\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-84.png\" width=\"600\" height=\"174\" title=\"excel-dialog-box-launcher-1-84\"><\/p>\n<p style=\"text-align: justify\">Tr\u01b0\u1eddng h\u1ee3p B: hai c\u1ed9t n\u1eb1m tr\u00ean hai trang t\u00ednh (b\u1ea3ng t\u00ednh) kh\u00e1c nhau.<\/p>\n<ol style=\"text-align: justify\">\n<li>Trong \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t tr\u1ed1ng \u0111\u1ea7u ti\u00ean trong Sheet2 (c\u1ed9t B), nh\u1eadp c\u00f4ng th\u1ee9c: <strong><em>=IF(ISERROR(MATCH(A1,Sheet3!$A$1:$A$10000,0)),\u201d\u201d,\u201dDuplicate\u201d)<\/em><\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong>Sheet3! <\/strong>l\u00e0 t\u00ean trang t\u00ednh c\u00f3 ch\u1ee9a c\u1ed9t th\u1ee9 2, <strong>$A$1:$A$10000 <\/strong>l\u00e0 \u0111\u1ecba ch\u1ec9 c\u1ee7a \u00f4 t\u00ednh \u0111\u1ea7u ti\u00ean v\u00e0 \u00f4 t\u00ednh cu\u1ed1i c\u00f9ng trong c\u1ed9t th\u1ee9 2.<\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 b\u01b0\u1edbc trong tr\u01b0\u1eddng h\u1ee3p A.<\/li>\n<li>Ch\u00fang ta c\u00f3 k\u1ebft qu\u1ea3 sau \u0111\u00e2y:<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5828\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-85.png\" width=\"600\" height=\"205\" title=\"excel-dialog-box-launcher-1-85\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Xu_ly_cac_gia_tri_trung_lap_duoc_tim_thay\"><\/span><strong>X\u1eed l\u00fd c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eafp \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Ch\u00fang ta \u0111\u00e3 t\u00ecm th\u1ea5y nh\u1eefng gi\u00e1 tr\u1ecb trong c\u1ed9t th\u1ee9 nh\u1ea5t (c\u1ed9t A) c\u0169ng tr\u00f9ng v\u1edbi c\u1ed9t th\u1ee9 hai (c\u1ed9t B). B\u00e2y gi\u1edd ch\u00fang ta c\u1ea7n l\u00e0m v\u00e0i th\u1ee9 v\u1edbi ch\u00fang.<\/p>\n<p style=\"text-align: justify\">Th\u1eadt kh\u00f4ng hi\u1ec7u qu\u1ea3 v\u00e0 t\u1ed1n th\u1eddi gian khi t\u00ecm ki\u1ebfm tr\u00ean to\u00e0n b\u1ed9 b\u1ea3ng v\u00e0 xem x\u00e9t t\u1eebng gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eafp m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng. C\u00f3 nhi\u1ec1u c\u00e1ch th\u1ef1c hi\u1ec7n \u01b0u vi\u1ec7t h\u01a1n.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chi_hien_thi_hang_bi_trung_trong_cot_A\"><\/span><strong>Ch\u1ec9 hi\u1ec3n th\u1ecb h\u00e0ng b\u1ecb tr\u00f9ng trong c\u1ed9t A:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">N\u1ebfu c\u1ed9t c\u1ee7a b\u1ea1n kh\u00f4ng c\u00f3 ti\u00eau \u0111\u1ec1, b\u1ea1n c\u1ea7n th\u00eam v\u00e0o cho ch\u00fang. \u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y, \u0111\u1eb7t con tr\u1ecf chu\u1ed9t v\u00e0o con s\u1ed1 th\u1ee9 t\u1ef1 \u0111\u1ea7u h\u00e0ng (s\u1ed1 1), con chu\u1ed9t s\u1ebd bi\u1ec3n \u0111\u1ed5i th\u00e0nh m\u0169i t\u00ean m\u00e0u \u0111en nh\u01b0 trong h\u00ecnh 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\/2024\/12\/select-entire-row-excel.png\" alt=\"The cursor changes to a black arrow indicating that the entire row is selected.\" title=\"select-entire-row-excel\"><\/p>\n<p style=\"text-align: justify\">Nh\u1ea5p ph\u1ea3i v\u00e0o h\u00e0ng \u0111\u01b0\u1ee3c ch\u1ecdn v\u00e0 ch\u1ecdn <strong><em>Insert <\/em><\/strong>t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-insert-new-row.png\" alt=\"Insert a new row\" title=\"excel-insert-new-row\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1eb7t t\u00ean cho c\u1ed9t, v\u00ed d\u1ee5 \u201cName\u201d, \u201cDuplicate?\u201d\u2026 Sau \u0111\u00f3 m\u1edf th\u1ebb <strong><em>Data <\/em><\/strong>v\u00e0 nh\u1ea5p ch\u1ecdn <strong><em>Filter<\/em><\/strong>:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5829\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-86.png\" width=\"601\" height=\"385\" title=\"excel-dialog-box-launcher-1-86\"><\/p>\n<p style=\"text-align: justify\">Sau khi nh\u1ea5p chu\u1ed9t v\u00e0o m\u0169i t\u00ean nh\u1ecf m\u00e0u x\u00e1m k\u1ebf b\u00ean \u201cDuplicate?\u201d \u0111\u1ec3 m\u1edf danh s\u00e1ch t\u00f9y ch\u1ecdn, b\u1ecf ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c m\u1ee5c ngo\u1ea1i tr\u1eeb <strong><em>Duplicate <\/em><\/strong>trong danh s\u00e1ch \u0111\u00f3, nh\u1ea5n OK:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/select-only-duplicated-rows.png\" alt=\"Leave only 'Duplicate' checked in the drop-down list\" title=\"select-only-duplicated-rows\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 v\u1eady, b\u1ea1n ch\u1ec9 th\u1ea5y nh\u1eefng \u00f4 t\u00ednh trong c\u1ed9t A c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eafp v\u1edbi c\u1ed9t B. C\u00f3 3 \u00f4 t\u00ednh nh\u01b0 v\u1eady trong trang t\u00ednh v\u00ed d\u1ee5.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/found-duplicates-filtered.png\" alt=\"Only duplicated entries are displayed\" title=\"found-duplicates-filtered\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 hi\u1ec3n th\u1ecb t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng trong c\u1ed9t A l\u1ea7n n\u1eefa, nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <strong><em>filter <\/em><\/strong>trong c\u1ed9t B \u00a0v\u00e0 ch\u1ecdn <strong><em>Select All<\/em><\/strong>. Ho\u1eb7c, b\u1ea1n c\u00f3 th\u1ec3 v\u00e0o th\u1ebb <strong><em>Data &gt; Select &amp; Filter &gt; Clear <\/em><\/strong>nh\u01b0 trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><strong>\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5830\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-87.png\" width=\"600\" height=\"138\" title=\"excel-dialog-box-launcher-1-87\"><\/strong><\/p>\n<h3 style=\"text-align: justify\"><\/h3>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"To_mau_hoac_highlight_nhung_gia_tri_trung_tim_thay\"><\/span><strong>T\u00f4 m\u00e0u ho\u1eb7c highlight nh\u1eefng gi\u00e1 tr\u1ecb tr\u00f9ng t\u00ecm th\u1ea5y:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ngo\u00e0i g\u1eafn nh\u00e3n \u201cDuplicate\u201d, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 \u0111\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng b\u1eb1ng m\u1ed9t c\u00e1ch kh\u00e1c nh\u01b0 \u0111\u1ecbnh d\u1ea1ng m\u00e0u ch\u1eef ho\u1eb7c b\u00f4i m\u00e0u n\u00f3.<\/p>\n<p style=\"text-align: justify\">L\u1ecdc c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p nh\u01b0 gi\u1ea3i th\u00edch \u1edf tr\u00ean, ch\u1ecdn c\u00e1c \u00f4 t\u00ednh \u0111\u00e3 l\u1ecdc v\u00e0 nh\u1ea5n <strong><em>Ctrl + F1<\/em><\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong><em>Format Cells<\/em><\/strong>. V\u00ed d\u1ee5: h\u00e3y thay \u0111\u1ed5i m\u00e0u n\u1ec1n c\u1ee7a c\u00e1c h\u00e0ng b\u1ecb tr\u00f9ng sang m\u00e0u v\u00e0ng t\u01b0\u01a1i. T\u1ea5t nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i m\u00e0u n\u1ec1n c\u1ee7a c\u00e1c \u00f4 n\u00e0y b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng t\u00f9y ch\u1ecdn <strong><em>Fill color <\/em><\/strong>tr\u00ean th\u1ebb <strong><em>Home<\/em><\/strong>, nh\u01b0ng \u01b0u th\u1ebf c\u1ee7a h\u1ed9p tho\u1ea1i <strong><em>Format Cells <\/em><\/strong>l\u00e0 n\u00f3 cho ph\u00e9p b\u1ea1n th\u1ef1c hi\u1ec7n t\u1ea5t c\u1ea3 c\u00e1c thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng c\u00f9ng l\u00fac.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/format-cells-dupes.png\" alt=\"The Format Cells dialog box\" title=\"format-cells-dupes\"><\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd, b\u1ea1n s\u1ebd kh\u00f4ng b\u1ecf s\u00f3t b\u1ea5t k\u1ef3 \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb tr\u00f9ng n\u00e0o.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/color-duplicated-entries.png\" alt=\"The background of duplicated cells is changed to yellow\" title=\"color-duplicated-entries\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Loai_bo_gia_tri_trung_lap_tu_cot_dau_tien\"><\/span><strong>Lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p t\u1eeb c\u1ed9t \u0111\u1ea7u ti\u00ean:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">L\u1ecdc b\u1ea3ng d\u1eef li\u1ec7u \u0111\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p, ch\u1ecdn t\u1ea5t c\u1ea3 nh\u1eefng \u00f4 \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu hai c\u1ed9t \u0111\u01b0\u1ee3c so s\u00e1nh n\u1eb1m tr\u00ean hai trang t\u00ednh kh\u00e1c nhau, c\u1ee5 th\u1ec3 l\u00e0 trong hai b\u1ea3ng d\u1eef li\u1ec7u ri\u00eang bi\u1ec7t, nh\u1ea5p ph\u1ea3i v\u00e0o v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn v\u00e0 ch\u1ecdn <strong><em>Delete Row<\/em><\/strong> t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/remove-duplicated-rows.png\" alt=\"Deleting duplicate rows\" title=\"remove-duplicated-rows\"><\/p>\n<p style=\"text-align: justify\">Khi Excel y\u00eau c\u1ea7u b\u1ea1n x\u00e1c nh\u1eadn b\u1ea1n c\u00f3 th\u1eadt s\u1ef1 mu\u1ed1n x\u00f3a to\u00e0n b\u1ed9 h\u00e0ng n\u00e0y kh\u00f4ng, nh\u1ea5n OK v\u00e0 b\u1ecf b\u1ed9 l\u1ecdc. Nh\u01b0 v\u1eady, ch\u1ec9 nh\u1eefng h\u00e0ng ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/rows-dupes-deleted.png\" alt=\"Only the rows with unique values are displayed\" title=\"rows-dupes-deleted\"><\/p>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tong-hop-cac-phuong-phap-loai-bo-du-lieu-lap.html\">T\u1ed5ng h\u1ee3p c\u00e1c ph\u01b0\u01a1ng ph\u00e1p lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u l\u1eb7p<\/a><\/p>\n<p style=\"text-align: justify\">N\u1ebfu hai c\u1ed9t n\u1eb1m tr\u00ean c\u00f9ng m\u1ed9t trang t\u00ednh, hai c\u1ed9t li\u1ec1n k\u1ec1 ho\u1eb7c kh\u00f4ng li\u1ec1n k\u1ec1, vi\u1ec7c x\u00f3a nh\u1eefng gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eafp s\u1ebd ph\u1ee9c t\u1ea1p h\u01a1n. Ch\u00fang ta kh\u00f4ng th\u1ec3 x\u00f3a to\u00e0n b\u1ed9 h\u00e0ng ch\u1ee9a ch\u00fang b\u1edfi v\u00ec nh\u01b0 v\u1eady s\u1ebd x\u00f3a nh\u1eefng \u00f4 t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t 2. V\u00ec v\u1eady, \u0111\u1ec3 hi\u1ec3n th\u1ecb nh\u1eefng gi\u00e1 tr\u1ecb duy nh\u1ea5t trong c\u1ed9t A, th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>L\u1ecdc b\u1ea3ng \u0111\u1ec3 c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb v\u00e0 ch\u1ecdn t\u1ea5t c\u1ea3 nh\u1eefng \u00f4 \u0111\u00f3. Nh\u1ea5p ph\u1ea3i v\u00e0o v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn v\u00e0 ch\u1ecdn <strong><em>Clear Contents<\/em><\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/clear-cells-content.png\" alt=\"Excel - clear contents\" title=\"clear-cells-content\"><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>B\u1ecf b\u1ed9 l\u1ecdc.<\/li>\n<li>Ch\u1ecdn t\u1ea5t c\u1ea3 \u00f4 t\u00ednh trong c\u1ed9t A b\u1eaft \u0111\u1ea7u t\u1eeb \u00f4 A1 \u0111\u1ebfn \u00f4 cu\u1ed1i c\u00f9ng c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u.<\/li>\n<li>Di chuy\u1ec3n \u0111\u1ebfn th\u1ebb <strong><em>Data<\/em><\/strong>, nh\u1ea5p ch\u1ecdn <strong><em>Sort A to Z<\/em><\/strong>. Trong h\u1ed9p tho\u1ea1i m\u1edf ra, ch\u1ecdn <strong><em>Continue with the current selection<\/em><\/strong> v\u00e0 nh\u1ea5n <strong><em>Sort<\/em><\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sort-only-column-a.png\" alt=\"Sort only column A\" title=\"sort-only-column-a\"><\/p>\n<ol style=\"text-align: justify\" start=\"5\">\n<li>X\u00f3a c\u1ed9t ch\u1ee9a c\u00f4ng th\u1ee9c, ch\u1ec9 \u0111\u1ec3 l\u1ea1i \u201cUniques\u201d<\/li>\n<li>Nh\u01b0 v\u1eady, c\u1ed9t A ch\u1ec9 c\u00f2n nh\u1eefng d\u1eef li\u1ec7u kh\u00f4ng b\u1ecb tr\u00f9ng l\u1eb7p trong c\u1ed9t B.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/all-duplicates-removed.png\" alt=\"All duplicates are removed\" title=\"all-duplicates-removed\"><\/p>\n<p>Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ea1n \u0111ang xem thu\u1ed9c kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao c\u1ee7a H\u1ecdc Excel Online<\/a>. Kh\u00f3a h\u1ecdc n\u00e0y cung c\u1ea5p cho b\u1ea1n ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 trong excel, \u1ee9ng d\u1ee5ng excel trong c\u00f4ng vi\u1ec7c\u2026 Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc n\u00e0y. H\u00e3y tham gia ngay t\u1ea1i \u0111\u1ecba ch\u1ec9: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">H\u1ecdc Excel 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-113.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1565,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1564","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\/1564","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=1564"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1564\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1565"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}