{"id":4445,"date":"2024-12-05T18:48:14","date_gmt":"2024-12-05T18:48:14","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/05\/rank-if-clustered-index-danh-so-thu-tu-theo-dieu-kien-trong-excel\/"},"modified":"2024-12-05T18:48:14","modified_gmt":"2024-12-05T18:48:14","slug":"rank-if-clustered-index-danh-so-thu-tu-theo-dieu-kien-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/05\/rank-if-clustered-index-danh-so-thu-tu-theo-dieu-kien-trong-excel\/","title":{"rendered":"Rank IF, clustered index \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 theo \u0111i\u1ec1u ki\u1ec7n trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>M\u1ed9t v\u00ed d\u1ee5 v\u1ec1 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 theo \u0111i\u1ec1u ki\u1ec7n trong Excel s\u1eed d\u1ee5ng h\u00e0m COUNTIFS<\/p>\n<pre>=COUNTIFS($A$2:$A$9,A2,$B$2:$B$9,\"&gt;\"&amp;B2)+1<\/pre>\n<figure id=\"attachment_27834\" aria-describedby=\"caption-attachment-27834\" style=\"width: 1242px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/06\/danh-so-thu-tu-theo-dieu-kien.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-27834\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%201242%20726'%3E%3C\/svg%3E\" alt=\"danh-so-thu-tu-theo-dieu-kien\" width=\"1242\" height=\"726\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/danh-so-thu-tu-theo-dieu-kien.png 1242w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2019\/06\/danh-so-thu-tu-theo-dieu-kien-600x351.png 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2019\/06\/danh-so-thu-tu-theo-dieu-kien-300x175.png 300w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2019\/06\/danh-so-thu-tu-theo-dieu-kien-768x449.png 768w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2019\/06\/danh-so-thu-tu-theo-dieu-kien-1024x599.png 1024w\" data-lazy-sizes=\"(max-width: 1242px) 100vw, 1242px\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/danh-so-thu-tu-theo-dieu-kien.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-27834\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/danh-so-thu-tu-theo-dieu-kien.png\" alt=\"danh-so-thu-tu-theo-dieu-kien\" width=\"1242\" height=\"726\" title=\"danh-so-thu-tu-theo-dieu-kien\"><\/a><figcaption id=\"caption-attachment-27834\" class=\"wp-caption-text\">danh-so-thu-tu-theo-dieu-kien<\/figcaption><\/figure>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>M\u1ed9t v\u00ed d\u1ee5 v\u1ec1 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 theo \u0111i\u1ec1u ki\u1ec7n trong Excel s\u1eed d\u1ee5ng..<\/p>\n","protected":false},"author":1,"featured_media":4446,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4445","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4445","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=4445"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4445\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4446"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}