{"id":24036,"date":"2021-05-06T16:36:30","date_gmt":"2021-05-06T09:36:30","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24036"},"modified":"2021-05-06T16:36:30","modified_gmt":"2021-05-06T09:36:30","slug":"ham-rank-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-rank-trong-excel\/","title":{"rendered":"H\u00e0m Rank trong Excel &#8211; C\u00e1c v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Rank"},"content":{"rendered":"<p><strong>H\u00e0m Rank trong Excel<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u theo th\u1ee9 t\u1ef1 t\u1eeb cao xu\u1ed1ng th\u1ea5p ho\u1eb7c t\u1eeb th\u1ea5p l\u00ean cao. Kh\u00e1c v\u1edbi nhi\u1ec1u h\u00e0m Excel kh\u00e1c, h\u00e0m Rank ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb l\u00e0 s\u1ed1. \u0110\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00fa ph\u00e1p h\u00e0m Rank, c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Excel nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o ti\u1ebfp b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ben Computer.<\/p>\n<h2><strong>C\u00fa ph\u00e1p h\u00e0m Rank trong Excel<\/strong><\/h2>\n<p><strong>H\u00e0m Rank trong Excel<\/strong> c\u00f3 c\u00fa ph\u00e1p, c\u00f4ng th\u1ee9c nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><strong>RANK(number,ref,[order])<\/strong><\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<p><strong>\u2013 Number<\/strong>\u00a0(tham s\u1ed1 b\u1eaft bu\u1ed9c), l\u00e0 s\u1ed1 c\u1ea7n x\u1ebfp h\u1ea1ng trong danh s\u00e1ch.<\/p>\n<p><strong>\u2013 Ref<\/strong>\u00a0(tham s\u1ed1 b\u1eaft bu\u1ed9c): l\u00e0 danh s\u00e1ch c\u00e1c s\u1ed1 c\u1ea7n x\u1ebfp h\u1ea1ng. Tham s\u1ed1 n\u00e0y c\u00f3 th\u1ec3 l\u00e0 m\u1ea3ng s\u1ed1 ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn danh s\u00e1ch c\u00e1c s\u1ed1.<\/p>\n<p><strong>\u2013 Order<\/strong>\u00a0(tham s\u1ed1 t\u00f9y ch\u1ecdn): l\u00e0 c\u00e1ch s\u1eafp x\u1ebfp gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n, t\u0103ng d\u1ea7n hay gi\u1ea3m d\u1ea7n.<br \/>\nN\u1ebfu tham s\u1ed1 n\u00e0y l\u00e0 0 ho\u1eb7c b\u1ecb b\u1ecf qua, c\u00e1c gi\u00e1 gi\u00e1 tr\u1ecb s\u1ebd \u0111\u01b0\u1ee3c x\u1ebfp h\u1ea1ng theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n (t\u1ee9c l\u00e0 t\u1eeb l\u1edbn nh\u1ea5t \u0111\u1ebfn nh\u1ecf nh\u1ea5t).<\/p>\n<p>N\u1ebfu tham s\u1ed1 n\u00e0y l\u00e0 1 ho\u1eb7c c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng ph\u1ea3i l\u00e0 0, c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c x\u1ebfp h\u1ea1ng theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n, t\u1ee9c l\u00e0 t\u1eeb nh\u1ecf nh\u1ea5t \u0111\u1ebfn l\u1edbn nh\u1ea5t.<\/p>\n<figure id=\"attachment_24040\" aria-describedby=\"caption-attachment-24040\" style=\"width: 750px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"390\" class=\"wp-image-24040 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-rank-trong-excel.jpg\" alt=\"H\u00e0m Rank trong Excel\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-rank-trong-excel.jpg 750w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-rank-trong-excel-300x156.jpg 300w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><figcaption id=\"caption-attachment-24040\" class=\"wp-caption-text\">H\u00e0m Rank trong Excel<\/figcaption><\/figure>\n<h2><strong>H\u00e0m RANK.EQ trong Excel<\/strong><\/h2>\n<p>H\u00e0m RANK.EQ c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 thay th\u1ebf h\u00e0m Rank trong Excel. H\u00e0m n\u00e0y \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u \u0111\u1ea7u ti\u00ean tr\u00ean Excel 2010. V\u1ec1 c\u01a1 b\u1ea3n h\u00e0m RANK.EQ c\u00f3 c\u00fa ph\u00e1p v\u00e0 ho\u1ea1t \u0111\u1ed9ng t\u1ef1 t\u01b0\u01a1ng t\u1ef1 h\u00e0m Rank Excel. Trong \u0111\u00f3 EQ l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a Equal.<\/p>\n<p>C\u00fa ph\u00e1p h\u00e0m RANK.EQ Excel c\u00f3 d\u1ea1ng:<\/p>\n<p><strong>RANK.EQ(number,ref,[order])<\/strong><\/p>\n<p>Trong Excel 2007 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n Excel c\u0169 h\u01a1n, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Rank. C\u00f2n tr\u00ean Excel 2010, Excel 2013 v\u00e0 Excel 2016, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m RANK ho\u1eb7c RANK.EQ \u0111\u1ec3 x\u1ebfp th\u1ee9 h\u1ea1ng.<\/p>\n<h2><strong>H\u00e0m RANK.AVG trong Excel<\/strong><\/h2>\n<p>RANK.AVG c\u0169ng l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m x\u1ebfp th\u1ee9 h\u1ea1ng kh\u00e1c trong Excel. Trong \u0111\u00f3 AVG l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a Average. Tuy nhi\u00ean h\u00e0m Excel n\u00e0y ch\u1ec9 kh\u1ea3 d\u1ee5ng tr\u00ean c\u00e1c phi\u00ean b\u1ea3n Excel 2010, Excel 2013, Excel 2016 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n cao h\u01a1n.<\/p>\n<p>C\u00fa ph\u00e1p h\u00e0m RANK.AVG c\u00f3 d\u1ea1ng:<\/p>\n<p><strong>RANK.AVG(number,ref,[order])<\/strong><\/p>\n<p>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng <strong>h\u00e0m Rank trong Excel<\/strong><\/p>\n<ul>\n<li><strong>H\u00e0m Rank Excel<\/strong> ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1, bao g\u1ed3m s\u1ed1 d\u01b0\u01a1ng v\u00e0 s\u1ed1 \u00e2m, s\u1ed1 0, gi\u00e1 tr\u1ecb ng\u00e0y v\u00e0 gi\u1edd. C\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a tham s\u1ed1 ref kh\u00f4ng ph\u1ea3i l\u00e0 gi\u00e1 tr\u1ecb s\u1ed1 s\u1ebd b\u1ecb b\u1ecf qua.<\/li>\n<li>T\u1ea5t c\u1ea3 c\u00e1c h\u00e0m Rank tr\u1ea3 v\u1ec1 c\u00f9ng m\u1ed9t th\u1ee9 h\u1ea1ng cho c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p v\u00e0 b\u1ecf qua x\u1ebfp h\u1ea1ng ti\u1ebfp theo.<\/li>\n<li>Trong Excel 2010 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n m\u1edbi h\u01a1n, <strong>h\u00e0m Rank Excel<\/strong> \u0111\u01b0\u1ee3c thay th\u1ebf b\u1eb1ng c\u00e1c h\u00e0m RANK.EQ v\u00e0 RANK.AVG.<\/li>\n<li>N\u1ebfu gi\u00e1 tr\u1ecb tham chi\u1ebfu ref kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1, <strong>h\u00e0m Rank Excel<\/strong> s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A.<\/li>\n<\/ul>\n<h2><strong>H\u00e0m Rank trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<\/strong><\/h2>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m Rank trong Excel<\/strong>.<\/p>\n<p>Cho danh s\u00e1ch 12 \u0111\u1ed9i tham d\u1ef1 gi\u1ea3i thi \u0111\u1ea5u d\u01b0\u1edbi \u0111\u00e2y. Y\u00eau c\u1ea7u l\u00e0 x\u1ebfp h\u1ea1ng c\u00e1c \u0111\u1ed9i trong danh s\u00e1ch n\u00e0y.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"354\" height=\"371\" class=\"aligncenter wp-image-17139 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-13.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-13-286x300.png 286w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-13.png 354w\" alt=\"V\u00ed d\u1ee5 v\u1ec1 c\u00e1c s\u1eed d\u1ee5ng h\u00e0m Rank trong Excel - \u1ea2nh 1\" \/><\/p>\n<p>V\u00ec h\u00e0m Rank ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng tr\u00ean Excel 2007 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n c\u0169 h\u01a1n, do \u0111\u00f3 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m RANK.EQ \u0111\u1ec3 thay th\u1ebf h\u00e0m Rank.<\/p>\n<p>V\u1ec1 c\u01a1 b\u1ea3n 2 h\u00e0m Excel n\u00e0y \u0111\u1ec1u th\u1ef1c hi\u1ec7n ch\u1ee9c n\u0103ng gi\u1ed1ng nhau l\u00e0 x\u1ebfp th\u1ee9 h\u1ea1ng.<\/p>\n<p>S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c h\u00e0m RANK.EQ trong \u00f4 E2 nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"474\" height=\"375\" class=\"aligncenter wp-image-17140 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-12.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-12-300x237.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-12.png 474w\" alt=\"V\u00ed d\u1ee5 v\u1ec1 c\u00e1c s\u1eed d\u1ee5ng h\u00e0m Rank trong Excel - \u1ea2nh 2\" \/><\/p>\n<p>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u00f3 d\u1ea1ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"479\" height=\"375\" class=\"aligncenter wp-image-17141 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-9.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-9-300x235.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-9.png 479w\" alt=\"V\u00ed d\u1ee5 v\u1ec1 c\u00e1c s\u1eed d\u1ee5ng h\u00e0m Rank trong Excel - \u1ea2nh 3\" \/><\/p>\n<p>K\u00e9o c\u00f4ng th\u1ee9c t\u1eeb \u00f4 C2 xu\u1ed1ng c\u00e1c \u00f4 C13. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"479\" height=\"375\" class=\"aligncenter wp-image-17142 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-9.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-9-300x235.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-9.png 479w\" alt=\"V\u00ed d\u1ee5 v\u1ec1 c\u00e1c s\u1eed d\u1ee5ng h\u00e0m Rank trong Excel - \u1ea2nh 4\" \/><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean:<\/p>\n<p>\u2013 H\u00e0m <strong>=RANK.EQ (B2, $B$2:$B$13)<\/strong> trong \u00f4 C2 tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1 (th\u1ee9 h\u1ea1ng) l\u00e0 12. Trong danh s\u00e1ch ch\u00fang ta c\u00f3 t\u1ed5ng 12 \u0111\u1ed9i, m\u00e0 \u0111\u1ed9i n\u00e0y ghi \u0111\u01b0\u1ee3c 12 \u0111i\u1ec3m, l\u00e0 s\u1ed1 \u0111i\u1ec3m th\u1ea5p nh\u1ea5t n\u00ean h\u00e0m Rank.eq x\u1ebfp h\u1ea1ng th\u1ee9 12, l\u00e0 x\u1ebfp h\u1ea1ng cu\u1ed1i c\u00f9ng.<\/p>\n<p>\u2013 H\u00e0m <strong>=RANK.EQ (B3, $B$2:$B$13)<\/strong> tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1 (th\u1ee9 h\u1ea1ng) l\u00e0 1. \u0110\u1ed9i n\u00e0y ghi \u0111\u01b0\u1ee3c 105 \u0111i\u1ec3m, l\u00e0 s\u1ed1 \u0111i\u1ec3m cao nh\u1ea5t trong s\u1ed1 12 \u0111\u1ed9i trong danh s\u00e1ch n\u00ean h\u00e0m Rank.eq x\u1ebfp h\u1ea1ng l\u00e0 1.<\/p>\n<p>B\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y Ben Computer v\u1eeba gi\u1edbi thi\u1ec7u cho b\u1ea1n v\u1ec1 <strong>h\u00e0m Rank trong Excel<\/strong> v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u1ee7a h\u00e0m n\u00e0y. B\u00ean c\u1ea1nh \u0111\u00f3 \u0111\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng <a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-nhan-trong-excel\/\">h\u00e0m nh\u00e2n trong Excel<\/a> nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft \u0111\u00e3 c\u00f3 tr\u00ean trang \u0111\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m Rank trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u theo th\u1ee9 t\u1ef1 t\u1eeb cao xu\u1ed1ng th\u1ea5p ho\u1eb7c t\u1eeb th\u1ea5p l\u00ean cao. Kh\u00e1c v\u1edbi nhi\u1ec1u h\u00e0m Excel kh\u00e1c, h\u00e0m Rank ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb l\u00e0 s\u1ed1. \u0110\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00fa ph\u00e1p h\u00e0m Rank, c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Excel [&hellip;]<\/p>\n","protected":false},"author":39,"featured_media":24040,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-24036","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24036","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=24036"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24036\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/24040"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=24036"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=24036"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=24036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}