{"id":256983,"date":"2023-09-11T21:19:56","date_gmt":"2023-09-11T14:19:56","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=256983"},"modified":"2025-12-25T22:20:36","modified_gmt":"2025-12-25T15:20:36","slug":"ham-rank-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/","title":{"rendered":"H\u00e0m RANK trong Excel: H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng chi ti\u1ebft \u0111\u1ec3 x\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">H\u00e0m Rank trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap ng\u01b0\u1eddi d\u00f9ng ph\u00e2n lo\u1ea1i v\u00e0 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3. Trong b\u1ed1i c\u1ea3nh d\u1eef li\u1ec7u \u0111\u00f3ng vai tr\u00f2 quan tr\u1ecdng trong vi\u1ec7c \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh, vi\u1ec7c hi\u1ec3u r\u00f5 v\u00e0 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Rank l\u00e0 \u0111i\u1ec1u kh\u00f4ng th\u1ec3 thi\u1ebfu cho b\u1ea5t k\u1ef3 ng\u01b0\u1eddi d\u00f9ng Excel n\u00e0o. Trong b\u00e0i vi\u1ebft n\u00e0y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u h\u01a1n v\u1ec1 h\u00e0m Rank c\u0169ng nh\u01b0 c\u00e1ch s\u1eed d\u1ee5ng H\u00e0m Rank trong Excel.<\/span><\/p>\n<h2><b>H\u00e0m RANK trong Excel l\u00e0 g\u00ec v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u01a1n gi\u1ea3n nh\u1ea5t?<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">H\u00e0m RANK l\u00e0 c\u00f4ng c\u1ee5 th\u1ed1ng k\u00ea m\u1ea1nh m\u1ebd gi\u00fap x\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u nhanh ch\u00f3ng, t\u1eeb cao xu\u1ed1ng th\u1ea5p ho\u1eb7c th\u1ea5p \u0111\u1ebfn cao. L\u00fd t\u01b0\u1edfng cho b\u00e1o c\u00e1o doanh s\u1ed1, \u0111i\u1ec3m s\u1ed1 h\u1ecdc sinh hay th\u1ed1ng k\u00ea KPI. B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00fa ph\u00e1p RANK(number, ref, [order]), v\u00ed d\u1ee5 th\u1ef1c t\u1ebf k\u00e8m h\u00ecnh \u1ea3nh, x\u1eed l\u00fd tr\u00f9ng l\u1eb7p v\u00e0 so s\u00e1nh v\u1edbi RANK.AVG\/RANK.EQ.<\/span><\/p>\n<p>M\u1ee5c \u0111\u00edch ch\u00ednh c\u1ee7a h\u00e0m Rank:<\/p>\n<ul>\n<li>X\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u trong m\u1ed9t danh s\u00e1ch<\/li>\n<li>So s\u00e1nh v\u00e0 ph\u00e2n lo\u1ea1i d\u1eef li\u1ec7u d\u1ef1a tr\u00ean ti\u00eau ch\u00ed c\u1ee5 th\u1ec3<\/li>\n<li>H\u1ed7 tr\u1ee3 trong vi\u1ec7c \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh d\u1ef1a tr\u00ean d\u1eef li\u1ec7u v\u00e0 x\u1ebfp h\u1ea1ng<\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-256987 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel.jpg\" alt=\"ham-rank-trong-excel\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>T\u1ea7m quan tr\u1ecdng c\u1ee7a vi\u1ec7c bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Rank trong Excel khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u:<\/strong><\/p>\n<p>Khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u &#8211; d\u00f9 \u0111\u00f3 l\u00e0 d\u1eef li\u1ec7u doanh nghi\u1ec7p, k\u1ebft qu\u1ea3 nghi\u00ean c\u1ee9u ho\u1eb7c b\u1ea5t k\u1ef3 t\u1eadp h\u1ee3p th\u00f4ng tin n\u00e0o, vi\u1ec7c c\u00f3 kh\u1ea3 n\u0103ng s\u1eafp x\u1ebfp v\u00e0 ph\u00e2n t\u00edch nhanh ch\u00f3ng gi\u00fap ng\u01b0\u1eddi d\u00f9ng ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 n\u00e2ng cao hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c.<\/p>\n<p>Bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Rank trong Excel gi\u00fap:<\/p>\n<ul>\n<li>\u0110\u01b0a ra nh\u1eefng quy\u1ebft \u0111\u1ecbnh ch\u00ednh x\u00e1c h\u01a1n d\u1ef1a tr\u00ean x\u1ebfp h\u1ea1ng v\u00e0 so s\u00e1nh.<\/li>\n<li>Ti\u1ebft ki\u1ec7m th\u1eddi gian khi kh\u00f4ng c\u1ea7n ph\u1ea3i s\u1eafp x\u1ebfp d\u1eef li\u1ec7u th\u1ee7 c\u00f4ng.<\/li>\n<li>Tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, gi\u00fap tr\u00ecnh b\u00e0y th\u00f4ng tin m\u1ed9t c\u00e1ch r\u00f5 r\u00e0ng v\u00e0 thuy\u1ebft ph\u1ee5c.<\/li>\n<\/ul>\n<h2>L\u1ecbch s\u1eed v\u00e0 c\u00e1c phi\u00ean b\u1ea3n h\u00e0m Rank trong Excel<\/h2>\n<p>H\u00e0m Rank trong ph\u1ea7n m\u1ec1m Excel kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t t\u00ednh n\u0103ng m\u1edbi, nh\u01b0ng n\u00f3 \u0111\u00e3 tr\u1edf th\u00e0nh m\u1ed9t c\u00f4ng c\u1ee5 \u0111\u1eafc l\u1ef1c cho ng\u01b0\u1eddi d\u00f9ng trong su\u1ed1t nhi\u1ec1u n\u0103m qua. Theo \u0111\u00f3, h\u00e0m Rank \u0111\u00e3 \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u l\u1ea7n \u0111\u1ea7u ti\u00ean trong Excel 2000. T\u1eeb \u0111\u00f3, n\u00f3 \u0111\u00e3 nhanh ch\u00f3ng tr\u1edf th\u00e0nh m\u1ed9t trong nh\u1eefng h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn \u0111\u1ec3 gi\u00fap ng\u01b0\u1eddi d\u00f9ng x\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u c\u1ee7a h\u1ecd m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-lich-su.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-lich-su-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-lich-su-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-256986 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-lich-su.jpg\" alt=\"ham-rank-trong-excel-lich-su\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-lich-su.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-lich-su-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-lich-su-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>Thay \u0111\u1ed5i qua t\u1eebng phi\u00ean b\u1ea3n Excel<\/strong><\/p>\n<p><strong>Excel 2000 \u0111\u1ebfn Excel 2007<\/strong>: Trong giai \u0111o\u1ea1n n\u00e0y, h\u00e0m Rank gi\u1eef nguy\u00ean ch\u1ee9c n\u0103ng c\u01a1 b\u1ea3n c\u1ee7a n\u00f3 v\u00e0 kh\u00f4ng c\u00f3 nhi\u1ec1u thay \u0111\u1ed5i \u0111\u00e1ng k\u1ec3. Ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 x\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u d\u1ef1a tr\u00ean m\u1ed9t danh s\u00e1ch v\u00e0 x\u00e1c \u0111\u1ecbnh vi\u1ec7c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n ho\u1eb7c gi\u1ea3m d\u1ea7n.<\/p>\n<p><strong>Excel 2010 v\u00e0 sau<\/strong>: Microsoft \u0111\u00e3 gi\u1edbi thi\u1ec7u th\u00eam hai h\u00e0m m\u1edbi li\u00ean quan \u0111\u1ebfn Rank: RANK.EQ v\u00e0 RANK.AVG. Trong khi RANK.EQ ho\u1ea1t \u0111\u1ed9ng gi\u1ed1ng nh\u01b0 h\u00e0m Rank truy\u1ec1n th\u1ed1ng, RANK.AVG \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u1ebfp h\u1ea1ng gi\u00e1 tr\u1ecb trung b\u00ecnh trong tr\u01b0\u1eddng h\u1ee3p c\u00f3 gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p.<\/p>\n<p><strong>Excel 2013 tr\u1edf \u0111i<\/strong>: H\u00e0m Rank g\u1ed1c b\u1eaft \u0111\u1ea7u b\u1ecb coi l\u00e0 l\u1ed7i th\u1eddi v\u00e0 Microsoft khuy\u1ebfn kh\u00edch ng\u01b0\u1eddi d\u00f9ng s\u1eed d\u1ee5ng RANK.EQ v\u00e0 RANK.AVG thay th\u1ebf. Tuy nhi\u00ean, \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u01b0\u01a1ng th\u00edch ng\u01b0\u1ee3c, h\u00e0m Rank v\u1eabn \u0111\u01b0\u1ee3c gi\u1eef l\u1ea1i v\u00e0 ho\u1ea1t \u0111\u1ed9ng nh\u01b0 tr\u01b0\u1edbc.<\/p>\n<h2><b>S\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa RANK, RANK.EQ v\u00e0 RANK.AVG<\/b><\/h2>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>RANK (c\u0169)<\/b><span style=\"font-weight: 400;\">: X\u1ebfp h\u1ea1ng gi\u1ed1ng RANK.EQ, nh\u01b0ng l\u1ed7i th\u1eddi t\u1eeb Excel 2013.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>RANK.EQ<\/b><span style=\"font-weight: 400;\">: G\u00e1n c\u00f9ng h\u1ea1ng cho gi\u00e1 tr\u1ecb tr\u00f9ng (v\u00ed d\u1ee5: 2 gi\u00e1 tr\u1ecb cao nh\u1ea5t \u0111\u1ec1u h\u1ea1ng 1, h\u1ea1ng sau l\u00e0 3).<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>RANK.AVG<\/b><span style=\"font-weight: 400;\">: T\u00ednh trung b\u00ecnh h\u1ea1ng cho tr\u00f9ng l\u1eb7p (v\u00ed d\u1ee5: 2 gi\u00e1 tr\u1ecb h\u1ea1ng 1.5).<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>V\u00ed d\u1ee5:<\/b><span style=\"font-weight: 400;\"> D\u1eef li\u1ec7u [90, 90, 80] \u2192 RANK.EQ: 1,1,3 | RANK.AVG: 1.5,1.5,3.<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng RANK.EQ cho x\u1ebfp h\u1ea1ng thi \u0111\u1ea5u, RANK.AVG cho \u0111\u00e1nh gi\u00e1 trung b\u00ecnh.<\/span><\/li>\n<\/ul>\n<h2>C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m Rank trong ph\u1ea7n m\u1ec1m Excel<\/h2>\n<p><strong>H\u00e0m Rank trong Excel<\/strong> \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh x\u1ebfp h\u1ea1ng c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 trong m\u1ed9t t\u1eadp h\u1ee3p d\u1eef li\u1ec7u. B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng bi\u1ebft gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 c\u1ee7a m\u00ecnh x\u1ebfp h\u1ea1ng th\u1ee9 bao nhi\u00eau trong danh s\u00e1ch, d\u1ef1a tr\u00ean m\u1ee9c \u0111\u1ed9 t\u01b0\u01a1ng quan v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c.<\/p>\n<figure id=\"attachment_257006\" aria-describedby=\"caption-attachment-257006\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"wp-image-257006 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-1.jpg\" alt=\"ham-rank-trong-excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-257006\" class=\"wp-caption-text\"><em>H\u00ecnh \u1ea3nh minh h\u1ecda s\u1eed d\u1ee5ng h\u00e0m rank trong ph\u1ea7n m\u1ec1m Excel<\/em><\/figcaption><\/figure>\n<p>C\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n v\u00e0 c\u00fa ph\u00e1p s\u1eed d\u1ee5ng: <strong>RANK(number, ref, [order])<\/strong><\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li><strong>number<\/strong>: L\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n x\u00e1c \u0111\u1ecbnh x\u1ebfp h\u1ea1ng. Gi\u00e1 tr\u1ecb n\u00e0y c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t s\u1ed1 c\u1ee5 th\u1ec3 ho\u1eb7c m\u1ed9t \u00f4 ch\u1ee9a s\u1ed1.<\/li>\n<li><strong>ref<\/strong>: L\u00e0 ph\u1ea1m vi tham chi\u1ebfu ch\u1ee9a danh s\u00e1ch s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n x\u1ebfp h\u1ea1ng number trong \u0111\u00f3. C\u1ea7n l\u01b0u \u00fd r\u1eb1ng, \u0111\u1ec3 h\u00e0m ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c, ph\u1ea1m vi tham chi\u1ebfu n\u00e0y n\u00ean ch\u1ee9a gi\u00e1 tr\u1ecb number.<\/li>\n<li><strong>[order]<\/strong>: L\u00e0 m\u1ed9t tham s\u1ed1 t\u00f9y ch\u1ecdn. N\u1ebfu b\u1ecf qua ho\u1eb7c nh\u1eadp 0, Excel s\u1ebd x\u1ebfp h\u1ea1ng number t\u1eeb cao \u0111\u1ebfn th\u1ea5p. N\u1ebfu nh\u1eadp 1, Excel s\u1ebd x\u1ebfp h\u1ea1ng t\u1eeb th\u1ea5p \u0111\u1ebfn cao.<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady, th\u00f4ng qua vi\u1ec7c hi\u1ec3u r\u00f5 c\u00e1ch ho\u1ea1t \u0111\u1ed9ng v\u00e0 c\u00fa ph\u00e1p c\u1ee7a h\u00e0m Rank, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng linh ho\u1ea1t trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng kh\u00e1c nhau khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u trong ph\u1ea7n m\u1ec1m Excel.<\/p>\n<h2>H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Rank trong Excel chi ti\u1ebft nh\u1ea5t<\/h2>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c b\u01b0\u1edbc chi ti\u1ebft \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n h\u00e0m Rank m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3:<\/p>\n<p><strong>B\u01b0\u1edbc 1: Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u<\/strong><\/p>\n<p>Tr\u01b0\u1edbc khi s\u1eed d\u1ee5ng h\u00e0m Rank, \u0111\u1ea3m b\u1ea3o d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n \u0111\u00e3 \u0111\u01b0\u1ee3c nh\u1eadp m\u1ed9t c\u00e1ch r\u00f5 r\u00e0ng v\u00e0 \u0111\u00fang \u0111\u1eafn trong m\u1ed9t c\u1ed9t ho\u1eb7c h\u00e0ng c\u1ee7a b\u1ea3ng t\u00ednh Excel. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng thao t\u00e1c v\u00e0 tr\u00e1nh c\u00e1c l\u1ed7i kh\u00f4ng mong mu\u1ed1n.<\/p>\n<p>V\u00ed d\u1ee5, b\u1ea1n c\u00f3 m\u1ed9t d\u00e3y s\u1ed1 v\u00e0 mu\u1ed1n bi\u1ebft x\u1ebfp h\u1ea1ng c\u1ee7a t\u1eebng s\u1ed1.<\/p>\n<p><strong>B\u01b0\u1edbc 2: M\u1edf h\u00e0m v\u00e0 ch\u1ecdn d\u1eef li\u1ec7u c\u1ea7n x\u1ebfp h\u1ea1ng<\/strong><\/p>\n<ol>\n<li>Di chuy\u1ec3n \u0111\u1ebfn \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 x\u1ebfp h\u1ea1ng.<\/li>\n<li>Nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng \u201cfx\u201d (H\u00e0m) tr\u00ean thanh c\u00f4ng c\u1ee5.<\/li>\n<li>T\u00ecm v\u00e0 ch\u1ecdn h\u00e0m &#8220;RANK&#8221; t\u1eeb danh s\u00e1ch h\u00e0m.<\/li>\n<\/ol>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-256999 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung.jpg\" alt=\"ham-rank-trong-excel-cach-su-dung\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li>Trong \u00f4 &#8220;Number&#8221;, ch\u1ecdn gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n x\u1ebfp h\u1ea1ng.<\/li>\n<li>Trong \u00f4 &#8220;Ref&#8221;, ch\u1ecdn to\u00e0n b\u1ed9 ph\u1ea1m vi d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n so s\u00e1nh.<\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-256998 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-1.jpg\" alt=\"ham-rank-trong-excel-cach-su-dung-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>B\u01b0\u1edbc 3: Ch\u1ecdn c\u00e1ch s\u1eafp x\u1ebfp (t\u0103ng d\u1ea7n hay gi\u1ea3m d\u1ea7n)<\/strong><\/p>\n<ol>\n<li>Trong \u00f4 &#8220;Order&#8221;, nh\u1eadp &#8220;0&#8221; n\u1ebfu b\u1ea1n mu\u1ed1n x\u1ebfp h\u1ea1ng t\u1eeb cao \u0111\u1ebfn th\u1ea5p (v\u00ed d\u1ee5: \u0111i\u1ec3m s\u1ed1 t\u1eeb cao \u0111\u1ebfn th\u1ea5p).<\/li>\n<li>N\u1ebfu mu\u1ed1n x\u1ebfp h\u1ea1ng t\u1eeb th\u1ea5p \u0111\u1ebfn cao, nh\u1eadp &#8220;1&#8221;.<\/li>\n<\/ol>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-256996 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-2.jpg\" alt=\"ham-rank-trong-excel-cach-su-dung-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>B\u01b0\u1edbc 4: X\u00e1c nh\u1eadn v\u00e0 xem k\u1ebft qu\u1ea3<\/strong><\/p>\n<ol>\n<li>Sau khi \u0111\u00e3 \u0111i\u1ec1n \u0111\u1ee7 th\u00f4ng tin v\u00e0o h\u00e0m, nh\u1ea5n OK.<\/li>\n<li>K\u1ebft qu\u1ea3 x\u1ebfp h\u1ea1ng s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb ngay t\u1ea1i \u00f4 b\u1ea1n \u0111\u00e3 ch\u1ecdn.<\/li>\n<\/ol>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-256997 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-3.jpg\" alt=\"ham-rank-trong-excel-cach-su-dung-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-cach-su-dung-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>\u0110\u1ec3 \u00e1p d\u1ee5ng h\u00e0m Rank cho to\u00e0n b\u1ed9 danh s\u00e1ch, b\u1ea1n ch\u1ec9 c\u1ea7n k\u00e9o g\u00f3c d\u01b0\u1edbi c\u00f9ng b\u00ean ph\u1ea3i c\u1ee7a \u00f4 ch\u1ee9a k\u1ebft qu\u1ea3 \u0111\u1ea7u ti\u00ean xu\u1ed1ng d\u01b0\u1edbi.<\/p>\n<h2>V\u00ed d\u1ee5 th\u1ef1c t\u1ebf v\u00e0 \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m Rank trong Excel<\/h2>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 th\u1ef1c t\u1ebf gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m Rank trong ph\u1ea7n m\u1ec1m Excel m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 quan t\u00e2m.<\/p>\n<h3>X\u1ebfp h\u1ea1ng t\u1eeb cao \u0111\u1ebfn th\u1ea5p<\/h3>\n<p>B\u1ea1n \u0111ang mu\u1ed1n s\u1eafp x\u1ebfp th\u1ee9 h\u1ea1ng d\u1ec5 d\u00e0ng trong Excel? H\u00e3y theo d\u00f5i b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n sau \u0111\u00e2y.<\/p>\n<p>B\u01b0\u1edbc 1: M\u1edf \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t b\u1ea1n mu\u1ed1n x\u1ebfp h\u1ea1ng. G\u00f5 c\u00f4ng th\u1ee9c =RANK(F2,$F$2:$F$5,0).<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-256995 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du.jpg\" alt=\"ham-rank-trong-excel-vi-du\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>B\u01b0\u1edbc 2: Nh\u1ea5n Enter. Ngay l\u1eadp t\u1ee9c, Excel s\u1ebd tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3. V\u00ed d\u1ee5: N\u1ebfu b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c s\u1ed1 &#8220;3&#8221;, \u0111i\u1ec1u \u0111\u00f3 c\u00f3 ngh\u0129a l\u00e0 &#8220;Tr\u1ea7n Minh Anh&#8221; \u0111\u1ee9ng th\u1ee9 h\u1ea1ng 3 trong danh s\u00e1ch c\u1ee7a b\u1ea1n.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-256994 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-1.jpg\" alt=\"ham-rank-trong-excel-vi-du-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>B\u01b0\u1edbc 3: \u0110\u1ec3 \u00e1p d\u1ee5ng cho to\u00e0n b\u1ed9 danh s\u00e1ch, di chuy\u1ec3n con tr\u1ecf chu\u1ed9t \u0111\u1ebfn g\u00f3c d\u01b0\u1edbi c\u00f9ng b\u00ean ph\u1ea3i c\u1ee7a \u00f4 k\u1ebft qu\u1ea3. Khi b\u1ea1n th\u1ea5y d\u1ea5u c\u1ed9ng, k\u00e9o n\u00f3 xu\u1ed1ng cho \u0111\u1ebfn khi k\u1ebft th\u00fac danh s\u00e1ch.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-256993 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-2.jpg\" alt=\"ham-rank-trong-excel-vi-du-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>B\u01b0\u1edbc 4: \u0110\u00e1nh gi\u00e1 k\u1ebft qu\u1ea3. Danh s\u00e1ch th\u1ee9 h\u1ea1ng khi s\u1eed d\u1ee5ng <strong>h\u00e0m Rank trong Excel<\/strong> \u0111\u1ec3 s\u1eafp x\u1ebfp s\u1ebd hi\u1ec3n th\u1ecb m\u1ed9t c\u00e1ch tr\u1ef1c quan v\u00e0 ngay l\u1eadp t\u1ee9c.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-256992 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-3.jpg\" alt=\"ham-rank-trong-excel-vi-du-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>L\u01b0u \u00fd<\/strong>: Trong tr\u01b0\u1eddng h\u1ee3p c\u00f3 c\u00e1c s\u1ed1 \u0111i\u1ec3m tr\u00f9ng nhau, Excel s\u1ebd g\u00e1n c\u00f9ng m\u1ed9t th\u1ee9 h\u1ea1ng cho ch\u00fang. V\u00ed d\u1ee5, n\u1ebfu hai h\u1ecdc sinh \u0111\u1ec1u c\u00f3 s\u1ed1 \u0111i\u1ec3m 8.666667, c\u1ea3 hai s\u1ebd \u0111\u1ee9ng h\u1ea1ng 1. \u0110i\u1ec1u n\u00e0y khi\u1ebfn cho h\u1ecdc sinh k\u1ebf ti\u1ebfp v\u1edbi \u0111i\u1ec3m s\u1ed1 8 ph\u1ea3i nh\u01b0\u1eddng th\u1ee9 h\u1ea1ng v\u00e0 chuy\u1ec3n xu\u1ed1ng h\u1ea1ng 4.<\/p>\n<h3>X\u1ebfp h\u1ea1ng th\u1ea5p \u0111\u1ebfn cao<\/h3>\n<p>B\u1ea1n \u0111ang mu\u1ed1n bi\u1ebft ai c\u00f3 s\u1ed1 \u0111i\u1ec3m th\u1ea5p nh\u1ea5t trong danh s\u00e1ch v\u00e0 ti\u1ebfp t\u1ee5c x\u1ebfp h\u1ea1ng l\u00ean t\u1eeb \u0111\u00f3? \u0110\u00e2y l\u00e0 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 l\u00e0m \u0111i\u1ec1u \u0111\u00f3 trong Excel.<\/p>\n<p>B\u01b0\u1edbc 1: Ch\u1ecdn \u00f4 b\u1ea1n mu\u1ed1n b\u1eaft \u0111\u1ea7u x\u1ebfp h\u1ea1ng. Nh\u1eadp c\u00f4ng th\u1ee9c =RANK(B2,$B$2:$B$5,1). M\u1ee5c n\u00e0y s\u1ebd gi\u00fap b\u1ea1n x\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u t\u1eeb th\u1ea5p \u0111\u1ebfn cao.<\/p>\n<p>B\u01b0\u1edbc 2: Sau khi nh\u1eadp, nh\u1ea5n Enter. L\u1eadp t\u1ee9c, k\u1ebft qu\u1ea3 s\u1ebd xu\u1ea5t hi\u1ec7n tr\u00ean b\u1ea3ng c\u1ee7a b\u1ea1n. V\u00ed d\u1ee5: &#8220;Tr\u1ea7n Minh Anh&#8221; v\u1edbi s\u1ed1 \u0111i\u1ec3m th\u1ea5p h\u01a1n so v\u1edbi nh\u1eefng ng\u01b0\u1eddi kh\u00e1c s\u1ebd \u0111\u1ee9ng h\u1ea1ng 4.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-256991 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-4.jpg\" alt=\"ham-rank-trong-excel-vi-du-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>B\u01b0\u1edbc 3: \u0110\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 danh s\u00e1ch, di chuy\u1ec3n con tr\u1ecf chu\u1ed9t \u0111\u1ebfn g\u00f3c d\u01b0\u1edbi c\u00f9ng b\u00ean ph\u1ea3i c\u1ee7a \u00f4 ch\u1ee9a k\u1ebft qu\u1ea3. M\u1ed9t d\u1ea5u c\u1ed9ng s\u1ebd xu\u1ea5t hi\u1ec7n, ch\u1ec9 c\u1ea7n k\u00e9o n\u00f3 xu\u1ed1ng cho \u0111\u1ebfn khi k\u1ebft th\u00fac danh s\u00e1ch.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-256990 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-5.jpg\" alt=\"ham-rank-trong-excel-vi-du-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-vi-du-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>L\u01b0u \u00fd<\/strong>: Khi b\u1ea1n x\u1ebfp h\u1ea1ng t\u1eeb th\u1ea5p \u0111\u1ebfn cao b\u1eb1ng <strong>h\u00e0m Rank trong Excel<\/strong>, \u0111i\u1ec3m s\u1ed1 cao s\u1ebd c\u00f3 th\u1ee9 h\u1ea1ng th\u1ea5p v\u00e0 ng\u01b0\u1ee3c l\u1ea1i. Nh\u01b0 v\u1eady, b\u1ea1n s\u1ebd d\u1ec5 d\u00e0ng nh\u1eadn bi\u1ebft \u0111\u01b0\u1ee3c ai c\u00f3 \u0111i\u1ec3m s\u1ed1 th\u1ea5p nh\u1ea5t v\u00e0 c\u1ea7n ph\u1ea3i c\u1ea3i thi\u1ec7n h\u01a1n trong danh s\u00e1ch.<\/p>\n<h2>Nh\u1eefng l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Rank trong ph\u1ea7n m\u1ec1m Excel<\/h2>\n<p>Khi s\u1eed d\u1ee5ng h\u00e0m Rank, vi\u1ec7c hi\u1ec3u r\u00f5 m\u1ed9t s\u1ed1 n\u00e9t \u0111\u1eb7c tr\u01b0ng v\u00e0 l\u01b0u \u00fd s\u1ebd gi\u00fap b\u1ea1n tr\u00e1nh \u0111\u01b0\u1ee3c nhi\u1ec1u sai s\u00f3t v\u00e0 t\u1eadn d\u1ee5ng t\u1ed1i \u0111a kh\u1ea3 n\u0103ng c\u1ee7a h\u00e0m n\u00e0y. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 \u0111i\u1ec3m quan tr\u1ecdng m\u00e0 ng\u01b0\u1eddi s\u1eed d\u1ee5ng n\u00ean bi\u1ebft.<\/p>\n<p><strong>C\u00e1ch x\u1eed l\u00fd khi c\u00f3 d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p<\/strong><\/p>\n<p>Khi hai gi\u00e1 tr\u1ecb ho\u1eb7c nhi\u1ec1u h\u01a1n tr\u00f9ng nhau, h\u00e0m Rank s\u1ebd cho c\u00f9ng m\u1ed9t x\u1ebfp h\u1ea1ng cho t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00f3. V\u00ed d\u1ee5, n\u1ebfu c\u00f3 ba s\u1ed1 90 trong d\u00e3y s\u1ed1, t\u1ea5t c\u1ea3 ba s\u1ed1 \u0111\u00f3 s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c x\u1ebfp h\u1ea1ng 1 (n\u1ebfu b\u1ea1n x\u1ebfp h\u1ea1ng t\u1eeb cao \u0111\u1ebfn th\u1ea5p).<\/p>\n<p>Khi c\u00f3 d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p, x\u1ebfp h\u1ea1ng ti\u1ebfp theo s\u1ebd b\u1ecf qua m\u1ed9t s\u1ed1 h\u1ea1ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 gi\u00e1 tr\u1ecb tr\u00f9ng nhau. V\u00ed d\u1ee5: N\u1ebfu ba s\u1ed1 90 \u0111\u1ec1u x\u1ebfp h\u1ea1ng 1, s\u1ed1 ti\u1ebfp theo ch\u1ec9 c\u00f3 th\u1ec3 nh\u1eadn x\u1ebfp h\u1ea1ng 4.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-luu-y.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-luu-y-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-luu-y-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-256988 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-luu-y.jpg\" alt=\"ham-rank-trong-excel-luu-y\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-luu-y.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-luu-y-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-luu-y-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>Nh\u1eefng tr\u01b0\u1eddng h\u1ee3p th\u01b0\u1eddng g\u1eb7p m\u00e0 h\u00e0m Rank trong Excel kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng nh\u01b0 mong \u0111\u1ee3i<\/strong><\/p>\n<p><strong>D\u1eef li\u1ec7u kh\u00f4ng \u0111\u1ed3ng nh\u1ea5t:<\/strong> \u0110\u1ec3 h\u00e0m Rank ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c, t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u trong d\u00e3y c\u1ea7n ph\u1ea3i c\u00f3 c\u00f9ng ki\u1ec3u (s\u1ed1 ho\u1eb7c v\u0103n b\u1ea3n). N\u1ebfu d\u00e3y s\u1ed1 c\u1ee7a b\u1ea1n c\u00f3 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng h\u1ee3p l\u1ec7 nh\u01b0 v\u0103n b\u1ea3n ho\u1eb7c gi\u00e1 tr\u1ecb tr\u1ed1ng, h\u00e0m Rank c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 sai.<\/p>\n<p><strong>S\u1eafp x\u1ebfp d\u1eef li\u1ec7u:<\/strong> \u0110\u00f4i khi, ng\u01b0\u1eddi d\u00f9ng qu\u00ean x\u00e1c \u0111\u1ecbnh tham s\u1ed1 s\u1eafp x\u1ebfp (t\u0103ng d\u1ea7n hay gi\u1ea3m d\u1ea7n). \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 d\u1eabn \u0111\u1ebfn vi\u1ec7c x\u1ebfp h\u1ea1ng kh\u00f4ng nh\u01b0 mong \u0111\u1ee3i.<\/p>\n<p><strong>D\u00f9ng h\u00e0m RANK.EQ v\u00e0 RANK.AVG:<\/strong> Trong c\u00e1c phi\u00ean b\u1ea3n Excel m\u1edbi, h\u00e0m Rank \u0111\u00e3 \u0111\u01b0\u1ee3c thay th\u1ebf b\u1edfi hai h\u00e0m RANK.EQ v\u00e0 RANK.AVG. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 g\u00e2y nh\u1ea7m l\u1eabn cho ng\u01b0\u1eddi m\u1edbi s\u1eed d\u1ee5ng.<\/p>\n<h2>H\u00e0m Rank li\u00ean quan v\u00e0 m\u1edf r\u1ed9ng trong Excel<\/h2>\n<p>Trong qu\u00e1 tr\u00ecnh ph\u00e1t tri\u1ec3n v\u00e0 c\u1ea3i ti\u1ebfn, Microsoft Excel \u0111\u00e3 gi\u1edbi thi\u1ec7u m\u1ed9t s\u1ed1 h\u00e0m li\u00ean quan \u0111\u1ebfn vi\u1ec7c x\u1ebfp h\u1ea1ng. Hai trong s\u1ed1 nh\u1eefng h\u00e0m \u0111\u00f3 l\u00e0 RANK.AVG v\u00e0 RANK.EQ. M\u1ed7i <strong>h\u00e0m Rank trong Excel<\/strong> c\u00f3 nh\u1eefng \u0111\u1eb7c \u0111i\u1ec3m v\u00e0 \u1ee9ng d\u1ee5ng ri\u00eang bi\u1ec7t, v\u00e0 vi\u1ec7c hi\u1ec3u r\u00f5 s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa ch\u00fang s\u1ebd gi\u00fap b\u1ea1n s\u1eed d\u1ee5ng ch\u00fang m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/p>\n<h3>Gi\u1edbi thi\u1ec7u h\u00e0m RANK.AVG v\u00e0 RANK.EQ<\/h3>\n<p><strong>H\u00e0m RANK.AVG<\/strong>: H\u00e0m n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 x\u1ebfp h\u1ea1ng trung b\u00ecnh c\u1ee7a m\u1ed9t s\u1ed1 trong m\u1ed9t d\u00e3y s\u1ed1. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi c\u00f3 nhi\u1ec1u gi\u00e1 tr\u1ecb gi\u1ed1ng nhau trong d\u00e3y. Thay v\u00ec g\u00e1n c\u00f9ng m\u1ed9t x\u1ebfp h\u1ea1ng cho t\u1ea5t c\u1ea3, h\u00e0m RANK.AVG s\u1ebd t\u00ednh to\u00e1n x\u1ebfp h\u1ea1ng trung b\u00ecnh.<\/p>\n<p>V\u00ed d\u1ee5: N\u1ebfu trong m\u1ed9t d\u00e3y c\u00f3 ba gi\u00e1 tr\u1ecb 90, thay v\u00ec g\u00e1n x\u1ebfp h\u1ea1ng 1 cho t\u1ea5t c\u1ea3, h\u00e0m RANK.AVG s\u1ebd g\u00e1n x\u1ebfp h\u1ea1ng 2 cho t\u1ea5t c\u1ea3 (t\u1ee9c l\u00e0 (1+2+3)\/3).<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-so-sanh.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-so-sanh-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-so-sanh-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-256985 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-so-sanh.jpg\" alt=\"ham-rank-trong-excel-so-sanh\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-so-sanh.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-so-sanh-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-so-sanh-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>H\u00e0m RANK.EQ<\/strong>: \u0110\u00e2y l\u00e0 phi\u00ean b\u1ea3n c\u1ea3i ti\u1ebfn c\u1ee7a h\u00e0m Rank truy\u1ec1n th\u1ed1ng. N\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 x\u1ebfp h\u1ea1ng c\u1ee7a m\u1ed9t s\u1ed1 trong m\u1ed9t d\u00e3y s\u1ed1. Khi c\u00f3 nhi\u1ec1u gi\u00e1 tr\u1ecb gi\u1ed1ng nhau, h\u00e0m RANK.EQ s\u1ebd g\u00e1n c\u00f9ng m\u1ed9t x\u1ebfp h\u1ea1ng cho t\u1ea5t c\u1ea3.<\/p>\n<p>V\u00ed d\u1ee5: S\u1eed d\u1ee5ng d\u00e3y s\u1ed1 tr\u00ean v\u1edbi ba gi\u00e1 tr\u1ecb 90, h\u00e0m RANK.EQ s\u1ebd g\u00e1n x\u1ebfp h\u1ea1ng 1 cho t\u1ea5t c\u1ea3 ba gi\u00e1 tr\u1ecb.<\/p>\n<h3>So s\u00e1nh s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa h\u00e0m Rank trong Excel<\/h3>\n<p><strong>X\u1eed l\u00fd gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p<\/strong>: Nh\u01b0 \u0111\u00e3 m\u00f4 t\u1ea3 \u1edf tr\u00ean, khi g\u1eb7p gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p, RANK.AVG s\u1ebd t\u00ednh to\u00e1n x\u1ebfp h\u1ea1ng trung b\u00ecnh, trong khi RANK.EQ s\u1ebd g\u00e1n c\u00f9ng m\u1ed9t x\u1ebfp h\u1ea1ng cho t\u1ea5t c\u1ea3 gi\u00e1 tr\u1ecb \u0111\u00f3.<\/p>\n<p><strong>\u1ee8ng d\u1ee5ng<\/strong>: Trong nh\u1eefng tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n x\u1ebfp h\u1ea1ng d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb \u0111\u01a1n gi\u1ea3n v\u00e0 tr\u1ef1c ti\u1ebfp, RANK.EQ s\u1ebd l\u00e0 l\u1ef1a ch\u1ecdn t\u1ed1t. Ng\u01b0\u1ee3c l\u1ea1i, khi b\u1ea1n mu\u1ed1n ph\u1ea3n \u00e1nh m\u1ed9t c\u00e1i nh\u00ecn c\u00f4ng b\u1eb1ng v\u00e0 trung th\u1ef1c h\u01a1n v\u1edbi nh\u1eefng gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p, RANK.AVG s\u1ebd \u0111\u01b0\u1ee3c \u01b0u ti\u00ean.<\/p>\n<p><strong>Phi\u00ean b\u1ea3n Excel<\/strong>: H\u00e0m RANK.EQ v\u00e0 RANK.AVG xu\u1ea5t hi\u1ec7n t\u1eeb phi\u00ean b\u1ea3n Excel 2010 tr\u1edf \u0111i, gi\u00fap ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u00eam l\u1ef1a ch\u1ecdn trong vi\u1ec7c x\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u.<\/p>\n<p>\u0110\u1ec3 t\u1ed1i \u01b0u hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c v\u00e0 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c khi s\u1eed d\u1ee5ng Excel, vi\u1ec7c hi\u1ec3u r\u00f5 v\u00e0 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng ph\u00f9 h\u1ee3p c\u00e1c h\u00e0m x\u1ebfp h\u1ea1ng l\u00e0 v\u00f4 c\u00f9ng quan tr\u1ecdng.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-cau-hoi.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-cau-hoi-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/ham-rank-trong-excel-cau-hoi-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-256989 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-cau-hoi.jpg\" alt=\"ham-rank-trong-excel-cau-hoi\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-cau-hoi.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-cau-hoi-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-cau-hoi-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2>C\u00e2u h\u1ecfi li\u00ean quan<\/h2>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00e2u h\u1ecfi li\u00ean quan \u0111\u1ebfn h\u00e0m Rank trong ph\u1ea7n m\u1ec1m Excel m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 quan t\u00e2m:<\/p>\n<p><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Rank trong Excel?<\/strong><\/p>\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Rank, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c =RANK(number,ref,[order]) v\u00e0o m\u1ed9t \u00f4 tr\u1ed1ng. Trong \u0111\u00f3:<\/p>\n<ul>\n<li>&#8220;number&#8221; l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n x\u1ebfp h\u1ea1ng.<\/li>\n<li>&#8220;ref&#8221; l\u00e0 danh s\u00e1ch gi\u00e1 tr\u1ecb c\u1ea7n so s\u00e1nh.<\/li>\n<li>&#8220;[order]&#8221; l\u00e0 t\u00f9y ch\u1ecdn x\u1ebfp h\u1ea1ng t\u0103ng d\u1ea7n (\u0111\u1eb7t l\u00e0 1) ho\u1eb7c gi\u1ea3m d\u1ea7n (\u0111\u1eb7t l\u00e0 0 ho\u1eb7c b\u1ecf tr\u1ed1ng).<\/li>\n<\/ul>\n<p><strong>Khi n\u00e0o n\u00ean s\u1eed d\u1ee5ng RANK.AVG so v\u1edbi RANK.EQ?<\/strong><\/p>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n x\u1ebfp h\u1ea1ng c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p m\u00e0 kh\u00f4ng b\u1ecf s\u00f3t th\u1ee9 h\u1ea1ng n\u00e0o (v\u00ed d\u1ee5, x\u1ebfp h\u1ea1ng 1, 2, 2, 4 thay v\u00ec 1, 2, 2, 3), h\u00e3y s\u1eed d\u1ee5ng RANK.EQ. N\u1ebfu b\u1ea1n mu\u1ed1n x\u1ebfp h\u1ea1ng trung b\u00ecnh cho c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p (v\u00ed d\u1ee5, x\u1ebfp h\u1ea1ng 1, 2.5, 2.5, 4), h\u00e3y s\u1eed d\u1ee5ng RANK.AVG.<\/p>\n<p><strong>L\u00e0m sao \u0111\u1ec3 x\u1eed l\u00fd tr\u01b0\u1eddng h\u1ee3p c\u00f3 d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p khi x\u1ebfp h\u1ea1ng?<\/strong><\/p>\n<p>N\u1ebfu b\u1ea1n g\u1eb7p ph\u1ea3i d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p v\u00e0 mu\u1ed1n m\u1ed7i gi\u00e1 tr\u1ecb \u0111\u1ec1u c\u00f3 m\u1ed9t th\u1ee9 h\u1ea1ng ri\u00eang bi\u1ec7t, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 RANK.EQ ho\u1eb7c RANK.AVG, t\u00f9y thu\u1ed9c v\u00e0o y\u00eau c\u1ea7u c\u1ee7a b\u1ea1n.<\/p>\n<h2>T\u1ea1m k\u1ebft<\/h2>\n<p>Hi v\u1ecdng b\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap b\u1ea1n bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m Rank trong Excel<\/strong> m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t. T\u1ea5t nhi\u00ean, b\u1ea1n s\u1ebd c\u1ea7n th\u1ef1c h\u00e0nh nhi\u1ec1u l\u1ea7n \u0111\u1ec3 l\u00e0m quen c\u0169ng nh\u01b0 \u00e1p d\u1ee5ng h\u00e0m Rank hi\u1ec7u qu\u1ea3 h\u01a1n trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p kh\u00e1c nhau. \u0110\u1eebng qu\u00ean truy c\u1eadp v\u00e0o trang tin nhanh c\u1ee7a Ho\u00e0ng H\u00e0 Mobile \u0111\u1ec3 tham kh\u1ea3o th\u00eam c\u00e1c m\u1eb9o v\u00e0 th\u1ee7 thu\u1eadt kh\u00e1c li\u00ean quan \u0111\u1ebfn Excel nh\u00e9.<\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/\">C\u00e1c th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n nh\u1ea5t b\u1ea1n c\u1ea7n n\u1eafm<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-ve-bieu-do-tron-trong-excel-don-gian-de-hieu\/\">C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 tr\u00f2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 hi\u1ec3u<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m Rank trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap ng\u01b0\u1eddi d\u00f9ng ph\u00e2n lo\u1ea1i v\u00e0 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3. Trong b\u1ed1i c\u1ea3nh d\u1eef li\u1ec7u \u0111\u00f3ng vai tr\u00f2 quan tr\u1ecdng trong vi\u1ec7c \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh, vi\u1ec7c hi\u1ec3u r\u00f5 v\u00e0 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Rank l\u00e0 \u0111i\u1ec1u [&hellip;]<\/p>\n","protected":false},"author":83,"featured_media":256984,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-256983","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u00e0m RANK trong Excel: C\u00e1ch s\u1eed d\u1ee5ng x\u1ebfp h\u1ea1ng t\u1eeb cao\/th\u1ea5p \u0111\u1ebfn cao \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft h\u00e0m RANK trong Excel: X\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u t\u1eeb cao xu\u1ed1ng th\u1ea5p\/th\u1ea5p \u0111\u1ebfn cao, v\u00ed d\u1ee5 th\u1ef1c t\u1ebf + RANK.AVG\/EQ. \u00c1p d\u1ee5ng ngay \u0111\u1ec3 t\u1ed1i \u01b0u b\u00e1o c\u00e1o!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m RANK trong Excel: H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng chi ti\u1ebft \u0111\u1ec3 x\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u\" \/>\n<meta property=\"og:description\" content=\"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft h\u00e0m RANK trong Excel: X\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u t\u1eeb cao xu\u1ed1ng th\u1ea5p\/th\u1ea5p \u0111\u1ebfn cao, v\u00ed d\u1ee5 th\u1ef1c t\u1ebf + RANK.AVG\/EQ. \u00c1p d\u1ee5ng ngay \u0111\u1ec3 t\u1ed1i \u01b0u b\u00e1o c\u00e1o!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-09-11T14:19:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-25T15:20:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-thumb.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Do Tuyet Nhi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Do Tuyet Nhi\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"18 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/\"},\"author\":{\"name\":\"Do Tuyet Nhi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bba0f0fb7a9ee063d98abf6557ccdaee\"},\"headline\":\"H\u00e0m RANK trong Excel: H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng chi ti\u1ebft \u0111\u1ec3 x\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u\",\"datePublished\":\"2023-09-11T14:19:56+00:00\",\"dateModified\":\"2025-12-25T15:20:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/\"},\"wordCount\":3964,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-thumb.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/\",\"name\":\"H\u00e0m RANK trong Excel: C\u00e1ch s\u1eed d\u1ee5ng x\u1ebfp h\u1ea1ng t\u1eeb cao\/th\u1ea5p \u0111\u1ebfn cao \u0111\u01a1n gi\u1ea3n nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-thumb.jpg\",\"datePublished\":\"2023-09-11T14:19:56+00:00\",\"dateModified\":\"2025-12-25T15:20:36+00:00\",\"description\":\"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft h\u00e0m RANK trong Excel: X\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u t\u1eeb cao xu\u1ed1ng th\u1ea5p\/th\u1ea5p \u0111\u1ebfn cao, v\u00ed d\u1ee5 th\u1ef1c t\u1ebf + RANK.AVG\/EQ. \u00c1p d\u1ee5ng ngay \u0111\u1ec3 t\u1ed1i \u01b0u b\u00e1o c\u00e1o!\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-thumb.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-thumb.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-rank-trong-excel-thumb\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m RANK trong Excel: H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng chi ti\u1ebft \u0111\u1ec3 x\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bba0f0fb7a9ee063d98abf6557ccdaee\",\"name\":\"Do Tuyet Nhi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/12dd398f8abe479231672d9ef7fb0a0c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/12dd398f8abe479231672d9ef7fb0a0c?s=96&d=mm&r=g\",\"caption\":\"Do Tuyet Nhi\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/do-tuyet-nhi\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m RANK trong Excel: C\u00e1ch s\u1eed d\u1ee5ng x\u1ebfp h\u1ea1ng t\u1eeb cao\/th\u1ea5p \u0111\u1ebfn cao \u0111\u01a1n gi\u1ea3n nh\u1ea5t","description":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft h\u00e0m RANK trong Excel: X\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u t\u1eeb cao xu\u1ed1ng th\u1ea5p\/th\u1ea5p \u0111\u1ebfn cao, v\u00ed d\u1ee5 th\u1ef1c t\u1ebf + RANK.AVG\/EQ. \u00c1p d\u1ee5ng ngay \u0111\u1ec3 t\u1ed1i \u01b0u b\u00e1o c\u00e1o!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m RANK trong Excel: H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng chi ti\u1ebft \u0111\u1ec3 x\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u","og_description":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft h\u00e0m RANK trong Excel: X\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u t\u1eeb cao xu\u1ed1ng th\u1ea5p\/th\u1ea5p \u0111\u1ebfn cao, v\u00ed d\u1ee5 th\u1ef1c t\u1ebf + RANK.AVG\/EQ. \u00c1p d\u1ee5ng ngay \u0111\u1ec3 t\u1ed1i \u01b0u b\u00e1o c\u00e1o!","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-09-11T14:19:56+00:00","article_modified_time":"2025-12-25T15:20:36+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-thumb.jpg","type":"image\/jpeg"}],"author":"Do Tuyet Nhi","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Do Tuyet Nhi","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"18 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/"},"author":{"name":"Do Tuyet Nhi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bba0f0fb7a9ee063d98abf6557ccdaee"},"headline":"H\u00e0m RANK trong Excel: H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng chi ti\u1ebft \u0111\u1ec3 x\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u","datePublished":"2023-09-11T14:19:56+00:00","dateModified":"2025-12-25T15:20:36+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/"},"wordCount":3964,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-thumb.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/","name":"H\u00e0m RANK trong Excel: C\u00e1ch s\u1eed d\u1ee5ng x\u1ebfp h\u1ea1ng t\u1eeb cao\/th\u1ea5p \u0111\u1ebfn cao \u0111\u01a1n gi\u1ea3n nh\u1ea5t","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-thumb.jpg","datePublished":"2023-09-11T14:19:56+00:00","dateModified":"2025-12-25T15:20:36+00:00","description":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft h\u00e0m RANK trong Excel: X\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u t\u1eeb cao xu\u1ed1ng th\u1ea5p\/th\u1ea5p \u0111\u1ebfn cao, v\u00ed d\u1ee5 th\u1ef1c t\u1ebf + RANK.AVG\/EQ. \u00c1p d\u1ee5ng ngay \u0111\u1ec3 t\u1ed1i \u01b0u b\u00e1o c\u00e1o!","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-thumb.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/ham-rank-trong-excel-thumb.jpg","width":1200,"height":628,"caption":"ham-rank-trong-excel-thumb"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m RANK trong Excel: H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng chi ti\u1ebft \u0111\u1ec3 x\u1ebfp h\u1ea1ng d\u1eef li\u1ec7u"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/bba0f0fb7a9ee063d98abf6557ccdaee","name":"Do Tuyet Nhi","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/12dd398f8abe479231672d9ef7fb0a0c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/12dd398f8abe479231672d9ef7fb0a0c?s=96&d=mm&r=g","caption":"Do Tuyet Nhi"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/do-tuyet-nhi\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/256983","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=256983"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/256983\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/256984"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=256983"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=256983"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=256983"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}