{"id":13108,"date":"2022-11-23T16:33:35","date_gmt":"2022-11-23T09:33:35","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=13108"},"modified":"2022-12-07T16:08:33","modified_gmt":"2022-12-07T09:08:33","slug":"cach-loc-trung-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/","title":{"rendered":"C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft"},"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;13108&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;C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft&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 style=\"text-align: justify;\"><em><span style=\"font-weight: 400;\"><strong>C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel<\/strong> gi\u00fap lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u xu\u1ea5t hi\u1ec7n tr\u00f9ng nhau. N\u1ebfu b\u1ea1n \u0111ang b\u0103n kho\u0103n kh\u00f4ng bi\u1ebft l\u1ecdc th\u00f4ng tin n\u00e0y nh\u01b0 th\u1ebf n\u00e0o th\u00ec h\u00e3y theo d\u00f5i ngay b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y<\/span><span style=\"font-weight: 400;\">. TEKY s\u1ebd b\u1eadt m\u00ed t\u1edbi b\u1ea1n gi\u1ea3i ph\u00e1p l\u1ecdc tr\u00f9ng d\u1eef li\u1ec7u th\u00f4ng minh, ti\u1ec7n l\u1ee3i trong Excel ch\u1ec9 v\u1edbi v\u00e0i b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n.<\/span><\/em><\/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\/cach-loc-trung-trong-excel\/#Loc_trung_trong_Excel_la_gi\" >L\u1ecdc tr\u00f9ng trong Excel l\u00e0 g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/#Cach_loc_trung_trong_Excel_voi_cac_gia_tri_duy_nhat\" >C\u00e1ch l\u1ecdc tr\u00f9ng trong\u00a0Excel v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/#Loai_bo_cac_gia_tri_trung_lap\" >Lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/#Ap_dung_dinh_dang_co_dieu_kien_cho_cac_gia_tri_duy_nhat_hoac_trung_lap\" >\u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t ho\u1eb7c tr\u00f9ng l\u1eb7p<\/a><\/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\/cach-loc-trung-trong-excel\/#Cach_loc_trung_trong_Excel_voi_quy_tac_dinh_dang_co_dieu_kien_nang_cao\" >C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel v\u1edbi quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n n\u00e2ng cao\u00a0<\/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\/cach-loc-trung-trong-excel\/#Chinh_sua_quy_tac_dinh_dang_dieu_kien_nang_cao_hon\" >Ch\u1ec9nh s\u1eeda quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng \u0111i\u1ec1u ki\u1ec7n n\u00e2ng cao h\u01a1n<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Loc_trung_trong_Excel_la_gi\"><\/span><b>L\u1ecdc tr\u00f9ng trong Excel l\u00e0 g\u00ec?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u1ecdc c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong n\u00f3 v\u00e0 lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p ngo\u00e0i n\u00f3 l\u00e0 hai nhi\u1ec7m v\u1ee5 c\u00f3 li\u00ean quan ch\u1eb7t ch\u1ebd v\u1edbi nhau. B\u1edfi\u00a0 k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb l\u00e0 gi\u1ed1ng nhau &#8211; danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t. Tuy nhi\u00ean, kh\u00e1c bi\u1ec7t l\u00e0 r\u1ea5t quan tr\u1ecdng. Khi b\u1ea1n l\u1ecdc c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t, b\u1ea1n t\u1ea1m th\u1eddi \u1ea9n c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p,. Nh\u01b0ng khi b\u1ea1n x\u00f3a c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p, b\u1ea1n s\u1ebd x\u00f3a v\u0129nh vi\u1ec5n c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p.<\/span><\/p>\n<figure id=\"attachment_13110\" aria-describedby=\"caption-attachment-13110\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13110 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel-1.jpg\" alt=\"L\u1ecdc tr\u00f9ng trong Excel l\u00e0 g\u00ec?\" width=\"600\" height=\"434\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel-1-400x289.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13110\" class=\"wp-caption-text\">L\u1ecdc tr\u00f9ng trong Excel l\u00e0 g\u00ec?<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"> Gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p l\u00e0 gi\u00e1 tr\u1ecb trong \u0111\u00f3 t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb trong h\u00e0ng kh\u1edbp ch\u00ednh x\u00e1c v\u1edbi t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb trong h\u00e0ng kh\u00e1c. C\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1edfi gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong \u00f4. Kh\u00f4ng nh\u1ea5t thi\u1ebft ph\u1ea3i l\u00e0 gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong \u00f4. V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n c\u00f3 c\u00f9ng m\u1ed9t gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng trong c\u00e1c \u00f4 kh\u00e1c nhau. M\u1ed9t \u00f4 c\u00f3 \u0111\u1ecbnh d\u1ea1ng l\u00e0 &#8220;12\/8\/2017&#8221; v\u00e0 \u00f4 c\u00f2n l\u1ea1i l\u00e0 &#8220;8 th\u00e1ng 12 n\u0103m 2017&#8221;, c\u00e1c gi\u00e1 tr\u1ecb l\u00e0 duy nh\u1ea5t.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u01b0u \u00fd: N\u1ebfu c\u00f4ng th\u1ee9c trong c\u00e1c \u00f4 kh\u00e1c nhau, nh\u01b0ng gi\u00e1 tr\u1ecb gi\u1ed1ng nhau, ch\u00fang \u0111\u01b0\u1ee3c coi l\u00e0 tr\u00f9ng l\u1eb7p. V\u00ed d\u1ee5: n\u1ebfu \u00f4 A1 c\u00f3 ch\u1ee9a c\u00f4ng th\u1ee9c l\u00e0 = 2 -1 v\u00e0 \u1edf \u00f4 A2 ch\u1ee9a c\u00f4ng th\u1ee9c l\u00e0 = 3 -2. Mi\u1ec5n l\u00e0 gi\u00e1 tr\u1ecb ch\u00fang \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng gi\u1ed1ng t\u01b0\u01a1ng \u0111\u01b0\u01a1ng nhau. Ch\u00fang \u0111\u01b0\u1ee3c coi l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu c\u00f9ng m\u1ed9t m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng b\u1eb1ng c\u00e1c \u0111\u1ecbnh d\u1ea1ng s\u1ed1 kh\u00e1c nhau, ch\u00fang kh\u00f4ng \u0111\u01b0\u1ee3c coi l\u00e0 tr\u00f9ng l\u1eb7p. V\u00ed d\u1ee5: n\u1ebfu gi\u00e1 tr\u1ecb trong \u00f4 A1 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng l\u00e0 1,00 v\u00e0 gi\u00e1 tr\u1ecb trong \u00f4 A2 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng l\u00e0 1. Ch\u00fang kh\u00f4ng \u0111\u01b0\u1ee3c coi l\u00e0 tr\u00f9ng l\u1eb7p.\u00a0<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"4 C\u00e1ch x\u00f3a d\u1eef li\u1ec7u tr\u00f9ng trong excel\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/viM7VrmccOM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_loc_trung_trong_Excel_voi_cac_gia_tri_duy_nhat\"><\/span>C\u00e1ch l\u1ecdc tr\u00f9ng trong\u00a0Excel v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Ch\u1ecdn ph\u1ea1m vi \u00f4 tr\u1ed1ng ho\u1eb7c \u0111\u1ea3m b\u1ea3o r\u1eb1ng \u00f4 hi\u1ec7n ho\u1ea1t \u0111\u1ed9ng n\u1eb1m trong b\u1ea3ng. Tr\u00ean tab d\u1eef li\u1ec7u, trong nh\u00f3m s\u1eafp x\u1ebfp &amp; l\u1ecdc. H\u00e3y b\u1ea5m n\u00e2ng cao<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: L\u00e0m m\u1ed9t \u0111i\u1ec1u trong s\u1ed1 sau \u0111\u00e2y: Tr\u00ean tab \u1ed5 d\u1eef li\u1ec7u , trong nh\u00f3m s\u1eafp x\u1ebfp g\u1ecdn v\u00e0 l\u1ecdc. H\u00e3y b\u1ea5m n\u00e2ng cao<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c sau.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_13111\" aria-describedby=\"caption-attachment-13111\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13111 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel-2.png\" alt=\"C\u00e1ch l\u1ecdc tr\u00f9ng trong\u00a0Excel v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t\" width=\"600\" height=\"456\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel-2.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel-2-400x304.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13111\" class=\"wp-caption-text\">C\u00e1ch l\u1ecdc tr\u00f9ng trong\u00a0Excel v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">+ L\u1ecdc ph\u1ea1m vi \u00f4 ho\u1eb7c b\u1ea3ng t\u1ea1i ch\u1ed7\u00a0 \u2014) Ti\u1ebfp \u0111\u1ebfn ch\u1ecdn ph\u1ea1m vi \u00f4. Sau \u0111\u00f3 b\u1ea5m <\/span><span style=\"font-weight: 400;\">l\u1ecdc danh s\u00e1ch, t\u1ea1i ch\u1ed7\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">+ Sao ch\u00e9p k\u1ebft qu\u1ea3 c\u1ee7a b\u1ed9 l\u1ecdc sang m\u1ed9t v\u1ecb tr\u00ed kh\u00e1c. Ch\u1ecdn ph\u1ea1m vi \u00f4, b\u1ea5m Sao ch\u00e9p sang m\u1ed9t v\u1ecb tr\u00ed kh\u00e1c. Sau \u0111\u00f3 trong h\u1ed9p Sao ch\u00e9p v\u00e0o, nh\u1eadp tham chi\u1ebfu \u00f4.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u01b0u \u00fd: N\u1ebfu b\u1ea1n sao ch\u00e9p <\/span><span style=\"font-weight: 400;\">k\u1ebft qu\u1ea3 c\u1ee7a b\u1ed9 l\u1ecdc sang v\u1ecb tr\u00ed kh\u00e1c, c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t t\u1eeb \u200b\u200bph\u1ea1m vi \u0111\u00e3 ch\u1ecdn s\u1ebd \u0111\u01b0\u1ee3c sao ch\u00e9p sang v\u1ecb tr\u00ed m\u1edbi. D\u1eef li\u1ec7u g\u1ed1c s\u1ebd kh\u00f4ng b\u1ecb \u1ea3nh h\u01b0\u1edfng g\u00ec.<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: Ch\u1ecdn h\u1ed9p ki\u1ebfm ch\u1ec9 m\u1ed9t b\u1ea3n ghi duy nh\u1ea5t , r\u1ed3i sau \u0111\u00f3 b\u1ea5m \u2018 ok \u2018\u00a0<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Loai_bo_cac_gia_tri_trung_lap\"><\/span><b>Lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi b\u1ea1n x\u00f3a c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p, ch\u1ec9 c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi \u00f4 ho\u1eb7c b\u1ea3ng \u0111\u00e3 ch\u1ecdn b\u1ecb \u1ea3nh h\u01b0\u1edfng. B\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o kh\u00e1c ngo\u00e0i ph\u1ea1m vi \u00f4 ho\u1eb7c b\u1ea3ng kh\u00f4ng b\u1ecb thay \u0111\u1ed5i ho\u1eb7c di chuy\u1ec3n. V\u00ec b\u1ea1n \u0111ang x\u00f3a d\u1eef li\u1ec7u v\u0129nh vi\u1ec5n, n\u00ean t\u1ed1t h\u01a1n h\u1ebft b\u1ea1n n\u00ean sao ch\u00e9p ph\u1ea1m vi \u00f4 ho\u1eb7c b\u1ea3n g\u1ed1c sang m\u1ed9t trang t\u00ednh. Ho\u1eb7c c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n trong s\u1ed5 l\u00e0m vi\u1ec7c tr\u01b0\u1edbc khi x\u00f3a \u0111i c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00e3 tr\u00f9ng l\u1eb7p.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u01b0u \u00fd: B\u1ea1n kh\u00f4ng th\u1ec3 x\u00f3a c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p kh\u1ecfi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ph\u00e1c th\u1ea3o ho\u1eb7c c\u00f3 t\u1ed5ng ph\u1ee5. \u0110\u1ec3 x\u00f3a c\u00e1c ph\u1ea7n tr\u00f9ng l\u1eb7p, tr\u01b0\u1edbc ti\u00ean b\u1ea1n ph\u1ea3i x\u00f3a c\u00e1c \u0111\u01b0\u1eddng vi\u1ec1n v\u00e0 t\u1ed5ng ph\u1ee5.\u00a0<\/span><\/p>\n<figure id=\"attachment_13112\" aria-describedby=\"caption-attachment-13112\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13112 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel-3.png\" alt=\"Lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p\" width=\"600\" height=\"306\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel-3.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel-3-400x204.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13112\" class=\"wp-caption-text\">Lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p<\/figcaption><\/figure>\n<ul>\n<li><span style=\"font-weight: 400;\">Ch\u1ecdn ph\u1ea1m vi \u00f4 ho\u1eb7c \u0111\u1ea3m b\u1ea3o r\u1eb1ng \u00f4 hi\u1ec7n ho\u1ea1t \u0111\u1ed9ng n\u1eb1m trong b\u1ea3ng \u0111\u00f3.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Tr\u00ean tab d\u1eef li\u1ec7u, \u1edf trong nh\u00f3m c\u00e1c c\u00f4ng c\u1ee5 d\u1eef li\u1ec7u, h\u00e3y b\u1ea5m lo\u1ea1i b\u1ecf \u0111i b\u1ea3n sao.<\/span><\/li>\n<li>Ch\u1ecdn m\u1ed9t ho\u1eb7c nhi\u1ec1u h\u1ed9p ki\u1ec3m tham chi\u1ebfu \u0111\u1ebfn c\u00e1c c\u1ed9t trong b\u1ea3ng. Sau \u0111\u00f3 b\u1ea5m lo\u1ea1i b\u1ecf c\u00e1c b\u1ea3n sao .<\/li>\n<\/ul>\n<p><b>M\u1eb9o: <\/b><span style=\"font-weight: 400;\">\u00a0N\u1ebfu ph\u1ea1m vi \u00f4 ho\u1eb7c b\u1ea3ng ch\u1ee9a nhi\u1ec1u c\u1ed9t v\u00e0 b\u1ea1n ch\u1ec9 mu\u1ed1n ch\u1ecdn m\u1ed9t v\u00e0i c\u1ed9t. H\u00e3y b\u1ecf ch\u1ecdn h\u1ed9p ki\u1ec3m <\/span>ch\u1ecdn t\u1ea5t c\u1ea3<span style=\"font-weight: 400;\"> v\u00e0 ch\u1ec9 ch\u1ecdn c\u00e1c c\u1ed9t b\u1ea1n mu\u1ed1n.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ap_dung_dinh_dang_co_dieu_kien_cho_cac_gia_tri_duy_nhat_hoac_trung_lap\"><\/span><b>\u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t ho\u1eb7c tr\u00f9ng l\u1eb7p<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t ho\u1eb7c tr\u00f9ng l\u1eb7p \u0111\u1ec3 c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng nh\u00ecn th\u1ea5y ch\u00fang. V\u00ed d\u1ee5: M\u00e3 h\u00f3a m\u00e0u s\u1eafc d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed. N\u1ebfu c\u1ea7n, h\u00e3y x\u00f3a d\u1eef li\u1ec7u \u0111\u00f3.<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Ch\u1ecdn m\u1ed9t ho\u1eb7c c\u1ef1c nhi\u1ec1u \u00f4 n\u1eb1m trong b\u00e1o c\u00e1o ph\u1ea1m vi, b\u1ea3ng ho\u1eb7c l\u00e0 pivottable.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Tr\u00ean tab trang \u0111\u1ea7u, trong nh\u00f3m ki\u1ec3u, b\u1ea5m \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n. Tr\u1ecf \u0111\u1ebfn \u0111\u00e1nh d\u1ea5u quy t\u1eafc \u00f4. R\u1ed3i b\u1ea5m gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p .<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Ch\u1ecdn c\u00e1c t\u00f9y ch\u1ecdn b\u1ea1n mu\u1ed1n trong h\u1ed9p tho\u1ea1i quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng m\u1edbi. Cu\u1ed1i c\u00f9ng b\u1ea5m &#8220;ok&#8221;.<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_loc_trung_trong_Excel_voi_quy_tac_dinh_dang_co_dieu_kien_nang_cao\"><\/span><b>C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel v\u1edbi quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n n\u00e2ng cao\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o quy t\u1eafc \u0111\u1ec3 t\u00f4 m\u00e0u cho d\u1eef li\u1ec7u duy nh\u1ea5t ho\u1eb7c tr\u00f9ng l\u1eb7p m\u00e3 m\u00e0u trong trang t\u00ednh c\u1ee7a m\u00ecnh. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n bao g\u1ed3m nhi\u1ec1u b\u1ed9 gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p.<\/span><\/p>\n<figure id=\"attachment_13113\" aria-describedby=\"caption-attachment-13113\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13113 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel-4.jpg\" alt=\"C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel v\u1edbi quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n n\u00e2ng cao\u00a0\" width=\"600\" height=\"444\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel-4-400x296.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13113\" class=\"wp-caption-text\">C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel v\u1edbi quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n n\u00e2ng cao<\/figcaption><\/figure>\n<ul>\n<li><span style=\"font-weight: 400;\">Ch\u1ecdn m\u1ed9t ho\u1eb7c kh\u00e1 nhi\u1ec1u \u00f4 trong b\u00e1o c\u00e1o ph\u1ea1m vi, \u1edf b\u1ea3ng ho\u1eb7c pivottable.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Tr\u00ean tab trang \u0111\u1ea7u, trong nh\u00f3m ki\u1ec3u, b\u1ea5m \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n. Sau \u0111\u00f3 b\u1ea5m quy t\u1eafc m\u1edbi .<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Trong danh s\u00e1ch ki\u1ec3u, h\u00e3y ch\u1ecdn c\u1ed5 \u0111i\u1ec3n. Sau \u0111\u00f3 trong danh s\u00e1ch ch\u1ec9 \u0111\u1ecbnh d\u1ea1ng c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c x\u1ebfp h\u1ea1ng tr\u00ean c\u00f9ng ho\u1eb7c d\u01b0\u1edbi c\u00f9ng. L\u00fac n\u00e0y b\u1ea1n h\u00e3y ch\u1ecdn ch\u1ec9 \u0111\u1ecbnh d\u1ea1ng c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t ho\u1eb7c tr\u00f9ng l\u1eb7p .<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Trong c\u00e1c gi\u00e1 tr\u1ecb trong danh s\u00e1ch ph\u1ea1m vi \u0111\u00e3 ch\u1ecdn, h\u00e3y ch\u1ecdn duy nh\u1ea5t ho\u1eb7c tr\u00f9ng l\u1eb7p .<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Trong danh s\u00e1ch \u0111\u1ecbnh d\u1ea1ng v\u1edbi, ch\u1ecdn m\u1ed9t t\u00f9y ch\u1ecdn cho c\u00e1ch b\u1ea1n mu\u1ed1n c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t ho\u1eb7c tr\u00f9ng l\u1eb7p \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng.<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Chinh_sua_quy_tac_dinh_dang_dieu_kien_nang_cao_hon\"><\/span><b>Ch\u1ec9nh s\u1eeda quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng \u0111i\u1ec1u ki\u1ec7n n\u00e2ng cao h\u01a1n<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda quy t\u1eafc hi\u1ec7n c\u00f3 v\u00e0 s\u1eeda \u0111\u1ed5i quy t\u1eafc \u0111\u00f3 \u0111\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 cho d\u1eef li\u1ec7u duy nh\u1ea5t ho\u1eb7c kh\u00f4ng b\u1ecb tr\u00f9ng l\u1eb7p nhi\u1ec1u.<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Ch\u1ecdn m\u1ed9t ho\u1eb7c r\u1ea5t nhi\u1ec1u \u00f4 v\u00e0o trong b\u1ea3ng b\u00e1o c\u00e1o ph\u1ea1m vi, \u1edf b\u1ea3ng ho\u1eb7c pivottable.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Tr\u00ean tab trang \u0111\u1ea7u, trong nh\u00f3m ki\u1ec3u, b\u1ea5m \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n. Sau \u0111\u00f3 b\u1ea5m qu\u1ea3n l\u00fd quy t\u1eafc.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">\u0110\u1ea3m b\u1ea3o r\u1eb1ng trang t\u00ednh ho\u1eb7c b\u1ea3ng th\u00edch h\u1ee3p \u0111\u01b0\u1ee3c ch\u1ecdn trong danh s\u00e1ch hi\u1ec3n th\u1ecb quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng .<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Ch\u1ecdn quy t\u1eafc, sau \u0111\u00f3 b\u1ea5m ch\u1ec9nh s\u1eeda quy t\u1eafc .<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c t\u00f9y ch\u1ecdn b\u1ea1n mu\u1ed1n v\u00e0 sau \u0111\u00f3 b\u1ea5m &#8220;ok&#8221;.<\/span><\/li>\n<\/ul>\n<p><strong>XEM TH\u00caM:<\/strong><\/p>\n<ul>\n<li><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/teky.edu.vn\/blog\/copy-cong-thuc-trong-excel\/\"><strong>Copy c\u00f4ng th\u1ee9c trong Excel nhanh ch\u00f3ng trong gi\u00e2y l\u00e1t<\/strong><\/a><\/span><\/li>\n<li><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/teky.edu.vn\/blog\/cach-danh-dau-tich-trong-excel\/\"><strong>B\u1eadt m\u00ed c\u00e1ch \u0111\u00e1nh d\u1ea5u t\u00edch trong Excel ch\u1ec9 v\u1edbi v\u00e0i thao t\u00e1c<\/strong><\/a><\/span><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch l\u1ecdc trong excel \u0111\u1ed1i v\u1edbi c\u00e1c d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-tinh-tong-trong-word-don-gian-va-nhanh-chong-nhat\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch t\u00ednh t\u1ed5ng trong Word \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng nh\u1ea5t<\/a><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng <span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;c\u00e1ch l\u1ecdc tr\u00f9ng trong excel&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:4226,&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16776960},&quot;10&quot;:2,&quot;15&quot;:&quot;Arial&quot;}\">c\u00e1ch l\u1ecdc tr\u00f9ng trong excel b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o. TEKY hy v\u1ecdng b\u00e0i vi\u1ebft s\u1ebd gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c thu\u1eadn l\u1ee3i h\u01a1n. \u0110\u1eebng qu\u00ean th\u01b0\u1eddng xuy\u00ean theo d\u00f5i TEKY \u0111\u1ec3 kh\u00e1m ph\u00e1 ki\u1ebfn th\u1ee9c tin h\u1ecdc v\u0103n ph\u00f2ng b\u1ed5 \u00edch nh\u00e9!<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel gi\u00fap lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u xu\u1ea5t hi\u1ec7n tr\u00f9ng nhau. N\u1ebfu b\u1ea1n \u0111ang b\u0103n kho\u0103n kh\u00f4ng bi\u1ebft l\u1ecdc th\u00f4ng tin n\u00e0y nh\u01b0 th\u1ebf n\u00e0o th\u00ec h\u00e3y theo d\u00f5i ngay b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y. TEKY s\u1ebd b\u1eadt m\u00ed t\u1edbi b\u1ea1n gi\u1ea3i ph\u00e1p l\u1ecdc tr\u00f9ng d\u1eef li\u1ec7u th\u00f4ng minh, ti\u1ec7n l\u1ee3i trong Excel &hellip;<\/p>\n","protected":false},"author":3,"featured_media":13109,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-13108","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>C\u00e1ch l\u1ecdc tr\u00f9ng trong excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft<\/title>\n<meta name=\"description\" content=\"C\u00e1ch l\u1ecdc tr\u00f9ng trong excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft \u0111\u01b0\u1ee3c TEKY chia s\u1ebb \u1edf b\u00ean d\u01b0\u1edbi. C\u00f9ng theo d\u00f5i ngay b\u00e0i vi\u1ebft sau \u0111\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft\" \/>\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\/cach-loc-trung-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 l\u1ecdc tr\u00f9ng trong excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft\" \/>\n<meta property=\"og:description\" content=\"C\u00e1ch l\u1ecdc tr\u00f9ng trong excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft \u0111\u01b0\u1ee3c TEKY chia s\u1ebb \u1edf b\u00ean d\u01b0\u1edbi. C\u00f9ng theo d\u00f5i ngay b\u00e0i vi\u1ebft sau \u0111\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/\" \/>\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-11-23T09:33:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-07T09:08:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"337\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\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=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 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\/cach-loc-trung-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft\",\"datePublished\":\"2022-11-23T09:33:35+00:00\",\"dateModified\":\"2022-12-07T09:08:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/\"},\"wordCount\":2097,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/\",\"name\":\"C\u00e1ch l\u1ecdc tr\u00f9ng trong excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel.jpg\",\"datePublished\":\"2022-11-23T09:33:35+00:00\",\"dateModified\":\"2022-12-07T09:08:33+00:00\",\"description\":\"C\u00e1ch l\u1ecdc tr\u00f9ng trong excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft \u0111\u01b0\u1ee3c TEKY chia s\u1ebb \u1edf b\u00ean d\u01b0\u1edbi. C\u00f9ng theo d\u00f5i ngay b\u00e0i vi\u1ebft sau \u0111\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel.jpg\",\"width\":600,\"height\":337,\"caption\":\"C\u00e1ch l\u1ecdc tr\u00f9ng trong excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft\"}]},{\"@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\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch l\u1ecdc tr\u00f9ng trong excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft","description":"C\u00e1ch l\u1ecdc tr\u00f9ng trong excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft \u0111\u01b0\u1ee3c TEKY chia s\u1ebb \u1edf b\u00ean d\u01b0\u1edbi. C\u00f9ng theo d\u00f5i ngay b\u00e0i vi\u1ebft sau \u0111\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft","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\/cach-loc-trung-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch l\u1ecdc tr\u00f9ng trong excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft","og_description":"C\u00e1ch l\u1ecdc tr\u00f9ng trong excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft \u0111\u01b0\u1ee3c TEKY chia s\u1ebb \u1edf b\u00ean d\u01b0\u1edbi. C\u00f9ng theo d\u00f5i ngay b\u00e0i vi\u1ebft sau \u0111\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft","og_url":"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/","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-11-23T09:33:35+00:00","article_modified_time":"2022-12-07T09:08:33+00:00","og_image":[{"width":600,"height":337,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft","datePublished":"2022-11-23T09:33:35+00:00","dateModified":"2022-12-07T09:08:33+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/"},"wordCount":2097,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/","name":"C\u00e1ch l\u1ecdc tr\u00f9ng trong excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel.jpg","datePublished":"2022-11-23T09:33:35+00:00","dateModified":"2022-12-07T09:08:33+00:00","description":"C\u00e1ch l\u1ecdc tr\u00f9ng trong excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft \u0111\u01b0\u1ee3c TEKY chia s\u1ebb \u1edf b\u00ean d\u01b0\u1edbi. C\u00f9ng theo d\u00f5i ngay b\u00e0i vi\u1ebft sau \u0111\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-loc-trung-trong-Excel.jpg","width":600,"height":337,"caption":"C\u00e1ch l\u1ecdc tr\u00f9ng trong excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft"}]},{"@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\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/13108","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=13108"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/13108\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/13109"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=13108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=13108"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=13108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}