{"id":12783,"date":"2022-11-29T00:01:52","date_gmt":"2022-11-28T17:01:52","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=12783"},"modified":"2022-12-06T11:56:22","modified_gmt":"2022-12-06T04:56:22","slug":"cach-loc-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/","title":{"rendered":"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"},"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;12783&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 trong excel \u0111\u1ed1i v\u1edbi c\u00e1c d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n&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><b><i>C\u00e1ch l\u1ecdc trong excel <\/i><\/b><i><span style=\"font-weight: 400;\">\u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m hi\u1ec7n nay, nh\u1eb1m l\u1ecdc d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 thay v\u00ec ph\u1ea3i l\u1ecdc th\u1ee7 c\u00f4ng. Ch\u00ednh v\u00ec th\u1ebf n\u00ean\u00a0 c\u00f3 th\u1ec3 h\u1ea1n ch\u1ebf \u0111\u01b0\u1ee3c c\u00e1c sai s\u00f3t x\u1ea3y ra. C\u00e1c d\u1eef li\u1ec7u \u0111\u00f3 c\u00f3 th\u1ec3 l\u00e0 t\u00ean, n\u0103m sinh, ngh\u1ec1 nghi\u1ec7p, gi\u1edbi t\u00ednh,&#8230; V\u1eady c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong excel c\u1ee5 th\u1ec3 nh\u01b0 th\u1ebf n\u00e0o? Tham kh\u1ea3o th\u00eam th\u00f4ng tin do Teky cung c\u1ea5p \u0111\u1ec3 bi\u1ebft th\u00eam chi ti\u1ebft.<\/span><\/i><\/p>\n<figure id=\"attachment_12784\" aria-describedby=\"caption-attachment-12784\" style=\"width: 650px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12784\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-1.jpg\" alt=\"cach-loc-trong-excel-1\" width=\"650\" height=\"350\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-1.jpg 650w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-1-400x215.jpg 400w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><figcaption id=\"caption-attachment-12784\" class=\"wp-caption-text\">C\u00e1ch l\u1ecdc \u0111\u1ed1i v\u1edbi d\u1eef li\u1ec7u trong excel \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m r\u1ed9ng r\u00e3i hi\u1ec7n nay<\/figcaption><\/figure>\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-trong-excel\/#Cac_tao_bo_loc_trong_excel_ban_doc_tham_khao\" >C\u00e1c t\u1ea1o b\u1ed9 l\u1ecdc trong excel b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/#Cach_them_bo_loc_trong_excel\" >C\u00e1ch th\u00eam b\u1ed9 l\u1ecdc trong excel\u00a0<\/a><\/li><\/ul><\/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-trong-excel\/#Cach_loc_trong_excel_doi_voi_du_lieu_co_the_ban_chua_biet\" >C\u00e1ch l\u1ecdc trong excel \u0111\u1ed1i v\u1edbi d\u1eef li\u1ec7u c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/#Cach_loc_danh_sach_trong_excel\" >C\u00e1ch l\u1ecdc danh s\u00e1ch trong excel\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/#Cach_loc_trung_trong_excel\" >C\u00e1ch l\u1ecdc tr\u00f9ng trong excel\u00a0<\/a><\/li><\/ul><\/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-trong-excel\/#Tong_ket_ve_cach_loc_trong_excel\" >T\u1ed5ng k\u1ebft v\u1ec1 c\u00e1ch l\u1ecdc trong excel\u00a0\u00a0<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cac_tao_bo_loc_trong_excel_ban_doc_tham_khao\"><\/span><b>C\u00e1c t\u1ea1o b\u1ed9 l\u1ecdc trong excel b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">L\u1ecdc d\u1eef li\u1ec7u trong excel l\u00e0 m\u1ed9t trong nh\u1eefng v\u1ea5n \u0111\u1ec1 nan gi\u1ea3i h\u00e0ng \u0111\u1ea7u n\u1ebfu nh\u01b0 th\u1ef1c hi\u1ec7n th\u1ee7 c\u00f4ng. B\u1edfi v\u00ec v\u1edbi nh\u1eefng b\u1ea3ng t\u00ednh h\u00e0ng tr\u0103m, h\u00e0ng ng\u00e0n s\u1ed1 li\u1ec7u th\u00ec vi\u1ec7c theo d\u00f5i, so s\u00e1nh v\u00e0 li\u1ec7t k\u00ea kh\u00e1 kh\u00f3 kh\u0103n. V\u1eeba t\u1ed1n th\u1eddi gian m\u00e0 v\u1eeba d\u1ec5 b\u1ecb sai n\u1eefa. Ch\u00ednh v\u00ec \u0111i\u1ec1u n\u00e0y m\u00e0 c\u00f4ng c\u1ee5 l\u1ecdc trong excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn. R\u1ea5t nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m t\u00ecm hi\u1ec3u <\/span><b>c\u00e1ch l\u1ecdc trong excel<\/b><span style=\"font-weight: 400;\">.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Nh\u1eb1m gi\u00fap k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c h\u01a1n trong vi\u1ec7c l\u1ecdc d\u1eef li\u1ec7u. C\u0169ng nh\u01b0 l\u00e0 b\u1ea1n s\u1ebd ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c th\u1eddi gian, c\u00f4ng s\u1ee9c m\u1ed9t c\u00e1ch \u0111\u00e1ng k\u1ec3. V\u00e0 \u0111\u1eebng \u0111\u1ec3 cho b\u1ea3n th\u00e2n b\u1ecb \u201cl\u1ea1c h\u1eadu\u201d trong vi\u1ec7c s\u1eed d\u1ee5ng excel nh\u00e9! Nh\u1eefng c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 s\u1ebd gi\u00fap \u0111\u1ee1 cho b\u1ea1n th\u1ef1c hi\u1ec7n m\u1ecdi th\u1ee9 \u0111\u01a1n gi\u1ea3n h\u01a1n. V\u1eady <\/span><span style=\"font-weight: 400;\">c\u00e1ch t\u1ea1o b\u1ed9 l\u1ecdc trong excel<\/span><span style=\"font-weight: 400;\"> nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y \u0111\u1ec3 Teky gi\u1ea3i \u0111\u00e1p c\u1ee5 th\u1ec3 h\u01a1n!<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"L\u1ecdc d\u1eef li\u1ec7u v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n v\u1edbi h\u00e0m Filter trong Excel\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/Woe-5bJ4uXE?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<h3><span class=\"ez-toc-section\" id=\"Cach_them_bo_loc_trong_excel\"><\/span><em><strong>C\u00e1ch th\u00eam b\u1ed9 l\u1ecdc trong excel\u00a0<\/strong><\/em><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">B\u1ed9 l\u1ecdc trong excel gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp c\u00e1c \u00f4 d\u1eef li\u1ec7u theo m\u1ed9t th\u1ee9 t\u1ef1 nh\u1ea5t \u0111\u1ecbnh. C\u1ee5 th\u1ec3 l\u00e0 t\u1eeb l\u1edbn \u0111\u1ebfn nh\u1ecf, nh\u1ecf \u0111\u1ebfn l\u1edbn ho\u1eb7c theo m\u00e0u s\u1eafc. \u0110\u1eb7c bi\u1ec7t l\u00e0 n\u00f3 c\u00f3 ch\u1ecdn l\u1ecdc. Ch\u1ec9 hi\u1ec3n th\u1ecb m\u1ee5c b\u1ea1n ch\u1ecdn, c\u00f2n nh\u1eefng m\u1ee5c kh\u00f4ng li\u00ean quan th\u00ec s\u1ebd kh\u00f4ng c\u00f3 hi\u1ec3n th\u1ecb l\u00ean. \u0110\u1ec3 th\u00eam b\u1ed9 l\u1ecdc trong excel, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n r\u1ea5t \u0111\u01a1n gi\u1ea3n v\u1edbi m\u1ed9t s\u1ed1 b\u01b0\u1edbc c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ea7u ti\u00ean l\u00e0 chu\u1ea9n b\u1ecb m\u1ed9t b\u1ea3ng t\u00ednh s\u1ed1 li\u1ec7u nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi. Sau \u0111\u00f3 b\u00f4i \u0111en h\u00e0ng \u0111\u1ea7u m\u1ee5c v\u00e0 ch\u1ecdn Data \u2192 Filter.\u00a0<\/span><\/p>\n<figure id=\"attachment_12785\" aria-describedby=\"caption-attachment-12785\" style=\"width: 900px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12785\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-2.jpg\" alt=\"cach-loc-trong-excel-2\" width=\"900\" height=\"500\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-2.jpg 900w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-2-400x222.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-2-768x427.jpg 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption id=\"caption-attachment-12785\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc trong excel \u0111\u1ec3 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong b\u1ea3ng<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Sau khi ch\u1ecdn Filter th\u00ec tr\u00ean b\u1ea3ng d\u1eef li\u1ec7u s\u1ebd xu\u1ea5t hi\u1ec7n c\u00e1c h\u00ecnh tam gi\u00e1c \u1edf g\u00f3c c\u00e1c m\u1ee5c. L\u00fac n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 click v\u00e0o c\u00e1c h\u00ecnh tam gi\u00e1c n\u00e0y \u0111\u1ec3 xu\u1ea5t hi\u1ec7n h\u1ed9p tho\u1ea1i gi\u1ed1ng nh\u01b0 h\u00ecnh \u1ea3nh b\u00ean d\u01b0\u1edbi. C\u00f3 c\u00e1c lo\u1ea1i s\u1eafp x\u1ebfp cho b\u1ea1n l\u1ef1a ch\u1ecdn. B\u1ea1n c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp t\u1eeb nh\u1ecf \u0111\u1ebfn l\u1edbn ho\u1eb7c t\u1eeb l\u1edbn \u0111\u1ebfn nh\u1ecf. Hay l\u00e0 theo m\u00e0u s\u1eafc. C\u1ee5 th\u1ec3 gi\u1ed1ng nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi:<\/span><\/p>\n<figure id=\"attachment_12786\" aria-describedby=\"caption-attachment-12786\" style=\"width: 900px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12786\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-3.jpg\" alt=\"cach-loc-trong-excel-3\" width=\"900\" height=\"500\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-3.jpg 900w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-3-400x222.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-3-768x427.jpg 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption id=\"caption-attachment-12786\" class=\"wp-caption-text\">L\u1ef1a ch\u1ecdn v\u00e0o h\u00ecnh tam gi\u00e1c \u0111\u1ec3 xu\u1ea5t hi\u1ec7n h\u1ed9p tho\u1ea1i s\u1eafp x\u1ebfp<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Sau khi ch\u1ecdn m\u1ed9t h\u00ecnh th\u1ee9c s\u1eafp x\u1ebfp. C\u1ee5 th\u1ec3 \u1edf h\u00ecnh tr\u00ean l\u00e0 Sort Smallest to Largest (t\u1ee9c l\u00e0 t\u1eeb nh\u1ecf \u0111\u1ebfn l\u1edbn) th\u00ec b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 gi\u1ed1ng nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi \u0111\u00e2y. S\u1ed1 li\u1ec7u \u1edf \u00f4 ng\u00e0y c\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp l\u1ea1i v\u00e0 k\u00e9o theo c\u00e1c s\u1ed1 li\u1ec7u \u1edf b\u1ea3ng kh\u00e1c c\u0169ng \u0111i\u1ec1u ch\u1ec9nh theo \u0111\u1ec3 ph\u00f9 h\u1ee3p.\u00a0<\/span><\/p>\n<figure id=\"attachment_12787\" aria-describedby=\"caption-attachment-12787\" style=\"width: 900px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12787\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-4.jpg\" alt=\"cach-loc-trong-excel-4\" width=\"900\" height=\"500\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-4.jpg 900w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-4-400x222.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-4-768x427.jpg 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption id=\"caption-attachment-12787\" class=\"wp-caption-text\">Ng\u00e0y c\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u1eeb nh\u1ecf \u0111\u1ebfn l\u1edbn<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Cach_loc_trong_excel_doi_voi_du_lieu_co_the_ban_chua_biet\"><\/span><b>C\u00e1ch l\u1ecdc trong excel \u0111\u1ed1i v\u1edbi d\u1eef li\u1ec7u c\u00f3 th\u1ec3 b\u1ea1n ch\u01b0a bi\u1ebft<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady v\u1edbi b\u1ed9 l\u1ecdc trong excel tr\u00ean th\u00ec b\u1ea1n c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp c\u00e1c d\u1eef li\u1ec7u. C\u00f2n \u0111\u1ec3 l\u1ecdc c\u00e1c d\u1eef li\u1ec7u nh\u01b0 l\u00e0 tu\u1ed5i, t\u00ean, n\u0103m sinh,&#8230; th\u00ec h\u00e3y tham kh\u1ea3o nh\u1eefng th\u00f4ng tin ti\u1ebfp theo \u0111\u00e2y ch\u00fang t\u00f4i cung c\u1ea5p.\u00a0 C\u1ee5 th\u1ec3 l\u00e0 <\/span><b>c\u00e1ch l\u1ecdc trong excel<\/b><span style=\"font-weight: 400;\"> nhanh ch\u00f3ng, hi\u1ec7u qu\u1ea3.\u00a0<\/span><\/p>\n<ul>\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Cach_loc_danh_sach_trong_excel\"><\/span><b><i>C\u00e1ch l\u1ecdc danh s\u00e1ch trong excel\u00a0<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p><b>C\u00e1ch l\u1ecdc trong excel <\/b><span style=\"font-weight: 400;\">\u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n c\u0169ng kh\u00e1 \u0111\u01a1n gi\u1ea3n. B\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc \u0111\u1ea7u t\u01b0\u01a1ng t\u1ef1 nh\u01b0 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u v\u1edbi b\u1ed9 l\u1ecdc excel. Song c\u00e1c b\u01b0\u1edbc sau th\u00ec s\u1ebd c\u00f3 s\u1ef1 thay \u0111\u1ed5i.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u1ea1n c\u0169ng s\u1ebd b\u00f4i \u0111en c\u00e1c \u0111\u1ea7u m\u1ee5c c\u1ee7a c\u1ed9t. Sau \u0111\u00f3 ch\u1ecdn Data \u2192 Ch\u1ecdn Filter \u0111\u1ec3 xu\u1ea5t hi\u1ec7n c\u00e1c h\u00ecnh tam gi\u00e1c 1 g\u00f3c c\u1ee7a c\u00e1c m\u1ee5c. Ti\u1ebfp theo b\u1ea1n click v\u00e0o h\u00ecnh tam gi\u00e1c \u1edf c\u00e1c m\u1ee5c \u0111\u1ec3 xu\u1ea5t hi\u1ec7n h\u1ed9p tho\u1ea1i b\u00ean d\u01b0\u1edbi. B\u1ea1n mu\u1ed1n l\u1ecdc nh\u1eefng ng\u01b0\u1eddi c\u00f3 ng\u00e0y c\u00f4ng 28,30 v\u00e0 31? B\u1ea1n b\u1ecf ch\u1ecdn Select All. Sau \u0111\u00f3 ch\u1ec9 c\u1ea7n click b\u1ecf ch\u1ecdn c\u00e1c \u00f4 ng\u00e0y c\u00f4ng c\u00f2n l\u1ea1i. Sau \u0111\u00f3 ch\u1ecdn OK \u0111\u1ec3 ho\u00e0n th\u00e0nh.\u00a0<\/span><\/p>\n<figure id=\"attachment_12788\" aria-describedby=\"caption-attachment-12788\" style=\"width: 900px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12788\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-5.jpg\" alt=\"cach-loc-trong-excel-5\" width=\"900\" height=\"500\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-5.jpg 900w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-5-400x222.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-5-768x427.jpg 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption id=\"caption-attachment-12788\" class=\"wp-caption-text\">L\u1ecdc d\u1eef li\u1ec7u b\u00ean trong c\u1ed9t v\u1edbi b\u1ed9 l\u1ecdc c\u1ee7a excel<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 nh\u1eadn l\u1ea1i gi\u1ed1ng nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi \u0111\u00e2y. C\u1ee5 th\u1ec3 c\u00f3 3 ng\u01b0\u1eddi th\u1ecfa m\u00e3n ng\u00e0y c\u00f4ng l\u00e0 28, 30 ho\u1eb7c 31. Th\u00f4ng tin n\u00e0y cam k\u1ebft nhanh ch\u00f3ng, ch\u00ednh x\u00e1c v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng v\u1edbi nh\u1eefng b\u1ea3ng t\u00ednh c\u00f3 nhi\u1ec1u s\u1ed1 li\u1ec7u h\u01a1n.<\/span><\/p>\n<figure id=\"attachment_12789\" aria-describedby=\"caption-attachment-12789\" style=\"width: 900px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12789\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-6.jpg\" alt=\"cach-loc-trong-excel-6\" width=\"900\" height=\"500\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-6.jpg 900w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-6-400x222.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-6-768x427.jpg 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption id=\"caption-attachment-12789\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3 sau khi l\u1ecdc ng\u00e0y c\u00f4ng c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean trong c\u00f4ng ty<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi <\/span><span style=\"font-weight: 400;\">c\u00e1ch l\u1ecdc n\u0103m sinh trong excel, c\u00e1ch l\u1ecdc t\u00ean trong excel <\/span><span style=\"font-weight: 400;\">th\u00ec b\u1ea1n c\u0169ng th\u1ef1c hi\u1ec7n t\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1c b\u01b0\u1edbc nh\u01b0 tr\u00ean. M\u1ecdi th\u1ee9 di\u1ec5n ra nhanh ch\u00f3ng, d\u1ec5 d\u00e0ng v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian cho b\u1ea1n m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. C\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng <\/span><b>c\u00e1ch l\u1ecdc trong excel <\/b><span style=\"font-weight: 400;\">b\u1eb1ng c\u00f4ng c\u1ee5 b\u1ed9 l\u1ecdc th\u1ef1c s\u1ef1 r\u1ea5t b\u1ed5 \u00edch.\u00a0<\/span><\/p>\n<ul>\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Cach_loc_trung_trong_excel\"><\/span><b><i>C\u00e1ch l\u1ecdc tr\u00f9ng trong excel\u00a0<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">C\u00f4ng c\u1ee5 c\u1ee7a excel gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n m\u1ecdi th\u1ee9 nhanh ch\u00f3ng h\u01a1n v\u1edbi excel. V\u00e0 \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng trong excel, b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n theo m\u1ed9t s\u1ed1 b\u01b0\u1edbc c\u1ee5 th\u1ec3 nh\u01b0 b\u00ean d\u01b0\u1edbi \u0111\u00e2y. \u0110\u1ea7u ti\u00ean, b\u1ea1n b\u00f4i \u0111en h\u1ebft v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n x\u00e9t. Sau \u0111\u00f3 ch\u1ecdn Data \u2192 Ch\u1ecdn Remove Duplicates.\u00a0<\/span><\/p>\n<figure id=\"attachment_12790\" aria-describedby=\"caption-attachment-12790\" style=\"width: 900px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12790\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-7.jpg\" alt=\"cach-loc-trong-excel-7\" width=\"900\" height=\"500\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-7.jpg 900w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-7-400x222.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-7-768x427.jpg 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption id=\"caption-attachment-12790\" class=\"wp-caption-text\">B\u00f4i \u0111en v\u00f9ng c\u1ea7n l\u1ecdc tr\u00f9ng trong excel<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Sau khi b\u1ea5m ch\u1ecdn Remove Duplicates th\u00ec s\u1ebd xu\u1ea5t hi\u1ec7n h\u1ed9p tho\u1ea1i gi\u1ed1ng nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi. L\u00fac n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn l\u1ecdc Select All t\u1ee9c l\u00e0 l\u1ecdc t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u b\u00ean trong b\u1ea3ng. Ho\u1eb7c c\u00f3 th\u1ec3 ch\u1ecdn Unselect All \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch c\u00f3 ch\u1ecdn l\u1ecdc.\u00a0<\/span><\/p>\n<figure id=\"attachment_12791\" aria-describedby=\"caption-attachment-12791\" style=\"width: 900px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12791\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-8.jpg\" alt=\"cach-loc-trong-excel-8\" width=\"900\" height=\"500\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-8.jpg 900w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-8-400x222.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-8-768x427.jpg 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption id=\"caption-attachment-12791\" class=\"wp-caption-text\">L\u1ecdc d\u1eef li\u1ec7u v\u1edbi Remove Duplicates<\/figcaption><\/figure>\n<figure id=\"attachment_12792\" aria-describedby=\"caption-attachment-12792\" style=\"width: 900px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12792\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-9.jpg\" alt=\"cach-loc-trong-excel-9\" width=\"900\" height=\"500\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-9.jpg 900w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-9-400x222.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-9-768x427.jpg 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption id=\"caption-attachment-12792\" class=\"wp-caption-text\">V\u1edbi Unselect All th\u00ec b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn m\u1ee5c d\u1eef li\u1ec7u \u0111\u1ec3 l\u1ecdc tr\u00f9ng<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Sau khi ch\u1ecdn H\u1ecd v\u00e0 t\u00ean nh\u01b0 \u1edf h\u00ecnh tr\u00ean v\u00e0 b\u1ea5m OK. H\u00ecnh \u1ea3nh b\u00ean d\u01b0\u1edbi ch\u00ednh l\u00e0 k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng:<\/span><\/p>\n<figure id=\"attachment_12793\" aria-describedby=\"caption-attachment-12793\" style=\"width: 900px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12793\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-10.jpg\" alt=\"cach-loc-trong-excel-10\" width=\"900\" height=\"500\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-10.jpg 900w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-10-400x222.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-10-768x427.jpg 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption id=\"caption-attachment-12793\" class=\"wp-caption-text\">D\u1eef li\u1ec7u sau khi \u0111\u00e3 \u0111\u01b0\u1ee3c l\u1ecdc tr\u00f9ng nhanh ch\u00f3ng<\/figcaption><\/figure>\n<p>Tham kh\u1ea3o:<a href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc trong Excel chi ti\u1ebft nh\u1ea5t<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tong_ket_ve_cach_loc_trong_excel\"><\/span><b>T\u1ed5ng k\u1ebft v\u1ec1 c\u00e1ch l\u1ecdc trong excel\u00a0\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y ch\u00ednh l\u00e0 nh\u1eefng th\u00f4ng tin v\u1ec1 <\/span><b>c\u00e1ch l\u1ecdc trong excel<\/b><span style=\"font-weight: 400;\"> \u0111\u1ed1i v\u1edbi c\u00e1c d\u1eef li\u1ec7u (bao g\u1ed3m c\u1ea3 ch\u1eef v\u00e0 s\u1ed1). K\u1ebft qu\u1ea3 mang l\u1ea1i cu\u1ed1i c\u00f9ng s\u1ebd tr\u1ea3 l\u1ea1i cho b\u1ea1n s\u1ed1 li\u1ec7u sau khi l\u1ecdc m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, hi\u1ec7u qu\u1ea3 v\u00e0 h\u1ebft s\u1ee9c ch\u00ednh x\u00e1c. \u0110\u00e3 th\u1ebf c\u00f2n gi\u00fap ti\u1ebft ki\u1ec7m c\u00f4ng s\u1ee9c th\u1ef1c hi\u1ec7n m\u1ed9t c\u00e1ch \u0111\u00e1ng k\u1ec3. Ch\u00fang t\u00f4i tin r\u1eb1ng c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u n\u00e0y th\u1ef1c s\u1ef1 c\u00f3 \u00edch v\u00e0 gi\u00fap cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n thu\u1eadn l\u1ee3i h\u01a1n.\u00a0<\/span><\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-loc-trung-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>C\u00e1ch l\u1ecdc trong excel \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m hi\u1ec7n nay, nh\u1eb1m l\u1ecdc d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 thay v\u00ec ph\u1ea3i l\u1ecdc th\u1ee7 c\u00f4ng. Ch\u00ednh v\u00ec th\u1ebf n\u00ean\u00a0 c\u00f3 th\u1ec3 h\u1ea1n ch\u1ebf \u0111\u01b0\u1ee3c c\u00e1c sai s\u00f3t x\u1ea3y ra. C\u00e1c d\u1eef li\u1ec7u \u0111\u00f3 c\u00f3 th\u1ec3 l\u00e0 t\u00ean, n\u0103m sinh, ngh\u1ec1 nghi\u1ec7p, gi\u1edbi &hellip;<\/p>\n","protected":false},"author":3,"featured_media":12784,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-12783","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 trong excel \u0111\u1ed1i v\u1edbi c\u00e1c d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n<\/title>\n<meta name=\"description\" content=\"C\u00e1ch l\u1ecdc trong excel c\u00f3 kh\u00f3 hay kh\u00f4ng? Th\u1ef1c hi\u1ec7n c\u1ee5 th\u1ec3 nh\u01b0 th\u1ebf n\u00e0o? \u0110\u00e2y l\u00e0 \u0111i\u1ec1u nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m. Tham kh\u1ea3o v\u1edbi Teky nh\u00e9!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/cach-loc-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 trong excel \u0111\u1ed1i v\u1edbi c\u00e1c d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n\" \/>\n<meta property=\"og:description\" content=\"C\u00e1ch l\u1ecdc trong excel c\u00f3 kh\u00f3 hay kh\u00f4ng? Th\u1ef1c hi\u1ec7n c\u1ee5 th\u1ec3 nh\u01b0 th\u1ebf n\u00e0o? \u0110\u00e2y l\u00e0 \u0111i\u1ec1u nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m. Tham kh\u1ea3o v\u1edbi Teky nh\u00e9!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-loc-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-28T17:01:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-06T04:56:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"650\" \/>\n\t<meta property=\"og:image:height\" content=\"350\" \/>\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=\"8 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-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"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\",\"datePublished\":\"2022-11-28T17:01:52+00:00\",\"dateModified\":\"2022-12-06T04:56:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/\"},\"wordCount\":1894,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-1.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/\",\"name\":\"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\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-1.jpg\",\"datePublished\":\"2022-11-28T17:01:52+00:00\",\"dateModified\":\"2022-12-06T04:56:22+00:00\",\"description\":\"C\u00e1ch l\u1ecdc trong excel c\u00f3 kh\u00f3 hay kh\u00f4ng? Th\u1ef1c hi\u1ec7n c\u1ee5 th\u1ec3 nh\u01b0 th\u1ebf n\u00e0o? \u0110\u00e2y l\u00e0 \u0111i\u1ec1u nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m. Tham kh\u1ea3o v\u1edbi Teky nh\u00e9!\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-1.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-1.jpg\",\"width\":650,\"height\":350,\"caption\":\"C\u00e1ch l\u1ecdc \u0111\u1ed1i v\u1edbi d\u1eef li\u1ec7u trong excel \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m r\u1ed9ng r\u00e3i hi\u1ec7n nay\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-loc-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 trong excel \u0111\u1ed1i v\u1edbi c\u00e1c d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n\"}]},{\"@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 trong excel \u0111\u1ed1i v\u1edbi c\u00e1c d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n","description":"C\u00e1ch l\u1ecdc trong excel c\u00f3 kh\u00f3 hay kh\u00f4ng? Th\u1ef1c hi\u1ec7n c\u1ee5 th\u1ec3 nh\u01b0 th\u1ebf n\u00e0o? \u0110\u00e2y l\u00e0 \u0111i\u1ec1u nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m. Tham kh\u1ea3o v\u1edbi Teky nh\u00e9!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"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","og_description":"C\u00e1ch l\u1ecdc trong excel c\u00f3 kh\u00f3 hay kh\u00f4ng? Th\u1ef1c hi\u1ec7n c\u1ee5 th\u1ec3 nh\u01b0 th\u1ebf n\u00e0o? \u0110\u00e2y l\u00e0 \u0111i\u1ec1u nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m. Tham kh\u1ea3o v\u1edbi Teky nh\u00e9!","og_url":"https:\/\/teky.edu.vn\/blog\/cach-loc-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-28T17:01:52+00:00","article_modified_time":"2022-12-06T04:56:22+00:00","og_image":[{"width":650,"height":350,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-1.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":"8 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"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","datePublished":"2022-11-28T17:01:52+00:00","dateModified":"2022-12-06T04:56:22+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/"},"wordCount":1894,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-1.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/","name":"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","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-1.jpg","datePublished":"2022-11-28T17:01:52+00:00","dateModified":"2022-12-06T04:56:22+00:00","description":"C\u00e1ch l\u1ecdc trong excel c\u00f3 kh\u00f3 hay kh\u00f4ng? Th\u1ef1c hi\u1ec7n c\u1ee5 th\u1ec3 nh\u01b0 th\u1ebf n\u00e0o? \u0110\u00e2y l\u00e0 \u0111i\u1ec1u nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m. Tham kh\u1ea3o v\u1edbi Teky nh\u00e9!","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-loc-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-1.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-loc-trong-excel-1.jpg","width":650,"height":350,"caption":"C\u00e1ch l\u1ecdc \u0111\u1ed1i v\u1edbi d\u1eef li\u1ec7u trong excel \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m r\u1ed9ng r\u00e3i hi\u1ec7n nay"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cach-loc-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 trong excel \u0111\u1ed1i v\u1edbi c\u00e1c d\u1eef li\u1ec7u nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n"}]},{"@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\/12783","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=12783"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12783\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/12784"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=12783"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=12783"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=12783"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}