{"id":13590,"date":"2015-09-19T02:32:42","date_gmt":"2015-09-19T02:32:42","guid":{"rendered":"https:\/\/centax.dsoftware.vn\/?p=13590"},"modified":"2015-09-29T09:21:43","modified_gmt":"2015-09-29T09:21:43","slug":"cach-su-dung-ham-rank-trong-ke-toan-excel","status":"publish","type":"post","link":"https:\/\/centax.dsoftware.vn\/?p=13590","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Rank trong k\u1ebf to\u00e1n Excel"},"content":{"rendered":"

\"C\u00e1ch<\/h2>\n

H\u00e0m RANK trong Excel l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u ng\u01b0\u1eddi s\u1eed d\u1ee5ng trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u, nh\u1ea5t l\u00e0 v\u1edbi nh\u1eefng ng\u01b0\u1eddi l\u00e0m k\u1ebf to\u00e1n th\u00ec h\u00e0m RANK r\u1ea5t ph\u1ed5 bi\u1ebfn.<\/span><\/p>\n

K\u1ebf to\u00e1n Centax<\/strong><\/a> xin chia s\u1ebb c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m RANK trong k\u1ebf to\u00e1n Excel. M\u1eddi b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o.<\/span><\/p>\n

1. C\u00f4ng d\u1ee5ng c\u1ee7a h\u00e0m RANK<\/span><\/h2>\n

Khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh ch\u1ee9a nhi\u1ec1u d\u00f2ng, b\u1ea1n c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp b\u1ea3ng t\u00ednh theo m\u1ed9t th\u1ee9 t\u1ef1 n\u00e0o \u0111\u00f3, \u0111\u1ec3 t\u1eeb \u0111\u00f3 bi\u1ebft th\u1ee9 h\u1ea1ng v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t d\u00f2ng n\u00e0o \u0111\u00f3 th\u00ec b\u1ea1n ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m RANK.<\/span><\/p>\n

H\u00e0m RANK l\u00e0 h\u00e0m tr\u1ea3 v\u1ec1 th\u1ee9 h\u1ea1ng c\u1ee7a m\u1ed9t s\u1ed1 trong danh s\u00e1ch c\u00e1c s\u1ed1, th\u1ee9 h\u1ea1ng c\u1ee7a m\u1ed9t s\u1ed1 l\u00e0 th\u1ee9 h\u1ea1ng gi\u00e1 tr\u1ecb c\u1ee7a n\u00f3 so v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c trong danh s\u00e1ch s\u1ed1. N\u00f3 g\u1ea7n gi\u1ed1ng v\u1edbi s\u1eafp x\u1ebfp d\u1eef li\u1ec7u nh\u01b0ng c\u00f3 k\u1ebft qu\u1ea3 \u01b0u vi\u1ec7t v\u00e0 d\u1ec5 qu\u1ea3n l\u00fd h\u01a1n .<\/span><\/p>\n

2. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m RANK<\/span><\/h2>\n

C\u00fa ph\u00e1p: =RANK(number,ref,[order])<\/strong><\/span><\/p>\n

\u00a0 Gi\u1ea3i th\u00edch:<\/span><\/p>\n

Number:<\/em> l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n x\u1ebfp h\u1ea1ng trong kh\u1ed1i<\/span><\/p>\n

Ref:<\/em> l\u00e0 kh\u1ed1i d\u1eef li\u1ec7u ho\u1eb7c danh s\u00e1ch. L\u01b0u \u00fd: Sau khi ch\u1ecdn kh\u1ed1i danh s\u00e1ch ph\u1ea3i F4 (1 l\u1ea7n) \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t v\u00e0 d\u00f2ng c\u1ee7a danh s\u00e1ch \u0111\u00f3, \u0111\u1ec3 cho ra th\u1ee9 h\u1ea1ng ch\u00ednh x\u00e1c.<\/span><\/p>\n

Order:<\/em> th\u1ee9 t\u1ef1 s\u1eafp x\u1ebfp (t\u0103ng d\u1ea7n ho\u1eb7c gi\u1ea3m d\u1ea7n). N\u1ebfu Order l\u00e0 \u201c0<\/strong>\u201d (ho\u1eb7c kh\u00f4ng c\u00f3 tham s\u1ed1) th\u00ec k\u1ebft qu\u1ea3 s\u1ebd s\u1eafp x\u1ebfp gi\u1ea3m d\u1ea7n. N\u1ebfu order l\u00e0 \u201c1<\/strong>\u201d (ho\u1eb7c b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o kh\u00e1c 0) th\u00ec k\u1ebft qu\u1ea3 s\u1ebd s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n.<\/span><\/p>\n

3. V\u00ed d\u1ee5<\/span><\/h2>\n

\"C\u00e1ch<\/p>\n

V\u1edbi nh\u1eefng s\u1ed1 tr\u00f9ng nhau s\u1ebd c\u00f3 th\u1ee9 h\u1ea1ng b\u1eb1ng nhau nh\u01b0ng l\u1ea1i \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn th\u1ee9 h\u1ea1ng k\u1ebf ti\u1ebfp n\u00f3. <\/span><\/p>\n

Trong v\u00ed d\u1ee5 tr\u00ean th\u00ec c\u00f3 2 ng\u01b0\u1eddi c\u00f3 ti\u1ec1n l\u01b0\u01a1ng b\u1eb1ng nhau l\u00e0 4.500.000, \u0111\u01b0\u1ee3c x\u1ebfp th\u1ee9 h\u1ea1ng b\u1eb1ng nhau l\u00e0 2. Tr\u01b0\u1eddng h\u1ee3p n\u00e0y g\u1ecdi l\u00e0 \u0111\u1ed3ng h\u1ea1ng, h\u00e0m RANK s\u1ebd gi\u1ea3i quy\u1ebft b\u1eb1ng c\u00e1ch b\u1ecf qua gi\u00e1 tr\u1ecb th\u1ee9 h\u1ea1ng ti\u1ebfp theo.\u00a0V\u1eady n\u00ean, th\u1ee9 h\u1ea1ng ti\u1ebfp theo s\u1ebd xu\u1ea5t hi\u1ec7n l\u00e0 4 (kh\u00f4ng c\u00f3 ng\u01b0\u1eddi n\u00e0o c\u00f3 th\u1ee9 h\u1ea1ng 3).<\/span><\/p>\n

B\u00e0i vi\u1ebft n\u00e0y c\u0169ng ph\u1ea7n n\u00e0o gi\u00fap c\u00e1c b\u1ea1n hi\u1ec3u r\u00f5 ch\u1ee9c n\u0103ng, c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m RANK. K\u1ebf to\u00e1n Centax ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

K\u1ebf to\u00e1n Centax xin gi\u1edbi thi\u1ec7u C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Rank trong k\u1ebf to\u00e1n Excel. \u0110\u00e2y l\u00e0 m\u1ed9t h\u00e0m \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi s\u1eed d\u1ee5ng khi x\u1eed l\u00fd d\u1eef li\u1ec7u. M\u1eddi b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o.<\/p>\n","protected":false},"author":7,"featured_media":13775,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"tags":[1715],"_links":{"self":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/13590"}],"collection":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13590"}],"version-history":[{"count":0,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/13590\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/media\/13775"}],"wp:attachment":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13590"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13590"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}