{"id":793,"date":"2020-08-25T11:41:50","date_gmt":"2020-08-25T04:41:50","guid":{"rendered":"https:\/\/hoctin.vn\/?p=793"},"modified":"2020-09-23T19:15:48","modified_gmt":"2020-09-23T12:15:48","slug":"ham-rank-trong-excel-tu-co-ban-den-nang-cao","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/ham-rank-trong-excel-tu-co-ban-den-nang-cao\/","title":{"rendered":"H\u01b0\u1edbng D\u1eabn C\u00e1c C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m RANK Trong Excel T\u1eeb C\u01a1 B\u1ea3n \u0110\u1ebfn N\u00e2ng Cao"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"793\" class=\"elementor elementor-793\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-217b94d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"217b94d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-30e1864\" data-id=\"30e1864\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c99451b elementor-widget elementor-widget-text-editor\" data-id=\"c99451b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m RANK l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m x\u1ebfp h\u1ea1ng c\u01a1 b\u1ea3n trong Excel d\u00f9ng \u0111\u1ec3 x\u1ebfp h\u1ea1ng m\u1ed9t s\u1ed1 trong danh s\u00e1ch c\u00e1c s\u1ed1. Ngo\u00e0i ra, c\u00f3 m\u1ed9t s\u1ed1 \u0111\u1ecbnh ngh\u0129a kh\u00e1c nh\u01b0 h\u00e0m RANK trong Excel l\u00e0 h\u00e0m x\u1ebfp th\u1ee9 t\u1ef1 t\u1eeb cao \u0111\u1ebfn th\u1ea5p ho\u1eb7c t\u1eeb th\u1ea5p \u0111\u1ebfn cao hay h\u00e0m RANK l\u00e0 h\u00e0m li\u1ec7t k\u00ea danh s\u00e1ch t\u0103ng d\u1ea7n ho\u1eb7c gi\u1ea3m d\u1ea7n.<\/span><\/p><p><span id=\"docs-internal-guid-3717ec3d-7fff-23b0-0637-f4a27a9e7955\"><br \/><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Trong b\u00e0i vi\u1ebft n\u00e0y, <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Hoctin.vn<\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"> s\u1ebd gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m RANK, c\u00f4ng th\u1ee9c x\u1ebfp h\u1ea1ng, \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1, m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 v\u00e0 m\u1eb9o n\u00e2ng cao c\u1ee7a h\u00e0m RANK trong Excel.<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-142171d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"142171d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d08c7c9\" data-id=\"d08c7c9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b05dd21 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"b05dd21\" data-element_type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:[],&quot;marker_view&quot;:&quot;bullets&quot;,&quot;icon&quot;:{&quot;value&quot;:&quot;&quot;,&quot;library&quot;:&quot;&quot;},&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t<h4 class=\"elementor-toc__header-title\">M\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft<\/h4>\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\"><i class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\"><i class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-loading eicon-animation-spin\" aria-hidden=\"true\"><\/i>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9e73a6d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9e73a6d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a252644\" data-id=\"a252644\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bfc7960 elementor-widget elementor-widget-heading\" data-id=\"bfc7960\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-a4cb03cd-7fff-e71a-3804-5893183b3d41\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1. C\u00e1ch D\u00f9ng H\u00e0m RANK Trong Excel<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-96894fa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"96894fa\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1027c40\" data-id=\"1027c40\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b48f0d9 elementor-widget elementor-widget-text-editor\" data-id=\"b48f0d9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y v\u1ec1 m\u1ed9t cu\u1ed9c thi \u0103n chu\u1ed1i c\u1ee7a gia \u0111\u00ecnh kh\u1ec9. \u0110\u1ec3 bi\u1ebft \u0111\u01b0\u1ee3c th\u1ee9 h\u1ea1ng c\u1ee7a nh\u1eefng ch\u00fa kh\u1ec9, nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o \u00f4 D3:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b id=\"docs-internal-guid-9ee64fdf-7fff-e5ab-3cd0-dc54fbe31112\" style=\"font-weight: normal;\">\u00a0<\/b><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=RANK(C3,$C$3:$C$9)<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\">\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Sau \u0111\u00f3, copy c\u00f4ng th\u1ee9c n\u00e0y v\u00e0o c\u00e1c \u00f4 D4:D9, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 gi\u00fap b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c th\u1ee9 t\u1ef1 x\u1ebfp h\u1ea1ng c\u1ea7n t\u00ecm.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4e15712 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4e15712\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e790703\" data-id=\"e790703\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bc79bc2 elementor-widget elementor-widget-image\" data-id=\"bc79bc2\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/08\/cach-dung-ham-rank-trong-excel.png\" title=\"cach-dung-ham-rank-trong-excel\" alt=\"C\u00e1ch D\u00f9ng H\u00e0m RANK Trong Excel\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f2153cb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f2153cb\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7c03a21\" data-id=\"7c03a21\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fd8e22d elementor-widget elementor-widget-text-editor\" data-id=\"fd8e22d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u00e2y l\u00e0 th\u1ee9 h\u1ea1ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp t\u1eeb l\u1edbn \u0111\u1ebfn b\u00e9 (gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n \u0111\u1ee9ng tr\u01b0\u1edbc).<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span id=\"docs-internal-guid-903c4afa-7fff-2e47-71c2-bb14a577d999\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Theo \u0111\u00f3, Kh\u1ec9 Tr\u1eafng \u0111\u01b0\u1ee3c x\u1ebfp h\u1ea1ng 1 v\u00ec \u0111\u00e3 \u0103n nhi\u1ec1u chu\u1ed1i nh\u1ea5t (8 tr\u00e1i), ti\u1ebfp \u0111\u1ebfn h\u1ea1ng 2 l\u00e0 Kh\u1ec9 Xanh (7 tr\u00e1i). \u1ede v\u1ecb tr\u00ed th\u1ea5p nh\u1ea5t l\u00e0 h\u1ea1ng 7 c\u1ee7a Kh\u1ec9 V\u00e0ng (3 tr\u00e1i).<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c37f835 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c37f835\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-25ca491\" data-id=\"25ca491\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e234c55 elementor-widget elementor-widget-heading\" data-id=\"e234c55\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2. C\u1ea5u Tr\u00fac H\u00e0m RANK<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5d83633 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5d83633\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fcd5928\" data-id=\"fcd5928\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-169b83e elementor-widget elementor-widget-text-editor\" data-id=\"169b83e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m RANK trong Excel c\u00f3 c\u00fa ph\u00e1p nh\u01b0 sau:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b style=\"font-weight: normal;\">\u00a0<\/b><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=<\/span><span style=\"font-size: 12pt; font-family: Arial; color: #1e1e1e; background-color: #ffffff; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">RANK(number,ref,[order])<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b style=\"font-weight: normal;\">\u00a0<\/b><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Trong \u0111\u00f3:<\/span><\/p><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-weight: bold; font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">number:<\/span><span style=\"font-weight: 400; font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> s\u1ed1 b\u1ea1n mu\u1ed1n x\u1ebfp h\u1ea1ng. Nh\u01b0 \u1edf v\u00ed d\u1ee5 tr\u00ean, c\u00f4ng th\u1ee9c h\u00e0m RANK \u1edf c\u00e1c \u00f4 t\u1eeb D3 \u0111\u1ebfn D9 c\u00f3 \u0111\u1ed1i s\u1ed1 <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"><b>number <\/b><\/span><span style=\"font-weight: 400; font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">t\u01b0\u01a1ng \u1ee9ng l\u1ea7n l\u01b0\u1ee3t l\u00e0 c\u00e1c \u00f4 t\u1eeb C3 \u0111\u1ebfn C9 (s\u1ed1 chu\u1ed1i \u0111\u00e3 \u0103n c\u1ee7a kh\u1ec9).<\/span><\/p><\/li><\/ul><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b id=\"docs-internal-guid-cf113968-7fff-802b-575f-4c77fe2388c2\" style=\"font-weight: normal;\">\u00a0<\/b><\/p><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">ref:<\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> danh s\u00e1ch c\u00e1c s\u1ed1. Trong v\u00ed d\u1ee5, danh s\u00e1ch c\u00e1c s\u1ed1 ch\u00ednh l\u00e0 c\u00e1c \u00f4 $C$3:$C$9.<\/span><\/p><\/li><\/ul><p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">L\u01b0u \u00fd:<\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> ta c\u1ea7n <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/hoctin.vn\/cach-co-dinh-dong-trong-excel\/\"><span style=\"font-size: 11pt; font-family: Arial; color: #1155cc; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t<\/span><\/a><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> nh\u01b0 n\u00e0y ($C$3:$C$9) thay v\u00ec (C3:C9) \u0111\u1ec3 khi copy t\u1eeb \u00f4 D3 sang c\u00e1c \u00f4 kh\u00e1c danh s\u00e1ch c\u00e1c s\u1ed1 kh\u00f4ng b\u1ecb thay \u0111\u1ed5i.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b style=\"font-weight: normal;\">\u00a0<\/b><\/p><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">order (c\u00f3 th\u1ec3 c\u00f3 ho\u1eb7c kh\u00f4ng):<\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> th\u1ee9 t\u1ef1 s\u1eafp x\u1ebfp t\u1eeb l\u1edbn \u0111\u1ebfn nh\u1ecf (nh\u1eadp s\u1ed1 0 ho\u1eb7c b\u1ecf tr\u1ed1ng) ho\u1eb7c ng\u01b0\u1ee3c l\u1ea1i, s\u1eafp x\u1ebfp t\u1eeb nh\u1ecf \u0111\u1ebfn l\u1edbn (nh\u1eadp gi\u00e1 tr\u1ecb 1).<\/span><\/p><\/li><\/ul><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\">\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-left: 36pt; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">V\u00ed d\u1ee5 tr\u00ean \u0111\u00e3 \u00e1p d\u1ee5ng ki\u1ec3u s\u1eafp x\u1ebfp t\u1eeb l\u1edbn \u0111\u1ebfn nh\u1ecf (b\u1ecf tr\u1ed1ng th\u00e0nh ph\u1ea7n order &#8211; t\u01b0\u01a1ng t\u1ef1 nh\u01b0 nh\u1eadp gi\u00e1 tr\u1ecb 0).<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-42f2b49 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"42f2b49\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-234b8ee\" data-id=\"234b8ee\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-19357d8 elementor-widget elementor-widget-heading\" data-id=\"19357d8\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><font color=\"#000000\" face=\"Arial\"><span style=\"font-size: 26.6667px;\">3. V\u00ed D\u1ee5 S\u1eafp X\u1ebfp T\u1eeb Nh\u1ecf \u0110\u1ebfn L\u1edbn<\/span><\/font><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3158d69 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3158d69\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-102d051\" data-id=\"102d051\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-aa19c82 elementor-widget elementor-widget-text-editor\" data-id=\"aa19c82\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u1ede v\u00ed d\u1ee5 1, hoctin.vn \u0111\u00e3 t\u00ecm \u0111\u01b0\u1ee3c th\u1ee9 t\u1ef1 x\u1ebfp h\u1ea1ng c\u1ee7a nh\u1eefng ch\u00fa kh\u1ec9 d\u1ef1a tr\u00ean s\u1ed1 chu\u1ed1i \u0111\u00e3 \u0103n \u0111\u01b0\u1ee3c. \u1ede v\u00ed d\u1ee5 sau \u0111\u00e2y, ch\u00fang ta s\u1ebd t\u00ecm th\u1ee9 h\u1ea1ng c\u1ee7a c\u00e1c th\u00e0nh vi\u00ean trong gia \u0111\u00ecnh kh\u1ec9 d\u1ef1a tr\u00ean th\u1eddi gian \u0103n chu\u1ed1i.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b id=\"docs-internal-guid-fb8daefe-7fff-55a2-1b53-4d6c597dd2d8\" style=\"font-weight: normal;\">\u00a0<\/b><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00f4ng th\u1ee9c c\u1ea7n nh\u1eadp \u1edf \u00f4 E3 l\u00e0:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b style=\"font-weight: normal;\">\u00a0<\/b><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=RANK(D3,$D$3:$D$9,1)<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Nh\u1eadp gi\u00e1 tr\u1ecb 1 \u1edf <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">th\u00e0nh ph\u1ea7n order <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">\u0111\u1ec3 \u00e1p d\u1ee5ng ki\u1ec3u s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u1eeb nh\u1ecf \u0111\u1ebfn l\u1edbn (kh\u1ec9 n\u00e0o th\u1eddi gian \u0103n c\u00e0ng \u00edt th\u00ec th\u1ee9 h\u1ea1ng c\u00e0ng cao).<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e28e26b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e28e26b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a63c1bd\" data-id=\"a63c1bd\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2087954 elementor-widget elementor-widget-image\" data-id=\"2087954\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/08\/ham-sap-xep-tu-nho-den-lon-trong-excel.png\" title=\"ham-sap-xep-tu-nho-den-lon-trong-excel\" alt=\"H\u00e0m Rank S\u1eafp X\u1ebfp T\u1eeb Nh\u1ecf \u0110\u1ebfn L\u1edbn Trong Excel\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-424fad1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"424fad1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-21a5cd9\" data-id=\"21a5cd9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-26f5c6e elementor-widget elementor-widget-text-editor\" data-id=\"26f5c6e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span id=\"docs-internal-guid-218fb157-7fff-ffbd-6ca8-8b755c3f0b1a\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Nh\u01b0 v\u1eady, Kh\u1ec9 Tr\u1eafng l\u1ea1i \u0111\u01b0\u1ee3c x\u1ebfp h\u1ea1ng 1, kh\u00f4ng nh\u1eefng \u0103n nhi\u1ec1u m\u00e0 c\u00f2n \u0103n nhanh (ch\u1ec9 trong 10 gi\u00e2y), qu\u1ea3 th\u1eadt l\u00e0 m\u1ed9t \u0111\u1ed1i th\u1ee7 \u0111\u00e1ng g\u1eddm. H\u1ea1ng 2 th\u00ec thu\u1ed9c v\u1ec1 Kh\u1ec9 V\u00e0ng (12 gi\u00e2y). H\u1ea1ng 3 thu\u1ed9c v\u1ec1 Kh\u1ec9 H\u1ed3ng (14 gi\u00e2y). V\u00e0 h\u1ea1ng th\u1ea5p nh\u1ea5t &#8211; h\u1ea1ng 7 thu\u1ed9c v\u1ec1 Kh\u1ec9 \u0110en (30 gi\u00e2y).<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-28e38ef elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"28e38ef\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ab974fe\" data-id=\"ab974fe\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-90ab449 elementor-widget elementor-widget-heading\" data-id=\"90ab449\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><font color=\"#000000\" face=\"Arial\"><span style=\"font-size: 26.6667px;\">4. M\u1ed9t S\u1ed1 M\u1eb9o N\u00e2ng Cao Trong H\u00e0m RANK<\/span><\/font><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b079471 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b079471\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d70a47e\" data-id=\"d70a47e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8f823d5 elementor-widget elementor-widget-heading\" data-id=\"8f823d5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><font color=\"#000000\" face=\"Arial\"><span style=\"font-size: 21.3333px;\">4.1 Thay \u0110\u1ed5i Ki\u1ec3u X\u1ebfp H\u1ea1ng Linh Ho\u1ea1t (Th\u00e0nh Ph\u1ea7n Order)<\/span><\/font><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c198377 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c198377\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-da30b32\" data-id=\"da30b32\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-92cc600 elementor-widget elementor-widget-text-editor\" data-id=\"92cc600\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Trong m\u1ed9t cu\u1ed9c thi kh\u00e1c, th\u1ec3 l\u1ec7 thi c\u00f3 s\u1ef1 thay \u0111\u1ed5i, khi ban t\u1ed5 ch\u1ee9c mu\u1ed1n trao th\u01b0\u1edfng cho ch\u00fa kh\u1ec9 ki\u00ean nh\u1eabn gi\u1ecfi nh\u1ea5t tr\u01b0\u1edbc c\u00e1m d\u1ed7 c\u1ee7a th\u1ee9c \u0103n, hay n\u00f3i c\u00e1ch kh\u00e1c l\u00e0 mu\u1ed1n t\u00ecm ra ch\u00fa kh\u1ec9 \u0103n \u00edt chu\u1ed1i nh\u1ea5t.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b id=\"docs-internal-guid-f6a35f4f-7fff-ae64-a2ea-d6a3b96f97e7\" style=\"font-weight: normal;\">\u00a0<\/b><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u0110i\u1ec1u n\u00e0y d\u1eabn t\u1edbi vi\u1ec7c b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eeda l\u1ea1i c\u00e1c c\u00f4ng th\u1ee9c \u0111\u00e3 vi\u1ebft \u1edf v\u00ed d\u1ee5 1. Sau \u0111\u00e2y, <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Hoctin.vn <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">s\u1ebd chia s\u1ebb cho b\u1ea1n m\u1ed9t m\u1eb9o c\u1ef1c hay \u0111\u1ec3 thay \u0111\u1ed5i ki\u1ec3u x\u1ebfp lo\u1ea1i m\u1ed9t c\u00e1ch linh ho\u1ea1t.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b style=\"font-weight: normal;\">\u00a0<\/b><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ea7u ti\u00ean, b\u1ea1n c\u1ea7n nh\u1eadp gi\u00e1 tr\u1ecb 1 v\u00e0o \u00f4 F2. Sau \u0111\u00f3, nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o \u00f4 D3:<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b style=\"font-weight: normal;\">\u00a0<\/b><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=RANK(C3,$C$3:$C$9,$F$2)<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\">\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ti\u1ebfp \u0111\u1ebfn, h\u00e3y copy c\u00f4ng th\u1ee9c \u1edf \u00f4 D3 sang c\u00e1c \u00f4 D4:D9. K\u1ebft qu\u1ea3 s\u1ebd cho ra b\u1ea3ng x\u1ebfp h\u1ea1ng c\u1ee7a nh\u1eefng ch\u00fa kh\u1ec9 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp t\u1eeb nh\u1ecf \u0111\u1ebfn l\u1edbn.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-af05eae elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"af05eae\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-eba99da\" data-id=\"eba99da\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-762be74 elementor-widget elementor-widget-image\" data-id=\"762be74\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/08\/thay-doi-kieu-xep-hang-linh-hoat-trong-excel.png\" title=\"thay-doi-kieu-xep-hang-linh-hoat-trong-excel\" alt=\"H\u00e0m Rank Thay \u0110\u1ed5i Ki\u1ec3u X\u1ebfp H\u1ea1ng Linh Ho\u1ea1t Trong Excel\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-02bacbc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"02bacbc\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0ee1e0a\" data-id=\"0ee1e0a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a697347 elementor-widget elementor-widget-text-editor\" data-id=\"a697347\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span id=\"docs-internal-guid-bc45b4e3-7fff-cc5b-415b-e855c4f81c57\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"><b>Sau n\u00e0y, n\u1ebfu b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i c\u00e1ch x\u1ebfp lo\u1ea1i trong Excel, ch\u1ec9 c\u1ea7n thay \u0111\u1ed5i gi\u1eefa hai gi\u00e1 tr\u1ecb 0 v\u00e0 1 \u1edf \u00f4 F2.<\/b><\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-499683a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"499683a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6219a97\" data-id=\"6219a97\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-16e56fc elementor-widget elementor-widget-heading\" data-id=\"16e56fc\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><font color=\"#000000\" face=\"Arial\"><span style=\"font-size: 21.3333px;\">4.2 Ph\u00e2n Bi\u1ec7t C\u00e1c Gi\u00e1 Tr\u1ecb C\u00f3 C\u00f9ng H\u1ea1ng (H\u00e0m RANK C\u00f3 \u0110i\u1ec1u Ki\u1ec7n)<\/span><\/font><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-847f59e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"847f59e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0a3dbd0\" data-id=\"0a3dbd0\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-84755f0 elementor-widget elementor-widget-text-editor\" data-id=\"84755f0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #3c4043; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u00e0m RANK x\u1ebfp h\u1ea1ng trong Excel tr\u1ea3 v\u1ec1 c\u00f9ng m\u1ed9t th\u1ee9 h\u1ea1ng X cho nh\u1eefng gi\u00e1 tr\u1ecb b\u1eb1ng nhau.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b id=\"docs-internal-guid-e53d9e50-7fff-d411-accd-fd18afc24099\" style=\"font-weight: normal;\">\u00a0<\/b><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #3c4043; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">D\u00f9 v\u1eady, th\u1ee9 h\u1ea1ng ti\u1ebfp theo s\u1ebd kh\u00f4ng ph\u1ea3i l\u00e0 X+1, v\u00e0 s\u1ebd b\u1ecb \u1ea3nh h\u01b0\u1edfng b\u1edfi s\u1ed1 gi\u00e1 tr\u1ecb b\u1eb1ng nhau \u1edf tr\u00ean. V\u00ed d\u1ee5, trong danh sa\u0301ch s\u00f4\u0301 t\u1ef1 nhi\u00ean {1,1,1,2,3} s\u0103\u0301p x\u00ea\u0301p theo th\u01b0\u0301 t\u01b0\u0323 t\u0103ng d\u00e2\u0300n, v\u00ec s\u1ed1 1 xu\u00e2\u0301t hi\u00ea\u0323n ba l\u00e2\u0300n va\u0300 co\u0301 th\u01b0\u0301 ha\u0323ng la\u0300 1 n\u00ean s\u1ed1 2 se\u0303 co\u0301 th\u01b0\u0301 ha\u0323ng 4 v\u00e0 s\u1ed1 3 c\u00f3 th\u1ee9 h\u1ea1ng l\u00e0 5 (kh\u00f4ng co\u0301 s\u00f4\u0301 na\u0300o co\u0301 th\u01b0\u0301 ha\u0323ng 2 v\u00e0 3).<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #3c4043; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #3c4043; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Nh\u01b0<\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"> v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, Kh\u1ec9 H\u1ed3ng v\u00e0 Kh\u1ec9 T\u00edm c\u00f9ng x\u1ebfp h\u1ea1ng 5 v\u00ec s\u1ed1 chu\u1ed1i \u0111\u00e3 \u0103n b\u1eb1ng nhau (4 tr\u00e1i). H\u1ea1ng 6 s\u1ebd b\u1ecb b\u1ecf qua, ti\u1ebfp \u0111\u1ebfn h\u1ea1ng 7 l\u00e0 c\u1ee7a Kh\u1ec9 V\u00e0ng.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b4198e7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b4198e7\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a0e2872\" data-id=\"a0e2872\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-05963bb elementor-widget elementor-widget-image\" data-id=\"05963bb\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/08\/ham-rank-co-dieu-kien-trong-excel.png\" title=\"ham-rank-co-dieu-kien-trong-excel\" alt=\"H\u00e0m Rank C\u00f3 \u0110i\u1ec1u Ki\u1ec7n Trong Excel\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7a84cb3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7a84cb3\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c1a94a4\" data-id=\"c1a94a4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-34d8075 elementor-widget elementor-widget-text-editor\" data-id=\"34d8075\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ban t\u1ed5 ch\u1ee9c mu\u1ed1n ph\u00e2n bi\u1ec7t r\u00f5 th\u1ee9 h\u1ea1ng c\u1ee7a Kh\u1ec9 H\u1ed3ng v\u00e0 Kh\u1ec9 T\u00edm d\u1ef1a v\u00e0o th\u1eddi gian \u0103n chu\u1ed1i. <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Hoctin.vn<\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> s\u1ebd chia s\u1ebb \u0111\u1ebfn c\u00e1c b\u1ea1n m\u1ed9t c\u00e1ch c\u00e1ch x\u1ebfp lo\u1ea1i c\u00e1c gi\u00e1 tr\u1ecb \u0111\u1ed3ng h\u1ea1ng trong Excel. <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"><b>Hoctin.vn<\/b><\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> s\u1ebd s\u1eed d\u1ee5ng h\u00e0m x\u1ebfp h\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n, l\u00e0 s\u1ef1 k\u1ebft h\u1ee3p gi\u1eefa <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/hoctin.vn\/ham-if-trong-excel\/\"><span style=\"font-size: 11pt; font-family: Arial; color: #1155cc; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">h\u00e0m IF<\/span><\/a><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">, h\u00e0m COUNTIF v\u00e0 h\u00e0m RANK.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b id=\"docs-internal-guid-d5fd1e1f-7fff-b791-cc6b-fb0e30912c73\" style=\"font-weight: normal;\">\u00a0<\/b><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ea7u ti\u00ean, b\u1ea1n c\u1ea7n t\u1ea1o th\u00eam c\u1ed9t <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u1ea1ng th\u1eadp ph\u00e2n <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">(x\u1ebfp h\u1ea1ng d\u1ef1a tr\u00ean th\u1eddi gian \u0103n chu\u1ed1i \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u1eeb nh\u1ecf \u0111\u1ebfn l\u1edbn \u1edf d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n). Sau \u0111\u00f3, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o \u00f4 F3 v\u00e0 copy sang c\u00e1c \u00f4 F4:F9<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\">\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">=IF(COUNTIF($C$3:$C$9,C3)&gt;1,RANK(D3,$D$3:$D$9,1)\/10,0)<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-00181d5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"00181d5\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9b5d8aa\" data-id=\"9b5d8aa\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-405afef elementor-widget elementor-widget-image\" data-id=\"405afef\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/08\/ham-xep-loai-co-dieu-kien-trong-excel.png\" title=\"ham-xep-loai-co-dieu-kien-trong-excel\" alt=\"H\u00e0m Rank H\u00e0m X\u1ebfp Lo\u1ea1i C\u00f3 \u0110i\u1ec1u Ki\u1ec7n Trong Excel\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1777324 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1777324\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e8fbd93\" data-id=\"e8fbd93\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-53f27ab elementor-widget elementor-widget-text-editor\" data-id=\"53f27ab\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">C\u00e1ch H\u00e0m X\u1ebfp Lo\u1ea1i C\u00f3 \u0110i\u1ec1u Ki\u1ec7n Ho\u1ea1t \u0110\u1ed9ng:<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><b style=\"font-weight:normal;\"><br><\/b><\/p><ol style=\"margin-top:0;margin-bottom:0;\"><li dir=\"ltr\" style=\"list-style-type:decimal;font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;margin-left: 4.5pt;\"><p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\" role=\"presentation\"><span style=\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">\u0110\u1ea7u ti\u00ean, Excel s\u1ebd ki\u1ec3m tra xem li\u1ec7u c\u00f3 gi\u00e1 tr\u1ecb n\u00e0o trong danh s\u00e1ch C3:C9 l\u1eb7p l\u1ea1i h\u01a1n m\u1ed9t l\u1ea7n kh\u00f4ng:<\/span><\/p><\/li><\/ol><p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><b style=\"font-weight:normal;\"><br><\/b><\/p><p dir=\"ltr\" style=\"line-height:1.38;margin-left: 36pt;text-indent: -36pt;text-align: justify;margin-top:0pt;margin-bottom:0pt;padding:0pt 0pt 0pt 36pt;\"><span style=\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">   COUNTIF($C$3:$C$9,C3)&gt;1<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><b style=\"font-weight:normal;\"><br><\/b><\/p><ol style=\"margin-top:0;margin-bottom:0;\" start=\"2\"><li dir=\"ltr\" style=\"list-style-type:decimal;font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;margin-left: 4.5pt;\"><p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\" role=\"presentation\"><span style=\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">N\u1ebfu c\u00f3 gi\u00e1 tr\u1ecb l\u1eb7p l\u1ea1i tr\u00ean m\u1ed9t l\u1ea7n, Excel s\u1ebd t\u00ecm th\u1ee9 h\u1ea1ng c\u1ee7a gi\u00e1 tr\u1ecb \u0111\u00f3 theo chi\u1ec1u s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n:<\/span><\/p><\/li><\/ol><p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><b style=\"font-weight:normal;\"><br><\/b><\/p><p dir=\"ltr\" style=\"line-height:1.38;text-indent: 36pt;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">   RANK(D3,$D$3:$D$9,1)<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><b style=\"font-weight:normal;\"><br><\/b><\/p><ol style=\"margin-top:0;margin-bottom:0;\" start=\"3\"><li dir=\"ltr\" style=\"list-style-type:decimal;font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;margin-left: 4.5pt;\"><p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\" role=\"presentation\"><span style=\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Sau \u0111\u00f3, Excel s\u1ebd chia cho 10 \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c s\u1ed1 th\u1eadp ph\u00e2n. <\/span><span style=\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">S\u1ed1 H\u1ea1ng th\u1eadp ph\u00e2n<\/span><span style=\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\"> n\u00e0y \u0111em c\u1ed9ng v\u1edbi <\/span><span style=\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">X\u1ebfp h\u1ea1ng ban \u0111\u1ea7u <\/span><span style=\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">s\u1ebd ra \u0111\u01b0\u1ee3c <\/span><span style=\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">X\u1ebfp h\u1ea1ng cu\u1ed1i c\u00f9ng.<\/span><\/p><\/li><\/ol><p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\"><span style=\"white-space:pre;\">\t<\/span><\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\"><span style=\"white-space:pre;\">\t<\/span>       <\/span><span style=\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">\/10<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><b style=\"font-weight:normal;\"><br><\/b><\/p><p dir=\"ltr\" style=\"line-height:1.38;margin-left: 36pt;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">   L\u01b0u \u00fd:<\/span><span style=\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\"> N\u1ebfu danh s\u00e1ch c\u1ee7a c\u00e1c b\u1ea1n d\u00e0i h\u01a1n th\u00ec c\u00f3 th\u1ec3 \u0111em chia cho 100 \/ 1000 \/\u2026 \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c s\u1ed1 th\u1eadp ph\u00e2n.<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><b style=\"font-weight:normal;\"><br><\/b><\/p><ol style=\"margin-top:0;margin-bottom:0;\" start=\"4\"><li dir=\"ltr\" style=\"list-style-type:decimal;font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;margin-left: 4.5pt;\"><p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\" role=\"presentation\"><span style=\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">Cu\u1ed1i c\u00f9ng, \u0111\u1ec3 ho\u00e0n th\u00e0nh <\/span><a href=\"https:\/\/hoctin.vn\/ham-if-trong-excel\/\" style=\"text-decoration:none;\"><span style=\"font-size:11pt;font-family:Arial;color:#1155cc;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:underline;-webkit-text-decoration-skip:none;text-decoration-skip-ink:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">h\u00e0m IF<\/span><\/a><span style=\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">, n\u1ebfu gi\u00e1 tr\u1ecb ch\u1ec9 l\u1eb7p l\u1ea1i m\u1ed9t l\u1ea7n th\u00ec Excel s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb 0.<\/span><\/p><\/li><\/ol><p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><br><\/p><p dir=\"ltr\" style=\"line-height:1.38;text-align: justify;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\"><span style=\"white-space:pre;\">\t<\/span>      <\/span><span style=\"font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;\">,0)<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2984773 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2984773\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-64d98b7\" data-id=\"64d98b7\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a721fa6 elementor-widget elementor-widget-text-editor\" data-id=\"a721fa6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Nh\u01b0 v\u1eady, x\u1ebfp h\u1ea1ng cu\u1ed1i c\u00f9ng c\u1ee7a Kh\u1ec9 H\u1ed3ng (5.3) cao h\u01a1n c\u1ee7a Kh\u1ec9 T\u00edm (5.4) do Kh\u1ec9 H\u1ed3ng \u0103n nhanh h\u01a1n 1 gi\u00e2y.&nbsp;<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><b id=\"docs-internal-guid-72689b02-7fff-892b-459d-a94a9747f137\" style=\"font-weight: normal;\">&nbsp;<\/b><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.656; text-align: justify; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1c v\u00ed d\u1ee5 v\u00e0 m\u1eb9o hay v\u1ec1 h\u00e0m RANK trong Excel. Hi v\u1ecdng b\u00e0i vi\u1ebft c\u1ee7a <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Hoctin.vn<\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> \u0111\u00e3 mang l\u1ea1i cho c\u00e1c b\u1ea1n c\u00e1c th\u00f4ng tin h\u1eefu \u00edch v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m RANK trong Excel.<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.656; text-align: justify; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&nbsp;<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.656; text-align: justify; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ngo\u00e0i ra, \u0111\u1ec3 \u1ee9ng d\u1ee5ng hi\u1ec7u qu\u1ea3 Excel, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m v\u00e0 c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel. H\u00e3y c\u00f9ng \u0111\u00f3n \u0111\u1ecdc series b\u00e0i vi\u1ebft \u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m Excel:<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.656; text-align: justify; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&nbsp;<\/span><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.9871999999999999; text-align: justify; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/cach-co-dinh-dong-trong-excel\/\" target=\"_blank\">C\u00e1ch C\u1ed1 \u0110\u1ecbnh D\u00f2ng V\u00e0 C\u1ed9t<\/a><br><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.9871999999999999; text-align: justify; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-if-trong-excel\/\" target=\"_blank\">H\u00e0m IF<\/a><br><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.9871999999999999; text-align: justify; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-countif-co-ban\/\" target=\"_blank\" rel=\"noopener\">H\u00e0m COUNTIF<\/a><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.656; text-align: justify; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt;\">\n<\/p><p dir=\"ltr\" style=\"line-height: 1.656; text-align: justify; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt;\"><a href=\"https:\/\/hoctin.vn\/ham-index-match-trong-excel\/\" target=\"_blank\">H\u00e0m INDEX<\/a><br><\/p>\n<div>&nbsp;<\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>H\u00e0m RANK l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m x\u1ebfp h\u1ea1ng c\u01a1 b\u1ea3n trong Excel d\u00f9ng \u0111\u1ec3 x\u1ebfp h\u1ea1ng m\u1ed9t s\u1ed1 trong danh s\u00e1ch c\u00e1c s\u1ed1. Ngo\u00e0i ra, c\u00f3 m\u1ed9t s\u1ed1 \u0111\u1ecbnh ngh\u0129a kh\u00e1c nh\u01b0 h\u00e0m RANK trong Excel l\u00e0 h\u00e0m x\u1ebfp th\u1ee9 t\u1ef1 t\u1eeb cao \u0111\u1ebfn th\u1ea5p ho\u1eb7c t\u1eeb th\u1ea5p \u0111\u1ebfn cao hay h\u00e0m RANK l\u00e0 &#8230; <a title=\"H\u01b0\u1edbng D\u1eabn C\u00e1c C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m RANK Trong Excel T\u1eeb C\u01a1 B\u1ea3n \u0110\u1ebfn N\u00e2ng Cao\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/ham-rank-trong-excel-tu-co-ban-den-nang-cao\/\">Read more <span class=\"screen-reader-text\">H\u01b0\u1edbng D\u1eabn C\u00e1c C\u00e1ch S\u1eed D\u1ee5ng H\u00e0m RANK Trong Excel T\u1eeb C\u01a1 B\u1ea3n \u0110\u1ebfn N\u00e2ng Cao<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":797,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[6,33],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/793"}],"collection":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/comments?post=793"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/793\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/797"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}