{"id":12371,"date":"2022-03-24T19:51:20","date_gmt":"2022-03-24T12:51:20","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=12371"},"modified":"2025-04-15T17:06:49","modified_gmt":"2025-04-15T10:06:49","slug":"huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m so s\u00e1nh trong excel m\u1edbi nh\u1ea5t"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;12371&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;5&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (5 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m so s\u00e1nh trong excel m\u1edbi nh\u1ea5t&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (5 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p><span style=\"font-weight: 400;\">.Khi l\u00e0m vi\u1ec7c v\u1edbi v\u1edbi excel, \u1eaft h\u1eb3n kh\u1ed1i l\u01b0\u1ee3ng l\u1edbn c\u00f4ng vi\u1ec7c s\u1ebd l\u00e0m b\u1ea1n th\u1ea5y kh\u00e1 r\u1ed1i. V\u00ec th\u1ebf, h\u00e0m so s\u00e1nh trong excel s\u1ebd l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch v\u1edbi b\u1ea1n. M\u1ed9t kh\u1ed1i l\u01b0\u1ee3ng l\u1edbn d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c b\u1ea1n ki\u1ec3m tra m\u1ed9t c\u00e1ch c\u1ea9n th\u1eadn \u0111\u1ec3 tr\u00e1nh tr\u01b0\u1eddng h\u1ee3p b\u1ecb tr\u00f9ng l\u1eb7p m\u00e0 c\u00e1ch ki\u1ec3m tra th\u00f4ng th\u01b0\u1eddng th\u00ec qu\u00e1 v\u1ea5t v\u1ea3. Do \u0111\u00f3, b\u1ea1n s\u1eed d\u1ee5ng <\/span><a href=\"https:\/\/teky.edu.vn\/blog\/\"><b>h\u00e0m so s\u00e1nh trong excel<\/b><\/a><span style=\"font-weight: 400;\"> \u0111\u00e3 \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh s\u1eb5n s\u1ebd v\u00f4 c\u00f9ng ti\u1ec7n l\u1ee3i. H\u00e3y c\u1ed1 g\u1eafng theo d\u00f5i \u0111\u1ebfn cu\u1ed1i b\u00e0i vi\u1ebft \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u1ea7y \u0111\u1ee7 thao t\u00e1c gi\u00fap \u00edch cho c\u00f4ng vi\u1ec7c nh\u00e9.<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#Exact-_ham_so_sanh_trong_Excel\" >Exact- h\u00e0m so s\u00e1nh trong Excel\u00a0<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#Gioi_thieu_so_luoc\" >Gi\u1edbi thi\u1ec7u s\u01a1 l\u01b0\u1ee3c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#Cu_phap_dung_trong_ham_so_sanh_trong_Excel_Exact\" >C\u00fa ph\u00e1p d\u00f9ng trong h\u00e0m so s\u00e1nh trong Excel Exact<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#Vi_du_minh_hoa\" >V\u00ed d\u1ee5 minh h\u1ecda\u00a0<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#Ban_can_so_sanh_hai_du_lieu_tren_hai_cot_khi_nao\" >B\u1ea1n c\u1ea7n so s\u00e1nh hai d\u1eef li\u1ec7u tr\u00ean hai c\u1ed9t khi n\u00e0o?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#Countif-_ham_so_sanh_trong_Excel\" >Countif- h\u00e0m so s\u00e1nh trong Excel\u00a0<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#Gioi_thieu_so_luoc_ve_ham_trung_gian_Countif\" >Gi\u1edbi thi\u1ec7u s\u01a1 l\u01b0\u1ee3c v\u1ec1 h\u00e0m trung gian Countif<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#Cu_phap_de_thuc_hien_ham_so_sanh_trong_Excel_Countif\" >C\u00fa ph\u00e1p \u0111\u1ec3 th\u1ef1c hi\u1ec7n h\u00e0m so s\u00e1nh trong Excel Countif<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#Vi_du\" >V\u00ed d\u1ee5<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Exact-_ham_so_sanh_trong_Excel\"><\/span><span style=\"font-weight: 400;\">Exact- h\u00e0m so s\u00e1nh trong Excel\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"http:\/\/hoclaptrinhmienphi.teky.vn\/1hhoclaptrinh\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24877\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2024\/03\/Banner-Free-Trial.png\" alt=\"H\u1ecdc th\u1eed mi\u1ec5n ph\u00ed\" width=\"600\" height=\"314\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Gioi_thieu_so_luoc\"><\/span><span style=\"font-weight: 400;\">Gi\u1edbi thi\u1ec7u s\u01a1 l\u01b0\u1ee3c<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m Exact l\u00e0 h\u00e0m s\u1eed d\u1ee5ng \u0111\u1ec3 so s\u00e1nh trong excel. \u0110\u00e2y s\u1ebd l\u00e0 h\u00e0m so s\u00e1nh hai chu\u1ed7i c\u1ee7a v\u0103n b\u1ea3n, n\u1ebfu hai chu\u1ed7i \u0111\u00f3 c\u00f3 s\u1ef1 tr\u00f9ng nhau th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 cho b\u1ea1n s\u1ebd l\u00e0 gi\u00e1 tr\u1ecb True. M\u1eb7t kh\u00e1c, ng\u01b0\u1ee3c l\u1ea1i ho\u00e0n to\u00e0n gi\u00e1 tr\u1ecb False s\u1ebd xu\u1ea5t hi\u1ec7n khi c\u00f3 s\u1ef1 kh\u00e1c nhau v\u1ec1 d\u1eef li\u1ec7u gi\u1eefa hai chu\u1ed7i. \u0110\u1eb7c bi\u1ec7t h\u01a1n so v\u1edbi c\u00e1c h\u00e0m so s\u00e1nh trong excel kh\u00e1c, h\u00e0m Exact c\u00f3 s\u1ef1 ph\u00e2n bi\u1ec7t r\u00f5 r\u00e0ng v\u1ec1 ph\u1ea7n ch\u1eef hoa v\u1edbi ch\u1eef th\u01b0\u1eddng \u0111\u1ec3 s\u1eed d\u1ee5ng trong qu\u00e1 tr\u00ecnh th\u1ef1c hi\u1ec7n thao t\u00e1c so s\u00e1nh.\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cu_phap_dung_trong_ham_so_sanh_trong_Excel_Exact\"><\/span><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p d\u00f9ng trong h\u00e0m so s\u00e1nh trong Excel Exact<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>EXACT(Text1, Text2)<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Gi\u1ea3i th\u00edch, trong \u0111\u00f3: Text1, Text2 l\u00e0 hai chu\u1ed7i c\u1ee7a v\u0103n b\u1ea3n m\u00e0 b\u1ea1n \u0111ang c\u1ea7n \u0111\u1ec3 so s\u00e1nh. \u0110\u00e2y s\u1ebd l\u00e0 hai tham s\u1ed1 b\u1eaft bu\u1ed9c c\u1ea7n ph\u1ea3i c\u00f3 trong qu\u00e1 tr\u00ecnh th\u1ef1c hi\u1ec7n vi\u1ec7c so s\u00e1nh.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u00fa \u00fd: Nh\u01b0 ch\u00fang t\u00f4i \u0111\u00e3 n\u00f3i \u1edf ph\u1ea7n tr\u00ean, h\u00e0m Exact s\u1ebd c\u00f3 s\u1ef1 ph\u00e2n bi\u1ec7t r\u1ea5t l\u1edbn gi\u1eefa ch\u1eef hoa so v\u1edbi ch\u1eef th\u01b0\u1eddng. Nh\u01b0ng c\u00f3 ph\u1ea7n l\u01b0u \u00fd l\u00e0 n\u00f3 s\u1ebd kh\u00f4ng c\u00f3 ph\u1ea7n ph\u00e2n bi\u1ec7t v\u1ec1 ph\u1ea7n \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u trong qu\u00e1 tr\u00ecnh th\u1ef1c hi\u1ec7n h\u00e0m so s\u00e1nh trong excel.\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du_minh_hoa\"><\/span><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 minh h\u1ecda\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">B\u1ea1n h\u00e3y so s\u00e1nh d\u1eef li\u1ec7u c\u00f3 s\u1ef1 t\u01b0\u01a1ng \u1ee9ng theo h\u00e0ng gi\u1eefa c\u1ed9t 1 v\u00e0 c\u1ed9t 2. H\u00e3y c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c sau \u0111\u00e2y t\u1ea1i \u00f4 m\u00e0 b\u1ea1n \u0111ang c\u1ea7n th\u1ef1c hi\u1ec7n so s\u00e1nh 2 c\u1ed9t trong excel: EXACT(D4,E4)<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12382 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-8.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-8.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-8-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/11-8-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Khi b\u1ea1n th\u1ef1c hi\u1ec7n thao t\u00e1c nh\u1ea5n Enter th\u00ec k\u1ebft qu\u1ea3 m\u00e0 b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c khi tr\u1ea3 v\u1ec1 b\u1ea3ng excel, ch\u1eafc ch\u1eafn l\u00e0 gi\u00e1 tr\u1ecb False. Ngh\u0129a l\u00e0 hai d\u1eef li\u1ec7u m\u00e0 b\u1ea1n \u0111ang so s\u00e1nh v\u1edbi nhau l\u00e0 hai gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng nhau. V\u00ec theo ta th\u1ea5y, gi\u1eefa hai t\u1eeb c\u00f3 s\u1ef1 kh\u00e1c nhau v\u1ec1 ph\u1ea7n ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean l\u00e0 in th\u01b0\u1eddng v\u00e0 in hoa. Nh\u01b0 ta c\u00f3 \u1edf b\u1ea3ng sau \u0111\u00e2y:\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12381 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-9.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-9.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-9-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/10-9-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">T\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1c ph\u1ea7n c\u00f2n l\u1ea1i, b\u1ea1n h\u00e3y sao ch\u00e9p c\u00f4ng th\u1ee9c cho l\u1ea7n l\u01b0\u1ee3t c\u00e1c\u00a0 gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1. Nh\u1eefng k\u1ebft qu\u1ea3 m\u00e0 ta nh\u1eadn \u0111\u01b0\u1ee3c l\u00e0:\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12380 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-12.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-12.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-12-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/9-12-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd: V\u1ec1 ph\u1ea7n h\u00e0m n\u00e0y b\u1ea1n kh\u00f4ng bao gi\u1edd c\u00f3 th\u1ec3 so s\u00e1nh m\u1ed9t gi\u00e1 tr\u1ecb \u1edf trong m\u1ed9t c\u1ed9t. V\u1edbi t\u1ea5t c\u1ea3 c\u00e1c d\u1eef li\u1ec7u trong c\u1ed9t 2 \u0111\u1ec3 c\u00f3 th\u1ec3 nhanh ch\u00f3ng t\u00ecm s\u1ef1 tr\u00f9ng l\u1eb7p v\u1edbi nhau. Vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m Exact \u0111\u1ec3 so s\u00e1nh trong excel. Th\u00ec ch\u1ec9 c\u00f3 th\u1ec3 l\u00e0 so s\u00e1nh t\u01b0\u01a1ng \u1ee9ng gi\u1eefa nh\u1eefng h\u00e0m v\u1edbi nhau trong b\u1ea3ng.\u00a0<\/span><\/p>\n<p>&gt;&gt;&gt; Tham kh\u1ea3o th\u00eam: <a href=\"https:\/\/teky.edu.vn\/blog\/su-dung-ham-dem-co-dieu-kien-sieu-don-gian-trong-excel\/\"><span style=\"color: #0000ff;\"><em><strong>H\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel<\/strong><\/em><\/span><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ban_can_so_sanh_hai_du_lieu_tren_hai_cot_khi_nao\"><\/span><span style=\"font-weight: 400;\">B\u1ea1n c\u1ea7n so s\u00e1nh hai d\u1eef li\u1ec7u tr\u00ean hai c\u1ed9t khi n\u00e0o?<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">B\u1ea1n c\u1ea7n d\u00f9ng <strong>h\u00e0m so s\u00e1nh trong excel<\/strong> hai c\u1ed9t trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p sau:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Khi b\u1ea1n \u0111ang c\u00f3 vi\u1ec7c th\u1ef1c hi\u1ec7n tr\u00ean excel. Nh\u01b0ng m\u00e0 y\u00eau c\u1ea7u \u0111\u01b0\u1ee3c b\u1ea1n \u0111\u1eb7t ra l\u00e0 \u0111ang mu\u1ed1n nhanh ch\u00f3ng t\u00ecm ra nh\u1eefng ph\u1ea7n kh\u00e1c nhau v\u1ec1 2 c\u1ed9t d\u1eef li\u1ec7u m\u00e0 b\u1ea1n \u0111ang th\u1ef1c hi\u1ec7n.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Khi b\u1ea1n \u0111ang c\u1ea7n th\u1ef1c hi\u1ec7n so s\u00e1nh c\u00e1c s\u1ed1 l\u01b0\u1ee3ng v\u1ec1 d\u1eef li\u1ec7u gi\u1eefa hai c\u1ed9t \u0111\u00e3 \u0111\u01b0\u1ee3c nh\u1eadp tr\u00ean excel.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Khi b\u1ea1n \u0111ang loay hoay t\u00ecm ra nh\u1eefng \u0111i\u1ec3m tr\u00f9ng nhau ho\u1eb7c l\u00e0 nh\u1eefng \u0111i\u1ec3m chung nh\u1ea5t \u0111\u1ecbnh gi\u1eefa hai c\u1ed9t d\u1eef li\u1ec7u v\u1edbi nhau.\u00a0<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Countif-_ham_so_sanh_trong_Excel\"><\/span><span style=\"font-weight: 400;\">Countif- h\u00e0m so s\u00e1nh trong Excel\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">N\u1ebfu nh\u01b0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m so s\u00e1nh trong excel v\u1edbi vi\u1ec7c d\u00f9ng h\u00e0m Exact qu\u00e1 kh\u00f3 khi so m\u1ed9t c\u1ed9t v\u1edbi c\u00e1c c\u1ed9t kh\u00e1c. Thi b\u1ea1n n\u00ean s\u1eed d\u1ee5ng th\u00f4ng qua h\u00e0m trung gian Countif n\u00e0y. \u0110\u00e2y l\u00e0 h\u00e0m so s\u00e1nh 2 c\u1ed9t trong excel. N\u00f3 s\u1ebd gi\u00fap b\u1ea1n so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb c\u1ed9t 1 so v\u1edbi gi\u00e1 tr\u1ecb \u1edf c\u1ed9t 2 xem n\u00f3 c\u00f3 tr\u00f9ng nhau v\u1ec1 d\u1eef li\u1ec7u hay kh\u00f4ng.\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Gioi_thieu_so_luoc_ve_ham_trung_gian_Countif\"><\/span><span style=\"font-weight: 400;\">Gi\u1edbi thi\u1ec7u s\u01a1 l\u01b0\u1ee3c v\u1ec1 h\u00e0m trung gian Countif<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m Countif s\u1ebd gi\u00fap b\u1ea1n \u0111\u01b0a ra thao t\u00e1c th\u1ef1c hi\u1ec7n \u0111\u1ebfm s\u1ed1 c\u00e1c \u00f4. Gi\u00fap b\u1ea1n th\u1ecfa m\u00e3n nh\u1eefng \u0111i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n \u0111\u01b0a ra trong v\u00f9ng d\u1eef li\u1ec7u. B\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u1eeb c\u00e1c y\u00eau c\u1ea7u m\u00e0 b\u1ea1n l\u1ef1a ch\u1ecdn.\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/lotrinhlaptrinh.teky.vn\/\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24875\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2024\/03\/Sale-Promotion.png\" alt=\"\u01afu \u0111\u00e3i \u0111\u1ebfn 25%\" width=\"600\" height=\"314\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cu_phap_de_thuc_hien_ham_so_sanh_trong_Excel_Countif\"><\/span><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p \u0111\u1ec3 th\u1ef1c hi\u1ec7n h\u00e0m so s\u00e1nh trong Excel Countif<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\u00a0<\/span><b>COUNTIF(Range, Criteria)<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Gi\u1ea3i th\u00edch, trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Range: L\u00e0 nh\u1eefng v\u00f9ng c\u1ee7a ph\u1ea7n d\u1eef li\u1ec7u \u0111ang ch\u1ee9a c\u00e1c d\u1eef li\u1ec7u m\u00e0 b\u1ea1n c\u1ea7n \u0111\u1ebfm. V\u00e0 t\u1ea5t nhi\u00ean \u0111\u00e2y s\u1ebd l\u00e0 tham s\u1ed1 b\u1ea1n c\u1ea7n b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Criteria: Nh\u1eefng \u0111i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n c\u1ea7n d\u00f9ng \u0111\u1ec3 c\u00f3 th\u1ec3 \u0111\u1ebfm c\u00e1c d\u1eef li\u1ec7u. V\u00e0 c\u0169ng l\u00e0 c\u00e1c tham s\u1ed1 b\u1eaft bu\u1ed9c.\u00a0<\/span><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span><span style=\"font-weight: 400;\">V\u00ed d\u1ee5<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">B\u1ea1n h\u00e3y so s\u00e1nh c\u00e1c d\u1eef li\u1ec7u gi\u1eefa 2 c\u1ed9t, \u0111\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng c\u00f3 trong c\u1ed9t 1. M\u00e0 n\u00f3 l\u1ea1i c\u00f3 s\u1ef1 xu\u1ea5t hi\u1ec7n trong c\u1ed9t 2 v\u00e0 ng\u01b0\u1ee3c l\u1ea1i.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: H\u00e3y th\u1ef1c hi\u1ec7n vi\u1ec7c th\u1ef1c hi\u1ec7n \u0111\u1eb7t t\u00ean cho c\u00e1c c\u1ed9t d\u1eef li\u1ec7u.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u1ea1n h\u00e3y l\u1ef1a ch\u1ecdn ph\u1ea7n to\u00e0n b\u1ed9 d\u1eef li\u1ec7u c\u1ed9t 1 v\u00e0o thanh \u0111\u1ecba ch\u1ec9 g\u00f5. V\u00e0 nh\u1eadp t\u00ean danhsach1 -&gt; nh\u1ea5n Enter \u0111\u1ec3 th\u1ef1c hi\u1ec7n.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12377 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-21.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-21.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-21-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/6-21-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: C\u0169ng c\u00f3 ph\u1ea7n t\u01b0\u01a1ng t\u1ef1 \u0111\u1eb7t t\u00ean cho c\u1ed9t 2. Khi \u0111\u00f3 c\u0169ng h\u00e3y nh\u1eadp t\u00ean d\u1eef li\u1ec7u, 2 c\u1ed9t d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12379 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-16.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-16.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-16-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/8-16-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: B\u00f4i ch\u1ecdn to\u00e0n b\u1ed9 danh s\u00e1ch 1 -&gt; nh\u1ea5p v\u00e0 ch\u1ecdn th\u1ebb Home -&gt; Conditional Formatting -&gt; New Rule\u2026<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12378 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-20.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-20.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-20-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/7-20-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: B\u1ea1n h\u00e3y nhanh ch\u00f3ng l\u1ef1a ch\u1ecdn Use a formula to determine which cells to format.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12384 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-26.jpg\" alt=\"\" width=\"600\" height=\"600\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-26.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-26-400x400.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-26-150x150.jpg 150w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 5: Thao t\u00e1c nh\u1eadp c\u00f4ng th\u1ee9c =COUNTIF(danhsach2,C3)=0 c\u1ea7n c\u00f3 s\u1ef1 ch\u00ednh x\u00e1c. Sau \u0111\u00f3, k\u00edch ch\u1ecdn Format:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12385 size-full aligncenter\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-27.jpg\" alt=\"\" width=\"600\" height=\"600\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-27.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-27-400x400.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-27-150x150.jpg 150w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 6: L\u00fac \u1ea5y, c\u00f3 s\u1ef1 xu\u1ea5t hi\u1ec7n c\u1ee7a h\u1ed9p tho\u1ea1i Format Cells. Ti\u1ebfp theo, k\u00edch ch\u1ecdn th\u1ebb Fill. Sau \u0111\u00f3, l\u1ef1a ch\u1ecdn nh\u1eefng m\u00e0u \u0111\u00e1nh d\u1ea5u lo\u1ea1i qu\u1ea3 kh\u00f4ng c\u00f3 trong danh s\u00e1ch 2. Cu\u1ed1i c\u00f9ng k\u00edch ch\u1ecdn OK.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 7: Ti\u1ebfp theo l\u1ef1a ch\u1ecdn k\u00edch ch\u1ecdn OK l\u1ea7n n\u1eefa \u0111\u1ec3 \u0111\u00f3ng h\u1ed9p tho\u1ea1i k\u1ebft qu\u1ea3. Lo\u1ea1i qu\u1ea3 \u1edf danh s\u00e1ch 1 kh\u00f4ng c\u00f3 trong danh s\u00e1ch 2 \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12375 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-23.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-23.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-23-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-23-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 8: T\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1c b\u01b0\u1edbc \u1edf danh s\u00e1ch 2, nh\u01b0ng kh\u00e1c khi nh\u1eadp c\u00f4ng th\u1ee9c: = COUNTIF(danhsach2,F3)=0. T\u1ee9c l\u00e0 b\u1ea1n s\u1ebd t\u00f4 nh\u1eefng m\u00e0u c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 b\u1eb1ng 0, ngh\u0129a l\u00e0 c\u00f3 ph\u1ea7n trung nhau. <\/span><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 l\u00e0 sau c\u00f9ng b\u1ea1n \u0111\u00e3 so s\u00e1nh 2 c\u1ed9t d\u1eef li\u1ec7u ho\u00e0n th\u00e0nh.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12374 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-26.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-26.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-26-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-26-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Nh\u1eefng th\u00f4ng tin tr\u00ean l\u00e0 c\u00e1ch s\u1eed d\u1ee5ng <\/span><b>h\u00e0m so s\u00e1nh trong excel.<\/b><span style=\"font-weight: 400;\"> \u0110\u1ec3 so s\u00e1nh nh\u1eefng d\u1eef li\u1ec7u v\u1edbi nhau g\u1ed3m h\u00e0m Exact v\u00e0 h\u00e0m Countif. Hai h\u00e0m n\u00e0y \u0111\u1ec3 so s\u00e1nh m\u1ed9t h\u00e0ng ngang v\u00e0 so s\u00e1nh 2 c\u1ed9t. Mong b\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i b\u00e0i vi\u1ebft \u0111\u1ec3 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n t\u1ed1t qu\u00e1 tr\u00ecnh so s\u00e1nh trong excel.\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/khuyenmai.teky.vn\/tangsachlaptrinh\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24876\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2024\/03\/Free-Asset.png\" alt=\"T\u1eb7ng s\u00e1ch mi\u1ec5n ph\u00ed\" width=\"600\" height=\"314\" \/><\/a><\/p>\n<p>&gt;&gt;&gt; Tham kh\u1ea3o th\u00eam: <span style=\"color: #0000ff;\"><em><strong>\u00a0<a href=\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/\">C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel<\/a><\/strong><\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>.Khi l\u00e0m vi\u1ec7c v\u1edbi v\u1edbi excel, \u1eaft h\u1eb3n kh\u1ed1i l\u01b0\u1ee3ng l\u1edbn c\u00f4ng vi\u1ec7c s\u1ebd l\u00e0m b\u1ea1n th\u1ea5y kh\u00e1 r\u1ed1i. V\u00ec th\u1ebf, h\u00e0m so s\u00e1nh trong excel s\u1ebd l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch v\u1edbi b\u1ea1n. M\u1ed9t kh\u1ed1i l\u01b0\u1ee3ng l\u1edbn d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c b\u1ea1n ki\u1ec3m tra m\u1ed9t c\u00e1ch c\u1ea9n th\u1eadn \u0111\u1ec3 tr\u00e1nh tr\u01b0\u1eddng h\u1ee3p b\u1ecb tr\u00f9ng &hellip;<\/p>\n","protected":false},"author":26,"featured_media":12373,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-12371","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m so s\u00e1nh trong excel m\u1edbi nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"H\u00e0m so s\u00e1nh trong excel \u0111\u00e3 \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh s\u1eb5n s\u1ebd v\u00f4 c\u00f9ng ti\u1ec7n l\u1ee3i. H\u00e3y c\u1ed1 g\u1eafng theo d\u00f5i b\u00e0i vi\u1ebft c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u1ea7y \u0111\u1ee7 thao t\u00e1c gi\u00fap \u00edch cho c\u00f4ng vi\u1ec7c nh\u00e9.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m so s\u00e1nh trong excel m\u1edbi nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m so s\u00e1nh trong excel \u0111\u00e3 \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh s\u1eb5n s\u1ebd v\u00f4 c\u00f9ng ti\u1ec7n l\u1ee3i. H\u00e3y c\u1ed1 g\u1eafng theo d\u00f5i b\u00e0i vi\u1ebft c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u1ea7y \u0111\u1ee7 thao t\u00e1c gi\u00fap \u00edch cho c\u00f4ng vi\u1ec7c nh\u00e9.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-24T12:51:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-15T10:06:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-25.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"H\u1eb1ng L\u00ea\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"H\u1eb1ng L\u00ea\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/\"},\"author\":{\"name\":\"H\u1eb1ng L\u00ea\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\"},\"headline\":\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m so s\u00e1nh trong excel m\u1edbi nh\u1ea5t\",\"datePublished\":\"2022-03-24T12:51:20+00:00\",\"dateModified\":\"2025-04-15T10:06:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/\"},\"wordCount\":1801,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-25.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/\",\"name\":\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m so s\u00e1nh trong excel m\u1edbi nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-25.jpg\",\"datePublished\":\"2022-03-24T12:51:20+00:00\",\"dateModified\":\"2025-04-15T10:06:49+00:00\",\"description\":\"H\u00e0m so s\u00e1nh trong excel \u0111\u00e3 \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh s\u1eb5n s\u1ebd v\u00f4 c\u00f9ng ti\u1ec7n l\u1ee3i. H\u00e3y c\u1ed1 g\u1eafng theo d\u00f5i b\u00e0i vi\u1ebft c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u1ea7y \u0111\u1ee7 thao t\u00e1c gi\u00fap \u00edch cho c\u00f4ng vi\u1ec7c nh\u00e9.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-25.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-25.jpg\",\"width\":600,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m so s\u00e1nh trong excel m\u1edbi nh\u1ea5t\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\",\"name\":\"H\u1eb1ng L\u00ea\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"caption\":\"H\u1eb1ng L\u00ea\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/lehang\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m so s\u00e1nh trong excel m\u1edbi nh\u1ea5t","description":"H\u00e0m so s\u00e1nh trong excel \u0111\u00e3 \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh s\u1eb5n s\u1ebd v\u00f4 c\u00f9ng ti\u1ec7n l\u1ee3i. H\u00e3y c\u1ed1 g\u1eafng theo d\u00f5i b\u00e0i vi\u1ebft c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u1ea7y \u0111\u1ee7 thao t\u00e1c gi\u00fap \u00edch cho c\u00f4ng vi\u1ec7c nh\u00e9.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m so s\u00e1nh trong excel m\u1edbi nh\u1ea5t","og_description":"H\u00e0m so s\u00e1nh trong excel \u0111\u00e3 \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh s\u1eb5n s\u1ebd v\u00f4 c\u00f9ng ti\u1ec7n l\u1ee3i. H\u00e3y c\u1ed1 g\u1eafng theo d\u00f5i b\u00e0i vi\u1ebft c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u1ea7y \u0111\u1ee7 thao t\u00e1c gi\u00fap \u00edch cho c\u00f4ng vi\u1ec7c nh\u00e9.","og_url":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-03-24T12:51:20+00:00","article_modified_time":"2025-04-15T10:06:49+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-25.jpg","type":"image\/jpeg"}],"author":"H\u1eb1ng L\u00ea","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"H\u1eb1ng L\u00ea","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"10 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/"},"author":{"name":"H\u1eb1ng L\u00ea","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b"},"headline":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m so s\u00e1nh trong excel m\u1edbi nh\u1ea5t","datePublished":"2022-03-24T12:51:20+00:00","dateModified":"2025-04-15T10:06:49+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/"},"wordCount":1801,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-25.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/","url":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/","name":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m so s\u00e1nh trong excel m\u1edbi nh\u1ea5t","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-25.jpg","datePublished":"2022-03-24T12:51:20+00:00","dateModified":"2025-04-15T10:06:49+00:00","description":"H\u00e0m so s\u00e1nh trong excel \u0111\u00e3 \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh s\u1eb5n s\u1ebd v\u00f4 c\u00f9ng ti\u1ec7n l\u1ee3i. H\u00e3y c\u1ed1 g\u1eafng theo d\u00f5i b\u00e0i vi\u1ebft c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u1ea7y \u0111\u1ee7 thao t\u00e1c gi\u00fap \u00edch cho c\u00f4ng vi\u1ec7c nh\u00e9.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-25.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-25.jpg","width":600,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-ham-so-sanh-trong-excel-moi-nhat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m so s\u00e1nh trong excel m\u1edbi nh\u1ea5t"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b","name":"H\u1eb1ng L\u00ea","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","caption":"H\u1eb1ng L\u00ea"},"url":"https:\/\/teky.edu.vn\/blog\/author\/lehang\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12371","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=12371"}],"version-history":[{"count":2,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12371\/revisions"}],"predecessor-version":[{"id":24992,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12371\/revisions\/24992"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/12373"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=12371"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=12371"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=12371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}