{"id":289943,"date":"2023-11-27T20:40:46","date_gmt":"2023-11-27T13:40:46","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=289943"},"modified":"2023-11-27T20:40:46","modified_gmt":"2023-11-27T13:40:46","slug":"ham-so-sanh-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/","title":{"rendered":"C\u00e1ch d\u00f9ng h\u00e0m so s\u00e1nh \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u 2 c\u1ed9t trong Excel \u0111\u01a1n gi\u1ea3n chi ti\u1ebft nh\u1ea5t"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Excel l\u00e0 c\u00f4ng c\u1ee5 ph\u1ed5 bi\u1ebfn \u0111\u1ed1i v\u1edbi \u0111a s\u1ed1 ng\u01b0\u1eddi d\u00f9ng v\u0103n ph\u00f2ng. Trong \u0111\u00f3, <\/span><span style=\"font-weight: 400;\">h\u00e0m so s\u00e1nh trong Excel<\/span><span style=\"font-weight: 400;\"> l\u00e0 c\u00f4ng c\u1ee5 \u0111\u1eafc l\u1ef1c khi b\u1ea1n c\u1ea7n ki\u1ec3m tra s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa c\u00e1c c\u1ed9t, gi\u00fap t\u1ed1i \u01b0u h\u00f3a th\u1eddi gian so s\u00e1nh d\u1eef li\u1ec7u tr\u00ean Excel. B\u00e0i vi\u1ebft b\u00ean d\u01b0\u1edbi, Ho\u00e0ng H\u00e0 Moblie s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch d\u00f9ng h\u00e0m so s\u00e1nh Excel \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u 2 c\u1ed9t m\u1ed9t c\u00e1ch nhanh ch\u00f3ng. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u nh\u00e9!<\/span><\/p>\n<h2><b>H\u00e0m trong Excel l\u00e0 g\u00ec?<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">H\u00e0m trong Excel l\u00e0 m\u1ed9t ph\u1ea7n c\u1ee7a ph\u1ea7n m\u1ec1m b\u1ea3ng t\u00ednh Microsoft Excel, cho ph\u00e9p b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh to\u00e1n v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u t\u1ef1 \u0111\u1ed9ng. H\u00e0m c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n nhi\u1ec1u t\u00e1c v\u1ee5 kh\u00e1c nhau, t\u1eeb c\u00e1c ph\u00e9p to\u00e1n c\u01a1 b\u1ea3n nh\u01b0 c\u1ed9ng, tr\u1eeb, nh\u00e2n, chia, \u0111\u1ebfn c\u00e1c t\u00e1c v\u1ee5 ph\u1ee9c t\u1ea1p nh\u01b0 t\u00ednh to\u00e1n trung b\u00ecnh, t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t, nh\u1ecf nh\u1ea5t, v\u00e0 nhi\u1ec1u c\u00f4ng vi\u1ec7c ph\u1ee9c t\u1ea1p kh\u00e1c.<\/span><\/p>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-trong-excel-la-gi.jpeg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-trong-excel-la-gi-300x169.jpeg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-trong-excel-la-gi-768x432.jpeg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-289972 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-trong-excel-la-gi.jpeg\" alt=\"ham-so-sanh-trong-excel-ham-trong-excel-la-gi\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-trong-excel-la-gi.jpeg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-trong-excel-la-gi-300x169.jpeg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-trong-excel-la-gi-768x432.jpeg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Th\u00f4ng th\u01b0\u1eddng, c\u00fa ph\u00e1p c\u1ee7a m\u1ed9t h\u00e0m s\u1ebd b\u1eaft \u0111\u1ea7u b\u1eb1ng d\u1ea5u &#8220;=&#8221;, sau \u0111\u00f3 theo sau l\u00e0 t\u00ean c\u1ee7a h\u00e0m v\u00e0 c\u00e1c \u0111\u1ed1i s\u1ed1 ho\u1eb7c tham s\u1ed1 c\u1ea7n thi\u1ebft \u0111\u1ec3 th\u1ef1c hi\u1ec7n t\u00e1c v\u1ee5 trong Excel. S\u1eed d\u1ee5ng c\u00e1c h\u00e0m trong Excel r\u1ea5t h\u1eefu \u00edch \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a c\u00e1c t\u00e1c v\u1ee5 t\u00ednh to\u00e1n v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u, gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 gi\u1ea3m nguy c\u01a1 ph\u00e1t sinh l\u1ed7i trong qu\u00e1 x\u1eed l\u00fd d\u1eef li\u1ec7u.<\/span><\/p>\n<h2><b>H\u00e0m so s\u00e1nh trong Excel <\/b><b>l\u00e0 g\u00ec? C\u00e1c h\u00e0m so s\u00e1nh c\u01a1 b\u1ea3n trong Excel<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">H\u00e0m so s\u00e1nh <\/span><span style=\"font-weight: 400;\">l\u00e0 nh\u00f3m c\u00e1c h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 so s\u00e1nh gi\u1eefa c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c \u00f4 ho\u1eb7c ph\u1ea1m vi \u00f4. Sau khi th\u1ef1c hi\u1ec7n, c\u00e1c h\u00e0m so s\u00e1nh s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 d\u01b0\u1edbi d\u1ea1ng TRUE (\u0111\u00fang) ho\u1eb7c FALSE (sai) t\u00f9y thu\u1ed9c v\u00e0o k\u1ebft qu\u1ea3 c\u1ee7a ph\u00e9p so s\u00e1nh, t\u1eeb \u0111\u00f3 gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n so s\u00e1nh d\u1eef li\u1ec7u d\u1ef1a tr\u00ean c\u00e1c \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3 v\u00e0 tr\u01b0\u1eddng h\u1ee3p so s\u00e1nh nh\u1ea5t \u0111\u1ecbnh.<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400;\"> <picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-la-gi.jpeg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-la-gi-300x169.jpeg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-la-gi-768x432.jpeg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"alignnone size-full wp-image-289973 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-la-gi.jpeg\" alt=\"ham-so-sanh-trong-excel-la-gi\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-la-gi.jpeg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-la-gi-300x169.jpeg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-la-gi-768x432.jpeg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00e1c <\/span><span style=\"font-weight: 400;\">h\u00e0m so s\u00e1nh trong Excel c\u01a1 b\u1ea3n <\/span><span style=\"font-weight: 400;\">g\u1ed3m:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">=A1=B1 (Equal): So s\u00e1nh xem gi\u00e1 tr\u1ecb trong \u00f4 A1 c\u00f3 b\u1eb1ng gi\u00e1 tr\u1ecb trong \u00f4 B1 kh\u00f4ng.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">=A1&lt;&gt;B1 (Not Equal): Ki\u1ec3m tra xem gi\u00e1 tr\u1ecb trong \u00f4 A1 c\u00f3 kh\u00e1c v\u1edbi gi\u00e1 tr\u1ecb trong \u00f4 B1 hay kh\u00f4ng.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">=A1&lt;B1 (Less Than): Ki\u1ec3m tra xem gi\u00e1 tr\u1ecb trong \u00f4 A1 c\u00f3 nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb trong \u00f4 B1 hay kh\u00f4ng.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">=A1&lt;=B1 (Less Than or Equal To): Ki\u1ec3m tra xem gi\u00e1 tr\u1ecb trong \u00f4 A1 c\u00f3 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb trong \u00f4 B1 hay kh\u00f4ng.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">=A1&gt;B1 (Greater Than): Ki\u1ec3m tra xem gi\u00e1 tr\u1ecb trong \u00f4 A1 c\u00f3 l\u1edbn h\u01a1n gi\u00e1 tr\u1ecb trong \u00f4 B1 hay kh\u00f4ng.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">=A1&gt;=B1 (Greater Than or Equal To): Ki\u1ec3m tra xem gi\u00e1 tr\u1ecb trong \u00f4 A1 c\u00f3 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng gi\u00e1 tr\u1ecb trong \u00f4 B1 hay kh\u00f4ng.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">=AND(condition1, condition2, &#8230;) (AND): Tr\u1ea3 v\u1ec1 TRUE n\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh \u0111\u1ec1u \u0111\u00fang.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">=OR(condition1, condition2, &#8230;) (OR): Tr\u1ea3 v\u1ec1 TRUE n\u1ebfu \u00edt nh\u1ea5t m\u1ed9t trong s\u1ed1 c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh l\u00e0 \u0111\u00fang.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">=NOT(condition) (NOT): \u0110\u1ea3o ng\u01b0\u1ee3c k\u1ebft qu\u1ea3 c\u1ee7a \u0111i\u1ec1u ki\u1ec7n. Tr\u1ea3 v\u1ec1 TRUE n\u1ebfu \u0111i\u1ec1u ki\u1ec7n sai v\u00e0 ng\u01b0\u1ee3c l\u1ea1i.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">=IF(condition, value_if_true, value_if_false) (IF): Th\u1ef1c hi\u1ec7n m\u1ed9t ph\u00e9p so s\u00e1nh v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u00f9y thu\u1ed9c v\u00e0o k\u1ebft qu\u1ea3 c\u1ee7a \u0111i\u1ec1u ki\u1ec7n.<\/span><\/li>\n<\/ul>\n<h2><b>H\u00e0m so s\u00e1nh trong Exel<\/b><b> \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng khi n\u00e0o ?<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">H\u00e0m so s\u00e1nh <\/span><span style=\"font-weight: 400;\">\u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng khi th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p so s\u00e1nh gi\u1eefa c\u00e1c gi\u00e1 tr\u1ecb ho\u1eb7c \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau \u0111\u1ec3 \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh d\u1ef1a tr\u00ean k\u1ebft qu\u1ea3 c\u1ee7a c\u00e1c so s\u00e1nh \u0111\u00f3. C\u1ee5 th\u1ec3 nh\u01b0 sau:<\/span><\/p>\n<p><b>So s\u00e1nh d\u1eef li\u1ec7u trong c\u00e1c \u00f4 ho\u1eb7c ph\u1ea1m vi \u00f4: <\/b><span style=\"font-weight: 400;\">So s\u00e1nh gi\u00e1 tr\u1ecb trong \u00f4 A1 v\u1edbi gi\u00e1 tr\u1ecb trong \u00f4 B1, ki\u1ec3m tra xem ch\u00fang c\u00f3 b\u1eb1ng nhau hay kh\u00f4ng.<\/span><\/p>\n<p><b>T\u1ea1o \u0111i\u1ec1u ki\u1ec7n trong c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c: <\/b><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m IF \u0111\u1ec3 th\u1ef1c hi\u1ec7n m\u1ed9t h\u00e0nh \u0111\u1ed9ng n\u1ebfu m\u1ed9t \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u00f3 \u0111\u00fang v\u00e0 m\u1ed9t h\u00e0nh \u0111\u1ed9ng kh\u00e1c n\u1ebfu \u0111i\u1ec1u ki\u1ec7n sai.<\/span><\/p>\n<p><b>Ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n trong c\u00e1c h\u00e0m logic: <\/b><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m AND \u0111\u1ec3 ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u1ea7n \u0111\u1ed3ng th\u1eddi \u0111\u00fang, ho\u1eb7c h\u00e0m OR \u0111\u1ec3 ki\u1ec3m tra n\u1ebfu \u00edt nh\u1ea5t m\u1ed9t \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-cac-ham-ss-2.jpeg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-cac-ham-ss-2-300x169.jpeg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-cac-ham-ss-2-768x432.jpeg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"alignnone size-full wp-image-289954 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-cac-ham-ss-2.jpeg\" alt=\"ham-so-sanh-trong-excel-cac-ham-ss-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-cac-ham-ss-2.jpeg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-cac-ham-ss-2-300x169.jpeg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-cac-ham-ss-2-768x432.jpeg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><b>T\u1ea1o c\u00e1c b\u1ed9 l\u1ecdc d\u1ef1a tr\u00ean \u0111i\u1ec1u ki\u1ec7n: <\/b><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m so s\u00e1nh trong Excel nh\u01b0 FILTER ho\u1eb7c c\u00e1c h\u00e0m t\u01b0\u01a1ng t\u1ef1 \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u trong b\u1ea3ng d\u1ef1a tr\u00ean m\u1ed9t ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n.<\/span><\/p>\n<p><b>Ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u00e0 t\u00ecm c\u00e1c \u0111i\u1ec3m t\u01b0\u01a1ng \u0111\u1ed3ng ho\u1eb7c kh\u00e1c bi\u1ec7t:<\/b><span style=\"font-weight: 400;\"> So s\u00e1nh danh s\u00e1ch ng\u01b0\u1eddi d\u00f9ng \u0111\u1ec3 t\u00ecm ra nh\u1eefng ng\u01b0\u1eddi c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3.<\/span><\/p>\n<p><b>X\u00e1c \u0111\u1ecbnh c\u00e1c gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t v\u00e0 nh\u1ecf nh\u1ea5t trong m\u1ed9t t\u1eadp h\u1ee3p d\u1eef li\u1ec7u:<\/b><span style=\"font-weight: 400;\"> S\u1eed d\u1ee5ng c\u00e1c h\u00e0m nh\u01b0 MAX, MIN \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb cao nh\u1ea5t v\u00e0 th\u1ea5p nh\u1ea5t trong m\u1ed9t ph\u1ea1m vi d\u1eef li\u1ec7u.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e0m so s\u00e1nh r\u1ea5t h\u1eefu \u00edch \u0111\u1ec3 gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c quy\u1ebft \u0111\u1ecbnh d\u1ef1a tr\u00ean d\u1eef li\u1ec7u v\u00e0 \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3. \u0110i\u1ec1u n\u00e0y gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 gi\u1ea3m nguy c\u01a1 ph\u00e1t sinh l\u1ed7i so v\u1edbi vi\u1ec7c th\u1ef1c hi\u1ec7n c\u00e1c so s\u00e1nh th\u1ee7 c\u00f4ng.<\/span><\/p>\n<h2><b>H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m so s\u00e1nh trong Excel \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u 2 c\u1ed9t<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nhi\u1ec1u <\/span><span style=\"font-weight: 400;\">h\u00e0m so s\u00e1nh kh\u00e1c nhau <\/span><span style=\"font-weight: 400;\">\u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u \u1edf hai c\u1ed9t kh\u00e1c nhau. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 h\u00e0m ph\u1ed5 bi\u1ebfn, \u0111\u01a1n gi\u1ea3in th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng, h\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile t\u00ecm hi\u1ec3u c\u00e1c h\u00e0m so s\u00e1nh sau :<\/span><\/p>\n<h3><b>D\u00f9ng h\u00e0m EXACT<\/b><\/h3>\n<h4>C\u00fa ph\u00e1p<\/h4>\n<p><span style=\"font-weight: 400;\">H\u00e0m Exact l\u00e0 <\/span><span style=\"font-weight: 400;\">h\u00e0m <\/span><span style=\"font-weight: 400;\">d\u00f9ng \u0111\u1ec3 so s\u00e1nh hai d\u1eef li\u1ec7u (h\u00e0m Excact c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef vi\u1ebft hoa v\u00e0 ch\u1eef vi\u1ebft th\u01b0\u1eddng). N\u1ebfu d\u1eef li\u1ec7u tr\u00f9ng nhau, k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u201cTrue\u201d, trong tr\u01b0\u1eddng h\u1ee3p hai d\u1eef li\u1ec7u kh\u00e1c nhau, k\u1ebft qu\u1ea3 s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u201cFalse\u201d.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p th\u1ef1c hi\u1ec7n: <\/span><b>=EXACT (text 1 &#8211; d\u1eef li\u1ec7u c\u1ea7n so s\u00e1nh s\u1ed1, text 2 &#8211; d\u1eef li\u1ec7u so s\u00e1nh s\u1ed1 2)<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<h4>V\u00ed d\u1ee5<\/h4>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: b\u1ea1n c\u00f3 c\u00e1c d\u1eef li\u1ec7u nh\u01b0 hai c\u1ed9t h\u00ecn h\u1ea3nh minh ho\u1ea1 b\u00ean d\u01b0\u1edbi, v\u00e0 b\u1ea1n mu\u1ed1n th\u1ef1c so s\u00e1nh d\u1eef li\u1ec7u trong hai c\u1ed9t n\u00e0y, b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-excact-1.jpeg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-excact-1-300x169.jpeg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-excact-1-768x432.jpeg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-289971 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-excact-1.jpeg\" alt=\"ham-so-sanh-trong-excel-ham-excact-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-excact-1.jpeg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-excact-1-300x169.jpeg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-excact-1-768x432.jpeg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1:\u00a0 Nh\u1eadp c\u00f4ng th\u1ee9c theo c\u00fa ph\u00e1p sau\u00a0<\/span><b>=Exact($A$2:$A$7;$B$2:$B$7).<\/b><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-exact-2.jpeg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-exact-2-300x169.jpeg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-exact-2-768x432.jpeg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-289969 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-exact-2.jpeg\" alt=\"ham-so-sanh-trong-excel-ham-exact-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-exact-2.jpeg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-exact-2-300x169.jpeg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-exact-2-768x432.jpeg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2:\u00a0Sau khi ho\u00e0n th\u00e0nh nh\u1eadp c\u00f4ng th\u1ee9c, ch\u1ecdn Enter, l\u00fac n\u00e0y h\u00e0m so s\u00e1nh trong Excel &#8211; EXACT s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 nh\u01b0 sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">True:\u00a0D\u1eef li\u1ec7u \u1edf hai c\u1ed9t gi\u1ed1ng nhau.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">False:\u00a0D\u1eef li\u1ec7u \u1edf hai c\u1ed9t kh\u00e1c nhau.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3:\u00a0\u0110\u1ec3 \u00e1p d\u1ee5ng cho c\u00e1c h\u00e0ng b\u00ean d\u01b0\u1edbi, nh\u1ea5n chu\u1ed9t \u1edf g\u00f3c ph\u1ea3i \u00f4 v\u00e0 k\u00e9o xu\u1ed1ng d\u01b0\u1edbi s\u1ebd tr\u1ea3 ra k\u1ebft qu\u1ea3 so s\u00e1nh cho to\u00e0n b\u1ed9 d\u1eef li\u1ec7u. C\u00f3 th\u1ec3 th\u1ea5y k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1, \u0111\u1ed1i v\u1edbi lo\u1ea1i tr\u00e1i c\u00e2y \u0111\u1ec1u \u0111\u01b0\u1ee3c vi\u1ebft in hoa \u1edf hai c\u1ed9t, k\u1ebft qu\u1ea3 tr\u1ea3 ra s\u1ebd l\u00e0 gi\u00e1 tr\u1ecb True, tr\u01b0\u1eddng h\u1ee3p c\u00f2n l\u1ea1i k\u1ebft qu\u1ea3 gi\u00e1 tr\u1ecb l\u00e0 False.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-exact-3.jpeg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-exact-3-300x169.jpeg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-exact-3-768x432.jpeg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-289970 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-exact-3.jpeg\" alt=\"ham-so-sanh-trong-excel-ham-exact-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-exact-3.jpeg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-exact-3-300x169.jpeg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-exact-3-768x432.jpeg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><b>D\u00f9ng h\u00e0m COUNTIF<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m COUNTIF trong Excel l\u00e0 m\u1ed9t h\u00e0m \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 trong m\u1ed9t ph\u1ea1m vi (range) m\u00e0 th\u1ecfa m\u00e3n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3. H\u00e0m Countif c\u0169ng l\u00e0 <\/span><span style=\"font-weight: 400;\">h\u00e0m so s\u00e1nh trong excel, <\/span><span style=\"font-weight: 400;\">\u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 so s\u00e1nh 2 c\u1ed9t d\u1eef li\u1ec7u, kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng v\u00e0 so s\u00e1nh d\u1ef1a tr\u00ean m\u1ed9t ti\u00eau ch\u00ed nh\u1ea5t \u0111\u1ecbnh.<\/span><\/p>\n<h4>C\u00fa ph\u00e1p<\/h4>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p th\u1ef1c hi\u1ec7n h\u00e0m Countif: <\/span><b>=COUNTIF(Range,Criteria)<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Range: Ph\u1ea1m vi d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Criteria: \u0110i\u1ec1u ki\u1ec7n m\u00e0 \u00f4 c\u1ea7n ph\u1ea3i th\u1ecfa m\u00e3n \u0111\u1ec3 \u0111\u01b0\u1ee3c \u0111\u1ebfm.<\/span><\/li>\n<\/ul>\n<h4>V\u00ed d\u1ee5<\/h4>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: Khi c\u1ea7n th\u1ef1c hi\u1ec7n so s\u00e1nh 2 c\u1ed9t danh s\u00e1ch 1,2 b\u00ean d\u01b0\u1edbi. Y\u00eau c\u1ea7u \u0111\u1eb7t ra l\u00e0 ph\u1ea3i t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng thu\u1ed9c danh s\u00e1ch 1 m\u00e0 thu\u1ed9c danh s\u00e1ch 2 v\u00e0 ng\u01b0\u1ee3c l\u1ea1i. \u0110\u1ec3 ti\u1ebfn h\u00e0nh so s\u00e1nh, b\u1ea1n d\u00f9ng h\u00e0m Countif v\u00e0 th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif.jpeg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-300x169.jpeg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-768x432.jpeg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-289960 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif.jpeg\" alt=\"ham-so-sanh-trong-excel-ham-counif\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif.jpeg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-300x169.jpeg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-768x432.jpeg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Ti\u1ebfn h\u00e0nh nh\u1eadp t\u00ean ti\u00eau \u0111\u1ec1 cho 2 c\u1ed9t danh s\u00e1ch 1, danh s\u00e1ch 2.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u00f4i \u0111en to\u00e0n b\u1ed9 v\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n so s\u00e1nh c\u1ee7a danh s\u00e1ch 1 (l\u01b0u \u00fd kh\u00f4ng b\u00f4i \u0111en ph\u1ea7n ti\u00eau \u0111\u1ec1). T\u1ea1i \u00f4 \u0111\u1ecba ch\u1ec9, th\u1ef1c hi\u1ec7n nh\u1eadp t\u00ean Danhsach1, ti\u1ebfp t\u1ee5c b\u1ea5m Enter.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-1.jpeg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-1-300x169.jpeg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-1-768x432.jpeg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-289961 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-1.jpeg\" alt=\"ham-so-sanh-trong-excel-ham-counif-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-1.jpeg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-1-300x169.jpeg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-1-768x432.jpeg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: T\u1ea1i tab Home, nh\u1ea5n ch\u1ecdn Conditional Formatting &gt; New Rule.<\/span><\/p>\n<figure id=\"attachment_289962\" aria-describedby=\"caption-attachment-289962\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-2.jpeg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-2-300x169.jpeg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-2-768x432.jpeg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-289962 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-2.jpeg\" alt=\"ham-so-sanh-trong-excel-ham-counif-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-2.jpeg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-2-300x169.jpeg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-2-768x432.jpeg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-289962\" class=\"wp-caption-text\"><em>V\u00ed d\u1ee5 h\u00e0m so s\u00e1nh trong Excel &#8211; d\u00f9ng h\u00e0m COUNTIF<\/em><\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3:\u00a0 T\u1ea1i m\u1ee5c\u00a0 New Formatting Rule, ch\u1ecdn \u201cUse a formula to determine which cells to format\u201d.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Nh\u1eadp c\u00fa ph\u00e1p =COUNTIF(danhsach2,A2)=0, ti\u1ebfp t\u1ee5c ch\u1ecdn Format.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u1edbi c\u00fa ph\u00e1p \u201c=COUNTIF(danhsach2,A2)\u201d, th\u1ef1c hi\u1ec7n \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb trong danhsach2 v\u00e0 so s\u00e1nh v\u1edbi gi\u00e1 tr\u1ecb t\u1eeb A2 thu\u1ed9c danhsach1<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong khi \u0111\u00f3, \u201c=0\u201d c\u00f3 vai tr\u00f2 l\u00e0: n\u1ebfu danhsach2 kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb n\u00e0o gi\u1ed1ng danhsach1 th\u00ec Excel s\u1ebd hi\u1ec3u gi\u00e1 tr\u1ecb \u0111\u00f3 l\u00e0 0 v\u00e0 s\u1ebd ti\u1ebfn h\u00e0nh \u0111\u1ecbnh d\u1ea1ng cho gi\u00e1 tr\u1ecb 0 \u0111\u00f3 theo m\u00e0u.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-3.jpeg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-3-300x169.jpeg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-3-768x432.jpeg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-289963 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-3.jpeg\" alt=\"ham-so-sanh-trong-excel-ham-counif-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-3.jpeg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-3-300x169.jpeg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-3-768x432.jpeg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4:\u00a0 T\u1ea1i Format Cells, nh\u1ea5n v\u00e0o Fill, ti\u1ebfp t\u1ee5c nh\u1ea5n m\u00e0u \u0111\u00e1nh d\u1ea5u gi\u00e1 tr\u1ecb kh\u00f4ng thu\u1ed9c danhsach2, ti\u1ebfp t\u1ee5c ch\u1ecdn OK.<\/span><\/p>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-4.jpeg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-4-300x169.jpeg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-4-768x432.jpeg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-289964 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-4.jpeg\" alt=\"ham-so-sanh-trong-excel-ham-counif-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-4.jpeg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-4-300x169.jpeg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-4-768x432.jpeg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 5:\u00a0 Ti\u1ebfp t\u1ee5c ch\u1ecdn OK, \u0111\u1ec3 ch\u1ecdn m\u00e0u ph\u00e2n bi\u1ec7t \u1edf danhsach1 trong h\u00e0m so s\u00e1nh trong Excel &#8211; COUNTIF.<\/span><\/p>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-289986 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-5.jpg\" alt=\"ham-so-sanh-trong-excel-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 6: Th\u1ef1c hi\u1ec7n t\u01b0\u01a1ng t\u1ef1 B\u01b0\u1edbc 3, v\u1edbi c\u00f4ng th\u1ee9c thay b\u1eb1ng =COUNTIF(danhsach1,C2)=0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-6.jpeg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-6-300x169.jpeg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-6-768x432.jpeg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-289967 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-6.jpeg\" alt=\"ham-so-sanh-trong-excel-ham-counif-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-6.jpeg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-6-300x169.jpeg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-6-768x432.jpeg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">\u00a0L\u00fac n\u00e0y k\u1ebft qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 nh\u01b0 sau:<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-7.jpeg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-7-300x169.jpeg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-7-768x432.jpeg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-289968 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-7.jpeg\" alt=\"ham-so-sanh-trong-excel-ham-counif-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-7.jpeg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-7-300x169.jpeg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-ham-counif-7-768x432.jpeg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><b>C\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi d\u00f9ng h\u00e0m<\/b><b> so s\u00e1nh trong Excel <\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Khi th\u1ef1c hi\u1ec7n <\/span><span style=\"font-weight: 400;\">h\u00e0m so s\u00e1nh, <\/span><span style=\"font-weight: 400;\">m\u1ed9t s\u1ed1 l\u1ed7i ph\u1ed5 bi\u1ebfn m\u00e0 ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng g\u1eb7p. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c ch\u00fang:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Sai c\u00fa ph\u00e1p h\u00e0m: \u0110\u00e2y l\u00e0 kh\u00e1 ph\u1ed5 bi\u1ebfn khi th\u1ef1c hi\u1ec7n <\/span><span style=\"font-weight: 400;\">h\u00e0m so s\u00e1nh<\/span><span style=\"font-weight: 400;\">. B\u1ea1n n\u00ean l\u01b0u \u00fd nh\u1eadp c\u00fa ph\u00e1p \u0111\u00fang cho h\u00e0m so s\u00e1nh v\u00e0 ki\u1ec3m tra xem \u0111\u00e3 \u0111\u1eb7t d\u1ea5u ph\u1ea9y, ngo\u1eb7c \u0111\u01a1n \u0111\u00fang c\u00e1ch ch\u01b0a.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">So s\u00e1nh v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng t\u01b0\u01a1ng t\u1ef1: C\u00e1c h\u00e0m so s\u00e1nh y\u00eau c\u1ea7u c\u00e1c gi\u00e1 tr\u1ecb c\u00f3 th\u1ec3 so s\u00e1nh. So s\u00e1nh gi\u1eefa c\u00e1c lo\u1ea1i d\u1eef li\u1ec7u kh\u00f4ng ph\u00f9 h\u1ee3p c\u00f3 th\u1ec3 d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 kh\u00f4ng ch\u00ednh x\u00e1c.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">So s\u00e1nh v\u1edbi d\u1ea5u c\u00e1ch ho\u1eb7c gi\u00e1 tr\u1ecb r\u1ed7ng: N\u1ebfu m\u1ed9t trong c\u00e1c \u00f4 \u0111ang so s\u00e1nh ch\u1ee9a d\u1ea5u c\u00e1ch ho\u1eb7c l\u00e0 \u00f4 tr\u1ed1ng, \u0111i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 kh\u00f4ng ch\u00ednh x\u00e1c.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-cac-loi-thuong-gap.jpeg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-cac-loi-thuong-gap-300x169.jpeg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/11\/ham-so-sanh-trong-excel-cac-loi-thuong-gap-768x432.jpeg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-289955 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-cac-loi-thuong-gap.jpeg\" alt=\"ham-so-sanh-trong-excel-cac-loi-thuong-gap\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-cac-loi-thuong-gap.jpeg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-cac-loi-thuong-gap-300x169.jpeg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-cac-loi-thuong-gap-768x432.jpeg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Thi\u1ebfu d\u1ea5u ngo\u1eb7c \u0111\u00f3ng ho\u1eb7c m\u1edf: Khi qu\u00ean \u0111\u00f3ng ngo\u1eb7c \u0111\u01a1n ho\u1eb7c m\u1edf ngo\u1eb7c \u0111\u01a1n \u0111\u00fang c\u00e1ch c\u0169ng c\u00f3 th\u1ec3 d\u1eabn \u0111\u1ebfn l\u1ed7i.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng h\u00e0m so s\u00e1nh trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u kh\u00f4ng ph\u00f9 h\u1ee3p: B\u1ea1n c\u1ea7n ch\u1ecdn \u0111\u00fang ph\u1ea1m vi d\u1eef li\u1ec7u \u0111\u1ec3 \u00e1p d\u1ee5ng <\/span><span style=\"font-weight: 400;\">h\u00e0m so s\u00e1nh trong Excel<\/span><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Thay \u0111\u1ed5i d\u1eef li\u1ec7u ngu\u1ed3n: N\u1ebfu d\u1eef li\u1ec7u ngu\u1ed3n thay \u0111\u1ed5i, h\u00e3y \u0111\u1ea3m b\u1ea3o r\u1eb1ng c\u00e1c h\u00e0m so s\u00e1nh v\u1eabn ph\u00f9 h\u1ee3p v\u1edbi d\u1eef li\u1ec7u m\u1edbi.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Kh\u00f4ng ki\u1ec3m tra k\u1ebft qu\u1ea3 tr\u01b0\u1edbc v\u00e0 sau khi so s\u00e1nh: Lu\u00f4n ki\u1ec3m tra k\u1ebft qu\u1ea3 <\/span><span style=\"font-weight: 400;\">c\u1ee7a h\u00e0m so s\u00e1nh <\/span><span style=\"font-weight: 400;\">\u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Sai so s\u00e1nh logic: \u0110\u1ed1i v\u1edbi c\u00e1c h\u00e0m logic nh\u01b0 AND v\u00e0 OR, b\u1ea1n c\u1ea7n x\u00e1c \u0111\u1ecbnh c\u00e1c \u0111i\u1ec1u ki\u1ec7n logic \u0111\u00fang c\u00e1ch.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Khi g\u1eb7p l\u1ed7i, h\u00e3y ki\u1ec3m tra l\u1ea1i c\u00f4ng th\u1ee9c. Ngo\u00e0i ra, c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 g\u1ee1 l\u1ed7i c\u1ee7a Excel \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u00e0 s\u1eeda l\u1ed7i.<\/span><\/p>\n<h2><b>T\u1ea1m k\u1ebft<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Th\u00f4ng qua b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile \u0111\u00e3 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch th\u1ef1c hi\u1ec7n <\/span><span style=\"font-weight: 400;\">h\u00e0m so s\u00e1nh trong Excel <\/span><span style=\"font-weight: 400;\">\u0111\u1ec3 so s\u00e1nh hai c\u1ed9t d\u1eef li\u1ec7u. B\u00ean c\u1ea1nh \u0111\u00f3, h\u00e3y ch\u00fa \u00fd \u0111\u1ebfn c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p c\u0169ng nh\u01b0 l\u01b0u \u00fd c\u1ea7n ch\u00fa \u00fd khi s\u1eed d\u1ee5ng <\/span><span style=\"font-weight: 400;\">h\u00e0m so s\u00e1nh \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u1ed1t nh\u1ea5t nh\u00e9<\/span><span style=\"font-weight: 400;\">. Qua \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng c\u1ee5 n\u00e0y qu\u00e1 tr\u00ecnh x\u1eed l\u00fd, ph\u00e2n t\u00edch d\u1eef li\u1ec7u, t\u1ed1i \u0111a ho\u00e1 qu\u00e1 th\u1eddi gian v\u00e0 hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c. <\/span><span style=\"font-weight: 400;\">\u0110\u1eebng qu\u00ean \u0111\u00f3n \u0111\u1ecdc nh\u1eefng b\u00e0i vi\u1ebft s\u1eafp t\u1edbi c\u1ee7a ch\u00fang t\u00f4i \u0111\u1ec3 c\u1eadp nh\u1eadt nh\u1eefng ki\u1ebfn th\u1ee9c v\u00e0 k\u1ef9 n\u0103ng v\u0103n ph\u00f2ng m\u1edbi nh\u00e9!<\/span><\/p>\n<p>XEM TH\u00caM:<\/p>\n<ul>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ref\/\">C\u00e1ch s\u1eeda l\u1ed7i #REF! trong Excel c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/them-cot-trong-excel\/\">C\u00e1ch ch\u00e8n th\u00eam c\u1ed9t trong Excel: H\u01b0\u1edbng d\u1eabn chi ti\u1ebft t\u1eeb A \u0111\u1ebfn Z<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Excel l\u00e0 c\u00f4ng c\u1ee5 ph\u1ed5 bi\u1ebfn \u0111\u1ed1i v\u1edbi \u0111a s\u1ed1 ng\u01b0\u1eddi d\u00f9ng v\u0103n ph\u00f2ng. Trong \u0111\u00f3, h\u00e0m so s\u00e1nh trong Excel l\u00e0 c\u00f4ng c\u1ee5 \u0111\u1eafc l\u1ef1c khi b\u1ea1n c\u1ea7n ki\u1ec3m tra s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa c\u00e1c c\u1ed9t, gi\u00fap t\u1ed1i \u01b0u h\u00f3a th\u1eddi gian so s\u00e1nh d\u1eef li\u1ec7u tr\u00ean Excel. B\u00e0i vi\u1ebft b\u00ean d\u01b0\u1edbi, Ho\u00e0ng H\u00e0 [&hellip;]<\/p>\n","protected":false},"author":83,"featured_media":289978,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-289943","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1ch d\u00f9ng h\u00e0m so s\u00e1nh trong Excel \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u 2 c\u1ed9t<\/title>\n<meta name=\"description\" content=\"B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch d\u00f9ng h\u00e0m so s\u00e1nh trong Excel \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u trong c\u00e1c c\u1ed9t ch\u01b0a? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u ngay v\u00e0 xem v\u00ed d\u1ee5 minh h\u1ecda 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:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch d\u00f9ng h\u00e0m so s\u00e1nh \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u 2 c\u1ed9t trong Excel \u0111\u01a1n gi\u1ea3n chi ti\u1ebft nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch d\u00f9ng h\u00e0m so s\u00e1nh trong Excel \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u trong c\u00e1c c\u1ed9t ch\u01b0a? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u ngay v\u00e0 xem v\u00ed d\u1ee5 minh h\u1ecda nh\u00e9!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-27T13:40:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-thumbnail.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Do Tuyet Nhi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Do Tuyet Nhi\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/\"},\"author\":{\"name\":\"Do Tuyet Nhi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bba0f0fb7a9ee063d98abf6557ccdaee\"},\"headline\":\"C\u00e1ch d\u00f9ng h\u00e0m so s\u00e1nh \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u 2 c\u1ed9t trong Excel \u0111\u01a1n gi\u1ea3n chi ti\u1ebft nh\u1ea5t\",\"datePublished\":\"2023-11-27T13:40:46+00:00\",\"dateModified\":\"2023-11-27T13:40:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/\"},\"wordCount\":2954,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-thumbnail.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/\",\"name\":\"C\u00e1ch d\u00f9ng h\u00e0m so s\u00e1nh trong Excel \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u 2 c\u1ed9t\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-thumbnail.jpg\",\"datePublished\":\"2023-11-27T13:40:46+00:00\",\"dateModified\":\"2023-11-27T13:40:46+00:00\",\"description\":\"B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch d\u00f9ng h\u00e0m so s\u00e1nh trong Excel \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u trong c\u00e1c c\u1ed9t ch\u01b0a? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u ngay v\u00e0 xem v\u00ed d\u1ee5 minh h\u1ecda nh\u00e9!\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-thumbnail.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-thumbnail.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-so-sanh-trong-excel-thumbnail\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"C\u00e1ch d\u00f9ng h\u00e0m so s\u00e1nh \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u 2 c\u1ed9t trong Excel \u0111\u01a1n gi\u1ea3n chi ti\u1ebft nh\u1ea5t\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bba0f0fb7a9ee063d98abf6557ccdaee\",\"name\":\"Do Tuyet Nhi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/12dd398f8abe479231672d9ef7fb0a0c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/12dd398f8abe479231672d9ef7fb0a0c?s=96&d=mm&r=g\",\"caption\":\"Do Tuyet Nhi\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/do-tuyet-nhi\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch d\u00f9ng h\u00e0m so s\u00e1nh trong Excel \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u 2 c\u1ed9t","description":"B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch d\u00f9ng h\u00e0m so s\u00e1nh trong Excel \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u trong c\u00e1c c\u1ed9t ch\u01b0a? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u ngay v\u00e0 xem v\u00ed d\u1ee5 minh h\u1ecda 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:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch d\u00f9ng h\u00e0m so s\u00e1nh \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u 2 c\u1ed9t trong Excel \u0111\u01a1n gi\u1ea3n chi ti\u1ebft nh\u1ea5t","og_description":"B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch d\u00f9ng h\u00e0m so s\u00e1nh trong Excel \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u trong c\u00e1c c\u1ed9t ch\u01b0a? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u ngay v\u00e0 xem v\u00ed d\u1ee5 minh h\u1ecda nh\u00e9!","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-11-27T13:40:46+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-thumbnail.jpg","type":"image\/jpeg"}],"author":"Do Tuyet Nhi","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Do Tuyet Nhi","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"14 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/"},"author":{"name":"Do Tuyet Nhi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bba0f0fb7a9ee063d98abf6557ccdaee"},"headline":"C\u00e1ch d\u00f9ng h\u00e0m so s\u00e1nh \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u 2 c\u1ed9t trong Excel \u0111\u01a1n gi\u1ea3n chi ti\u1ebft nh\u1ea5t","datePublished":"2023-11-27T13:40:46+00:00","dateModified":"2023-11-27T13:40:46+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/"},"wordCount":2954,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-thumbnail.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/","name":"C\u00e1ch d\u00f9ng h\u00e0m so s\u00e1nh trong Excel \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u 2 c\u1ed9t","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-thumbnail.jpg","datePublished":"2023-11-27T13:40:46+00:00","dateModified":"2023-11-27T13:40:46+00:00","description":"B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch d\u00f9ng h\u00e0m so s\u00e1nh trong Excel \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u trong c\u00e1c c\u1ed9t ch\u01b0a? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u ngay v\u00e0 xem v\u00ed d\u1ee5 minh h\u1ecda nh\u00e9!","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-thumbnail.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/11\/ham-so-sanh-trong-excel-thumbnail.jpg","width":1200,"height":628,"caption":"ham-so-sanh-trong-excel-thumbnail"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"C\u00e1ch d\u00f9ng h\u00e0m so s\u00e1nh \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u 2 c\u1ed9t trong Excel \u0111\u01a1n gi\u1ea3n chi ti\u1ebft nh\u1ea5t"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bba0f0fb7a9ee063d98abf6557ccdaee","name":"Do Tuyet Nhi","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/12dd398f8abe479231672d9ef7fb0a0c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/12dd398f8abe479231672d9ef7fb0a0c?s=96&d=mm&r=g","caption":"Do Tuyet Nhi"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/do-tuyet-nhi\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/289943","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=289943"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/289943\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/289978"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=289943"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=289943"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=289943"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}