{"id":12272,"date":"2024-03-03T14:28:40","date_gmt":"2024-03-03T07:28:40","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=12272"},"modified":"2024-03-04T15:46:17","modified_gmt":"2024-03-04T08:46:17","slug":"cach-xep-loai-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/","title":{"rendered":"Nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1ch x\u1ebfp lo\u1ea1i trong excel"},"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;12272&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;7&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4.3&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;4.3\\\/5 - (7 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1ch x\u1ebfp lo\u1ea1i trong excel&quot;,&quot;width&quot;:&quot;122.2&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: 122.2px;\">\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            4.3\/5 - (7 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p><span style=\"font-weight: 400;\">V\u1edbi th\u1eddi \u0111\u1ea1i c\u00f4ng ngh\u1ec7 hi\u1ec7n nay, nh\u1eefng thao t\u00e1c v\u1ec1 l\u00e0m vi\u1ec7c v\u1edbi nh\u1eefng con s\u1ed1 \u0111\u00e3 tr\u1edf n\u00ean d\u1ec5 d\u00e0ng. Ch\u1eb3ng h\u1ea1n nh\u01b0 vi\u1ec7c<\/span><b> x\u1ebfp lo\u1ea1i trong excel <\/b><span style=\"font-weight: 400;\">c\u1ee7a gi\u00e1o vi\u00ean l\u00e0 vi\u1ec7c th\u01b0\u1eddng xuy\u00ean ph\u1ea3i l\u00e0m.. N\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft r\u00f5 <\/span>th\u00ec h\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft n\u00e0y nh\u00e9. Vi\u1ec7c x\u1ebfp lo\u1ea1i trong excel c\u00f2n c\u00f3 nhi\u1ec1u lo\u1ea1i kh\u00e1c nh\u01b0 c\u00e1ch x\u1ebfp th\u1ee9 t\u1ef1,<span style=\"font-weight: 400;\">\u00a0<\/span><b>c\u00e1ch x\u1ebfp h\u1ea1ng trong excel<\/b><span style=\"font-weight: 400;\"> v\u00e0 c\u1ea3 <\/span><b>c\u00e1ch t\u00ednh x\u1ebfp lo\u1ea1i trong excel.\u00a0<\/b><\/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-xep-loai-trong-excel\/#Cach_xep_loai_trong_excel_la_gi\" >C\u00e1ch x\u1ebfp lo\u1ea1i trong excel l\u00e0 g\u00ec?\u00a0<\/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-xep-loai-trong-excel\/#Chi_tiet_hon_ve_cach_xep_loai\" >Chi ti\u1ebft h\u01a1n v\u1ec1 c\u00e1ch x\u1ebfp lo\u1ea1i\u00a0<\/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-xep-loai-trong-excel\/#Huong_dan_viec_tinh_xep_loai_trong_excel\" >H\u01b0\u1edbng d\u1eabn vi\u1ec7c t\u00ednh x\u1ebfp lo\u1ea1i trong excel<\/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-xep-loai-trong-excel\/#Vi_du_minh_hoa\" >V\u00ed d\u1ee5 minh h\u1ecda<\/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-xep-loai-trong-excel\/#Cach_dung_ham_AND_OR_trong_ham_IF_se_co_giong_nhu_ham_xep_loai_hoc_luc_trong_Excel\" >C\u00e1ch d\u00f9ng h\u00e0m AND, OR trong h\u00e0m IF s\u1ebd c\u00f3 gi\u1ed1ng nh\u01b0 h\u00e0m x\u1ebfp lo\u1ea1i h\u1ecdc l\u1ef1c trong Excel<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_xep_loai_trong_excel_la_gi\"><\/span><span style=\"font-weight: 400;\">C\u00e1ch x\u1ebfp lo\u1ea1i trong excel l\u00e0 g\u00ec?\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Vi\u1ec7c thao t\u00e1c h\u01b0\u1edbng d\u1eabn c\u1ee7a ch\u00fang t\u00f4i \u0111\u01b0\u1ee3c d\u1ef1a tr\u00ean phi\u00ean b\u1ea3n Excel 2016. N\u1ebfn n\u1ebfu b\u1ea1n c\u00f3 c\u00e1c phi\u00ean b\u1ea3n kh\u00e1c th\u00ec \u0111\u1eebng lo s\u1ee3 nh\u00e9. V\u00ec \u0111\u00e2y s\u1ebd l\u00e0 ph\u1ea7n t\u01b0\u01a1ng t\u1ef1 cho c\u00e1c phi\u00ean b\u1ea3n c\u00f2n l\u1ea1i. N\u00ean b\u1ea1n c\u1ee9 y\u00ean t\u00e2m th\u1ef1c hi\u1ec7n theo nh\u00e9.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u00e2y l\u00e0 c\u00f4ng c\u1ee5 s\u1ebd gi\u00fap b\u1ea1n \u0111\u00e1nh gi\u00e1 \u0111\u01b0\u1ee3c lo\u1ea1i c\u1ee7a t\u1eebng ng\u01b0\u1eddi m\u00e0 theo y\u00eau c\u1ea7u \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1eb7t ra. B\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp \u0111i\u1ec1u ki\u1ec7n th\u00ec m\u1ecdi thao t\u00e1c c\u00f2n l\u1ea1i excel s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft. K\u1ebft qu\u1ea3 \u0111\u01b0a ra l\u00e0 b\u1ea1n s\u1ebd c\u00f3 ngay b\u1ea3ng b\u00e1o c\u00e1o ho\u00e0n thi\u1ec7n v\u1edbi <\/span><b>c\u00e1ch x\u1ebfp lo\u1ea1i trong excel<\/b><span style=\"font-weight: 400;\">. B\u00ean c\u1ea1nh \u0111\u00f3, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn t\u1eadn t\u00ecnh c\u00e1ch <\/span>x\u1ebfp lo\u1ea1i <span style=\"font-weight: 400;\">v\u1ec1 ph\u1ea7n ti\u1ebfp theo c\u1ee7a b\u00e0i vi\u1ebft.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12276 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-21.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-21.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-21-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/2-21-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Chi_tiet_hon_ve_cach_xep_loai\"><\/span><span style=\"font-weight: 400;\">Chi ti\u1ebft h\u01a1n v\u1ec1 c\u00e1ch x\u1ebfp lo\u1ea1i\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 c\u00f3 th\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c c\u00e1ch<\/span> x\u1ebfp lo\u1ea1i <span style=\"font-weight: 400;\">b\u1ea1n c\u0169ng c\u1ea7n bi\u1ebft c\u00e1ch x\u1ebfp h\u1ea1ng, c\u00e1ch x\u1ebfp th\u1ee9 t\u1ef1 v\u00e0 c\u1ea3 c<\/span><b>\u00e1ch t\u00ednh x\u1ebfp lo\u1ea1i trong excel.<\/b><span style=\"font-weight: 400;\"> Nh\u1eefng vi\u1ec7c n\u00e0y b\u1ea1n s\u1ebd c\u1ea7n l\u00e0m vi\u1ec7c nhi\u1ec1u v\u1edbi m\u1ed9t h\u00e0m kh\u00e1 quan tr\u1ecdng l\u00e0 h\u00e0m IF. H\u00e0m n\u00e0y s\u1ebd gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n <\/span><b>c\u00e1ch x\u1ebfp h\u1ea1ng trong excel <\/b><span style=\"font-weight: 400;\">v\u00f4 c\u00f9ng d\u1ec5 d\u00e0ng. H\u00e0m IF l\u00e0 h\u00e0m ki\u1ec3m tra c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u01b0a ra. N\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u01b0a ra th\u1ecfa m\u00e3n th\u00ec h\u00e0m IF s\u1ebd c\u1ea5p ra hai k\u1ebft qu\u1ea3. N\u1ebfu th\u1ecfa m\u00e3n th\u00ec tra v\u1ec1 \u0111\u00e1p \u00e1n 1 c\u00f2n kh\u00f4ng th\u1ecfa th\u00ec \u0111\u01b0\u1ee3c \u0111\u01b0a v\u00e0o \u0111\u00e1p \u00e1n 2 l\u00e0 ng\u01b0\u1ee3c l\u1ea1i \u0111\u00e1p \u00e1n 1.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e0m kh\u00f4ng ch\u1ec9 c\u00f3 \u0111\u00e1p \u1ee9ng m\u1ed9t \u0111i\u1ec1u ki\u1ec7n IF m\u00e0 c\u00f2n c\u00f3 th\u1ec3 l\u1ed3ng gh\u00e9p nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n IF v\u1edbi nhau.\u00a0<\/span><\/p>\n<p>&gt;&gt;&gt; Tham kh\u1ea3o th\u00eam: <em><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/\"><strong>C\u00e1ch s\u1eafp x\u1ebfp trong excel<\/strong><\/a><\/span><\/em><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_viec_tinh_xep_loai_trong_excel\"><\/span><span style=\"font-weight: 400;\">H\u01b0\u1edbng d\u1eabn vi\u1ec7c t\u00ednh x\u1ebfp lo\u1ea1i trong excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p \u0111\u1ec3 s\u1eed d\u1ee5ng <\/span><b>c\u00e1ch t\u00ednh x\u1ebfp lo\u1ea1i cho excel <\/b><span style=\"font-weight: 400;\">c\u0169ng nh\u01b0<\/span><b> c\u00e1ch t\u00ednh x\u1ebfp th\u1ee9 t\u1ef1 trong excel.\u00a0<\/b><\/p>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p nh\u01b0 sau: \u201cIf ( Logic_ test, value_if_true, value_if_fals)\u201d<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Gi\u1ea3i th\u00edch c\u00e1c t\u1eeb ng\u1eef nh\u01b0 sau:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Logic_test: l\u00e0 thu\u1eadt ng\u1eef ch\u1ec9 gi\u00e1 tr\u1ecb hay c\u00e1c\u00a0 bi\u1ec3u th\u1ee9c logic ( gi\u00e1 tr\u1ecb ch\u1ec9 nh\u1eadn l\u00e0 true or false.\u00a0 Value_if_true: l\u00e0 h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb true n\u1ebfu gi\u00e1 tr\u1ecb \u0111\u00fang khi bi\u1ec3u th\u1ee9c logic \u0111\u00fang. Value_if_false: l\u00e0 h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb False n\u1ebfu gi\u00e1 tr\u1ecb sai khi bi\u1ec3u th\u1ee9c logic sai. \u0110\u1ec3 c\u00f3 th\u1ec3 ph\u1ee5c v\u1ee5 t\u1ed1t h\u01a1n nhu c\u1ea7u c\u1ee7a b\u1ea1n th\u00ec b\u1ea1n c\u00f3 th\u1ec3 l\u1ed3ng gh\u00e9p nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n if \u0111\u1ec3 n\u00e2ng cao t\u00ednh \u1ee9ng d\u1ee5ng. B\u1ea1n c\u1ea7n ph\u1ea3i n\u1eafm v\u1eefng \u0111\u1ec3 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n t\u1ed1t <\/span>c\u00e1ch x\u1ebfp th\u1ee9 t\u1ef1 <span style=\"font-weight: 400;\">v\u00e0 <\/span>c\u00e1ch t\u00ednh x\u1ebfp lo\u1ea1i<b>.\u00a0<\/b><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du_minh_hoa\"><\/span><span style=\"font-weight: 400;\">V\u00ed d\u1ee5 minh h\u1ecda<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Cho b\u1ea3ng sau:\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12278 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-19.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-19.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-19-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/4-19-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Ta c\u1ea7n c\u00f3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n nh\u01b0 sau \u0111\u1ec3 x\u1ebfp lo\u1ea1i. \u0110i\u1ec3m trung b\u00ecnh tr\u00ean 8.0 s\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng l\u00e0 <\/span><b>c\u00e1ch t\u00ednh x\u1ebfp h\u1ea1ng trong excel<\/b><span style=\"font-weight: 400;\"> l\u00e0 lo\u1ea1i gi\u1ecfi. \u0110i\u1ec3m trung b\u00ecnh l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng v\u1edbi s\u1ed1 6.5 v\u00e0 t\u1ea5t nhi\u00ean l\u00e0 s\u1ebd nh\u1ecf h\u01a1n c\u00e1ch t\u00ednh x\u1ebfp h\u1ea1ng gi\u1ecfi trong excel. \u0110i\u1ec3m trung b\u00ecnh c\u00f3 s\u1ed1 d\u01b0\u1edbi 6.5 l\u00e0 c\u00e1ch x\u1ebfp h\u1ea1ng \u0111\u01b0\u1ee3c lo\u1ea1i trung b\u00ecnh.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c m\u00e0 ta c\u00f3 \u0111\u1ec3 k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m AND v\u00e0 IF nh\u01b0 sau:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=IF(G3&gt;=8,\u201dGi\u1ecfi\u201d,IF(AND(G3&lt;8,G3&gt;=6.5),\u201dKh\u00e1\u201d,IF(G3&lt;6.5,\u201dTrung B\u00ecnh\u201d)))<\/span><\/p>\n<p><span style=\"font-weight: 400;\">T\u1ee9c l\u00e0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">IF(G3&gt;=8,\u201dGi\u1ecfi\u201d: N\u1ebfu s\u1ed1 \u0111i\u1ec3m trung b\u00ecnh l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 8 th\u00ec c\u00e1ch x\u1ebfp th\u1ee9 t\u1ef1 trong excel lo\u1ea1i h\u1ecdc sinh l\u00e0 gi\u1ecfi<\/span><\/p>\n<p><span style=\"font-weight: 400;\">IF(AND(G3&lt;8,G3&gt;=6.5),\u201dKh\u00e1\u201d: N\u1ebfu \u0111i\u1ec3m trung b\u00ecnh nh\u1ecf h\u01a1n 8 l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 6.5. Th\u00ec <\/span><b>c\u00e1ch x\u1ebfp th\u1ee9 t\u1ef1 trong excel <\/b><span style=\"font-weight: 400;\">l\u00e0 lo\u1ea1i h\u1ecdc sinh kh\u00e1.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">IF(G3&lt;6.5,\u201dTrung B\u00ecnh\u201d: N\u1ebfu \u0111i\u1ec3m trung b\u00ecnh nh\u1ecf h\u01a1n 6.5 th\u00ec<\/span><b> c\u00e1ch x\u1ebfp th\u1ee9 t\u1ef1 trong excel <\/b><span style=\"font-weight: 400;\">l\u00e0 x\u1ebfp lo\u1ea1i h\u1ecdc sinh Trung B\u00ecnh.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y l\u00e0 b\u1ea3ng k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c tr\u1ea3 l\u1ea1i :\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12277 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-22.jpg\" alt=\"\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-22.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-22-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/3-22-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Nh\u01b0 theo k\u1ebft qu\u1ea3 m\u00e0 ta thu th\u1eadp \u0111\u01b0\u1ee3c th\u00ec ta c\u00f3 nh\u1eadn x\u00e9t l\u00e0 kh\u00f4ng c\u00f3 b\u1ea5t k\u00ec m\u1ed9t b\u1ea1n h\u1ecdc sinh n\u00e0o \u0111\u01b0\u1ee3c gi\u1ecfi tr\u00ean 8.0.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_dung_ham_AND_OR_trong_ham_IF_se_co_giong_nhu_ham_xep_loai_hoc_luc_trong_Excel\"><\/span><span style=\"font-weight: 400;\">C\u00e1ch d\u00f9ng h\u00e0m AND, OR trong h\u00e0m IF s\u1ebd c\u00f3 gi\u1ed1ng nh\u01b0 h\u00e0m x\u1ebfp lo\u1ea1i h\u1ecdc l\u1ef1c trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">\u0110\u00e2y l\u00e0 v\u00ed d\u1ee5 v\u1edbi c\u00e1c y\u00eau c\u1ea7u \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh nh\u01b0 sau:\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12274 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-2-2.jpg\" alt=\"\" width=\"600\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-2-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-2-2-400x133.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">B\u1ea3ng s\u1ebd \u0111\u01b0\u1ee3c x\u00e9t tr\u01b0\u1edbc v\u1edbi c\u00e1c y\u00eau c\u1ea7u \u0111\u1ec3 \u0111\u01b0\u1ee3c ra k\u1ebft lu\u1eadn:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sinh vi\u00ean n\u00e0o c\u00f3 \u0111\u01b0\u1ee3c x\u1ebfp lo\u1ea1i Gi\u1ecfi v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c \u0111i\u1ec3m c\u00e1c m\u00f4n kh\u00f4ng c\u00f3 m\u00f4n n\u00e0o d\u01b0\u1edbi \u0111i\u1ec3m 7. Th\u00ec \u0111\u01b0\u1ee3c trao h\u1ecdc b\u1ed5ng c\u00f3 gi\u00e1 tr\u1ecb l\u00e0: 240000.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sinh vi\u00ean n\u00e0o c\u00f3 \u0111\u01b0\u1ee3c x\u1ebfp lo\u1ea1i Gi\u1ecfi ho\u1eb7c Kh\u00e1 v\u00e0 nh\u01b0ng l\u1ea1i c\u00f3 m\u00f4n \u0111i\u1ec3m d\u01b0\u1edbi 7 th\u00ec \u0111\u01b0\u1ee3c trao h\u1ecdc b\u1ed5ng c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 180000.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sinh vi\u00ean n\u00e0o c\u00f3 x\u1ebfp lo\u1ea1i Trung b\u00ecnh th\u00ec m\u1eb7c \u0111\u1ecbnh kh\u00f4ng nh\u1eadn \u0111\u01b0\u1ee3c h\u1ecdc b\u1ed5ng n\u00e0o h\u1ebft.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sinh vi\u00ean n\u00e0o c\u00f3 x\u1ebfp lo\u1ea1i Y\u1ebfu s\u1ebd ph\u1ea3i n\u1ed9p th\u00eam 180000 ti\u1ec1n \u0111\u1ec3 c\u00f3 th\u1ec3 h\u1ecdc l\u1ea1i v\u00e0 quay v\u1ec1 c\u00e1ch t\u00ednh ban \u0111\u1ea7u.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Ta s\u1ebd b\u1eaft \u0111\u1ea7u gi\u1ea3i quy\u1ebft v\u1edbi c\u00e1c h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng <\/span><b>c\u00e1ch t\u00ednh x\u1ebfp lo\u1ea1i trong excel. <\/b><span style=\"font-weight: 400;\">\u0110\u00f3 l\u00e0 g\u1ed3m c\u00e1c h\u00e0m: <\/span><span style=\"font-weight: 400;\">h\u00e0m IF<\/span><span style=\"font-weight: 400;\"> v\u1edbi c\u00e1c h\u00e0m<\/span><span style=\"font-weight: 400;\"> MIN<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">AND<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">OR<\/span><span style=\"font-weight: 400;\"> \u0111\u1ec3 \u0111\u01b0\u1ee3c gi\u1ea3i quy\u1ebft nhanh g\u1ecdn b\u00e0i to\u00e1n n\u00e0y.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c b\u1ea1n c\u1ea7n ph\u1ea3i \u0111i\u1ec1n v\u00e0o \u00f4 K3 l\u00e0:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=If (AND (J3= \u201c lo\u1ea1i gi\u1ecfi\u201d, MIN (D3:G3) &gt;=7), If (OR (AND ( AND (J3 = \u201clo\u1ea1i gi\u1ecfi\u201d, MIN (D3:G3 ) &lt;7, J3 = lo\u1ea1i kh\u00e1\u201d, 19000, If (J3= \u201c lo\u1ea1i trung b\u00ecnh\u201d, 0, 19.000)))).<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3,\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">IF(AND(J3=\u201dGi\u1ecfi\u201d,MIN(D3:G3)&gt;=7),240000: Mang \u00fd ngh\u0129a \u0111\u1eb7c tr\u01b0ng nh\u01b0 sau n\u1ebfu c\u00f3 sinh vi\u00ean n\u00e0o \u0111\u01b0\u1ee3c x\u1ebfp lo\u1ea1i Gi\u1ecfi (J3=&#8221;Gi\u1ecfi&#8221;).\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">IF(OR(AND(J3=\u201dGi\u1ecfi\u201d,MIN(D3:G3)&lt;7),J3=\u201dKh\u00e1\u201d),180000: H\u00e0m n\u00e0y c\u00f3 s\u1ef1 \u0111\u1eb7c bi\u1ec7t l\u00e0 c\u1ea3 hai tr\u01b0\u1eddng h\u1ee3p \u0111\u1ec1u \u0111\u00e3 x\u1ea3y ra.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">J3 = &#8220;Gi\u1ecfi&#8221; nh\u01b0ng MIN(D3:G3)&lt;7 th\u00ec lo\u1ea1i sinh vi\u00ean n\u00e0y ch\u1ec9 \u0111\u01b0\u1ee3c trao cho lo\u1ea1i h\u1ecdc b\u1ed5ng lo\u1ea1i Kh\u00e1 180000.<\/span><\/li>\n<\/ul>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">J3 = &#8220;Kh\u00e1&#8221; th\u00ec sinh vi\u00ean ch\u1ec9 \u0111\u01b0\u1ee3c trao cho h\u1ecdc b\u1ed5ng lo\u1ea1i Kh\u00e1 180000.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0=&gt; Ph\u1ea3i \u00e9p \u0111\u1eb7t c\u1ea3 2 tr\u01b0\u1eddng h\u1ee3p n\u00e0y trong <\/span><span style=\"font-weight: 400;\">h\u00e0m OR.<\/span><span style=\"font-weight: 400;\"> V\u1edbi \u0111i\u1ec1u ki\u1ec7n (1) Lo\u1ea1i gi\u1ecfi v\u00e0 c\u00f3 s\u1ed1 \u0111i\u1ec3m nh\u1ecf h\u01a1n l\u00e0 s\u1ed1 7 s\u1ebd \u0111\u1eb7t trong <\/span><span style=\"font-weight: 400;\">h\u00e0m AND.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">IF(J3=\u201dTrung b\u00ecnh\u201d,0,-180000): C\u00f3 \u00fd ngh\u0129a l\u00e0 sinh vi\u00ean x\u1ebfp lo\u1ea1i Trung b\u00ecnh th\u00ec kh\u00f4ng \u0111\u01b0\u1ee3c trao b\u1ea5t k\u00ec lo\u1ea1i h\u1ecdc b\u1ed5ng. Y\u1ebfu ph\u1ea3i n\u1ed9p \u0111\u00f3ng ti\u1ec1n h\u1ecdc l\u1ea1i l\u00e0 s\u1ed1 ti\u1ec1n 180000.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">H\u00ecnh d\u01b0\u1edbi \u0111\u00e2y s\u1ebd l\u00e0 k\u1ebft qu\u1ea3 m\u00e0 b\u1ea1n thu \u0111\u01b0\u1ee3c sau c\u00e1c thao t\u00e1c:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12273 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-3.jpg\" alt=\"\" width=\"600\" height=\"200\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/Thiet-ke-chua-co-ten-3-400x133.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">B\u00e0i vi\u1ebft l\u00e0 b\u1ea3ng t\u00f3m t\u1eaft c\u1ee7a c\u00e1c <\/span><b>c\u00e1ch x\u1ebfp lo\u1ea1i trong excel<\/b><span style=\"font-weight: 400;\">. Mong b\u1ea1n c\u00f3 s\u1ef1 ch\u00fa \u00fd k\u1ef9 c\u00e0ng \u0111\u1ec3 \u0111\u01b0\u1ee3c th\u00e0nh c\u00f4ng trong qu\u00e1 tr\u00ecnh thao t\u00e1c. C\u0169ng nh\u01b0 c\u00e1c <\/span><b>c\u00e1ch x\u1ebfp th\u1ee9 t\u1ef1 trong excel<\/b><span style=\"font-weight: 400;\">. Hy v\u1ecdng b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c th\u00e0nh c\u00f4ng v\u1edbi vi\u1ec7c n\u00e0y.\u00a0<\/span><\/p>\n<p>&gt;&gt;&gt; Tham kh\u1ea3o th\u00eam: <span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/teky.edu.vn\/blog\/cach-su-dung-ham-if-trong-excel\/\"><b><i>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF<\/i><\/b><\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>V\u1edbi th\u1eddi \u0111\u1ea1i c\u00f4ng ngh\u1ec7 hi\u1ec7n nay, nh\u1eefng thao t\u00e1c v\u1ec1 l\u00e0m vi\u1ec7c v\u1edbi nh\u1eefng con s\u1ed1 \u0111\u00e3 tr\u1edf n\u00ean d\u1ec5 d\u00e0ng. Ch\u1eb3ng h\u1ea1n nh\u01b0 vi\u1ec7c x\u1ebfp lo\u1ea1i trong excel c\u1ee7a gi\u00e1o vi\u00ean l\u00e0 vi\u1ec7c th\u01b0\u1eddng xuy\u00ean ph\u1ea3i l\u00e0m.. N\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft r\u00f5 th\u00ec h\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft n\u00e0y nh\u00e9. Vi\u1ec7c x\u1ebfp lo\u1ea1i &hellip;<\/p>\n","protected":false},"author":26,"featured_media":12275,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-12272","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>Nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1ch x\u1ebfp lo\u1ea1i trong excel<\/title>\n<meta name=\"description\" content=\"Vi\u1ec7c x\u1ebfp lo\u1ea1i trong excel c\u1ee7a gi\u00e1o vi\u00ean l\u00e0 vi\u1ec7c th\u01b0\u1eddng xuy\u00ean ph\u1ea3i l\u00e0m. N\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft r\u00f5 c\u00e1ch x\u1ebfp lo\u1ea1i trong excel th\u00ec h\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft n\u00e0y 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-xep-loai-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1ch x\u1ebfp lo\u1ea1i trong excel\" \/>\n<meta property=\"og:description\" content=\"Vi\u1ec7c x\u1ebfp lo\u1ea1i trong excel c\u1ee7a gi\u00e1o vi\u00ean l\u00e0 vi\u1ec7c th\u01b0\u1eddng xuy\u00ean ph\u1ea3i l\u00e0m. N\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft r\u00f5 c\u00e1ch x\u1ebfp lo\u1ea1i trong excel th\u00ec h\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-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=\"2024-03-03T07:28:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-04T08:46:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-22.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"H\u1eb1ng L\u00ea\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"H\u1eb1ng L\u00ea\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"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-xep-loai-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/\"},\"author\":{\"name\":\"H\u1eb1ng L\u00ea\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\"},\"headline\":\"Nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1ch x\u1ebfp lo\u1ea1i trong excel\",\"datePublished\":\"2024-03-03T07:28:40+00:00\",\"dateModified\":\"2024-03-04T08:46:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/\"},\"wordCount\":1790,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-22.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/\",\"name\":\"Nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1ch x\u1ebfp lo\u1ea1i trong excel\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-22.jpg\",\"datePublished\":\"2024-03-03T07:28:40+00:00\",\"dateModified\":\"2024-03-04T08:46:17+00:00\",\"description\":\"Vi\u1ec7c x\u1ebfp lo\u1ea1i trong excel c\u1ee7a gi\u00e1o vi\u00ean l\u00e0 vi\u1ec7c th\u01b0\u1eddng xuy\u00ean ph\u1ea3i l\u00e0m. N\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft r\u00f5 c\u00e1ch x\u1ebfp lo\u1ea1i trong excel th\u00ec h\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-22.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-22.jpg\",\"width\":600,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-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\":\"Nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1ch x\u1ebfp lo\u1ea1i trong excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b\",\"name\":\"H\u1eb1ng L\u00ea\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g\",\"caption\":\"H\u1eb1ng L\u00ea\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/lehang\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1ch x\u1ebfp lo\u1ea1i trong excel","description":"Vi\u1ec7c x\u1ebfp lo\u1ea1i trong excel c\u1ee7a gi\u00e1o vi\u00ean l\u00e0 vi\u1ec7c th\u01b0\u1eddng xuy\u00ean ph\u1ea3i l\u00e0m. N\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft r\u00f5 c\u00e1ch x\u1ebfp lo\u1ea1i trong excel th\u00ec h\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft n\u00e0y 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-xep-loai-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"Nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1ch x\u1ebfp lo\u1ea1i trong excel","og_description":"Vi\u1ec7c x\u1ebfp lo\u1ea1i trong excel c\u1ee7a gi\u00e1o vi\u00ean l\u00e0 vi\u1ec7c th\u01b0\u1eddng xuy\u00ean ph\u1ea3i l\u00e0m. N\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft r\u00f5 c\u00e1ch x\u1ebfp lo\u1ea1i trong excel th\u00ec h\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.","og_url":"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-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":"2024-03-03T07:28:40+00:00","article_modified_time":"2024-03-04T08:46:17+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-22.jpg","type":"image\/jpeg"}],"author":"H\u1eb1ng L\u00ea","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"H\u1eb1ng L\u00ea","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"8 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/"},"author":{"name":"H\u1eb1ng L\u00ea","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b"},"headline":"Nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1ch x\u1ebfp lo\u1ea1i trong excel","datePublished":"2024-03-03T07:28:40+00:00","dateModified":"2024-03-04T08:46:17+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/"},"wordCount":1790,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-22.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/","name":"Nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1ch x\u1ebfp lo\u1ea1i trong excel","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-22.jpg","datePublished":"2024-03-03T07:28:40+00:00","dateModified":"2024-03-04T08:46:17+00:00","description":"Vi\u1ec7c x\u1ebfp lo\u1ea1i trong excel c\u1ee7a gi\u00e1o vi\u00ean l\u00e0 vi\u1ec7c th\u01b0\u1eddng xuy\u00ean ph\u1ea3i l\u00e0m. N\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft r\u00f5 c\u00e1ch x\u1ebfp lo\u1ea1i trong excel th\u00ec h\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-22.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/1-22.jpg","width":600,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-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":"Nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1ch x\u1ebfp lo\u1ea1i trong excel"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/aba2a2e5a9eb4e0b390280d28d910d8b","name":"H\u1eb1ng L\u00ea","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d5cea52295ac99d8bda76636bd17e61d627a386d59def4d7f934bd3dace7b098?s=96&d=mm&r=g","caption":"H\u1eb1ng L\u00ea"},"url":"https:\/\/teky.edu.vn\/blog\/author\/lehang\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12272","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=12272"}],"version-history":[{"count":2,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12272\/revisions"}],"predecessor-version":[{"id":24336,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/12272\/revisions\/24336"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/12275"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=12272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=12272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=12272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}