{"id":5975,"date":"2024-12-21T12:07:29","date_gmt":"2024-12-21T12:07:29","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/xep-hang-theo-dieu-kien-trong-excel-phan-2\/"},"modified":"2024-12-21T12:07:29","modified_gmt":"2024-12-21T12:07:29","slug":"xep-hang-theo-dieu-kien-trong-excel-phan-2","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/xep-hang-theo-dieu-kien-trong-excel-phan-2\/","title":{"rendered":"X\u1ebfp h\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n trong excel \u2013 Ph\u1ea7n 2"},"content":{"rendered":"
\n

Ph\u1ea7n 1:\u00a0Ph\u00e2n bi\u1ec7t c\u00e1c h\u00e0m x\u1ebfp h\u1ea1ng RANK \/ RANK.AVG \/ RANK.EQ<\/a><\/p>\n

Ph\u1ea7n 2: C\u00e1ch ph\u00e2n bi\u1ec7t nh\u1eefng ng\u01b0\u1eddi\u00a0\u0111\u1ed3ng h\u1ea1ng theo 1 ti\u00eau chu\u1ea9n\u00a0\u01b0u ti\u00ean (x\u1ebfp h\u1ea1ng theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n)<\/strong><\/p>\n

Theo b\u00e0i t\u1eadp v\u00ed d\u1ee5\u00a0\u1edf tr\u00ean, ch\u00fang ta c\u00f3 th\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh y\u00eau c\u1ea7u\u00a0\u1edf\u00a0\u0111\u00e2y nh\u01b0 sau:<\/p>\n

X\u1ebfp h\u1ea1ng theo\u00a0\u0111i\u1ec3m trung b\u00ecnh, n\u1ebfu\u00a0\u0111\u1ed3ng h\u1ea1ng th\u00ec\u00a0\u01b0u ti\u00ean nh\u1eefng ai c\u00f3\u00a0\u0111i\u1ec3m to\u00e1n cao h\u01a1n s\u1ebd x\u1ebfp h\u1ea1ng cao h\u01a1n.<\/p>\n

<\/p>\n

Ch\u00fang ta c\u00f9ng ph\u00e2n t\u00edch\u00a0\u0111\u1ec1 b\u00e0i\u00a0\u0111\u1ec3 hi\u1ec3u c\u00e1ch l\u00e0m nh\u00e9:<\/p>\n

B\u01b0\u1edbc 1<\/em><\/strong>: X\u00e9t\u00a0\u01b0u ti\u00ean m\u00f4n to\u00e1n khi\u00a0\u0111i\u1ec3m trung b\u00ecnh b\u1eb1ng nhau.<\/p>\n

<\/p>\n

\n
\n

D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n


\n
\n<\/a>\n<\/div>\n<\/div>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng:<\/p>\n

\n

=IF(COUNTIF($E$4:$E$13,E4)>1,RANK.EQ(B4,$B$4:$B$13,1),0)<\/p>\n<\/blockquote>\n

Ph\u00e2n t\u00edch c\u00f4ng th\u1ee9c:<\/p>\n

COUNTIF($E$4:$E$13,E4)>1\u00a0 \u00a0 \u00a0\u00a0\u0110\u1ebfm trong v\u00f9ng E4:E13 theo t\u1eebng gi\u00e1 tr\u1ecb\u00a0\u0111i\u1ec3m, x\u00e9t\u00a0\u0111i\u1ec3m n\u00e0o c\u00f3 k\u1ebft qu\u1ea3\u00a0\u0111\u1ebfm l\u1edbn h\u01a1n 1 (t\u1ee9c l\u00e0 c\u00f3\u00a0\u0111i\u1ec3m tr\u00f9ng)<\/p>\n

RANK.EQ(B4,$B$4:$B$13,1)\u00a0 \u00a0Khi\u00a0\u0111i\u1ec3m trung b\u00ecnh b\u1ecb tr\u00f9ng, th\u00ec ta s\u1ebd x\u1ebfp h\u1ea1ng theo\u00a0\u0111i\u1ec3m to\u00e1n, th\u1ee9 t\u1ef1 t\u0103ng\u00a0d\u1ea7n (ai\u00a0\u0111i\u1ec3m th\u1ea5p nh\u1ea5t s\u1ebd x\u1ebfp tr\u01b0\u1edbc)<\/p>\n

=> C\u00f4ng th\u1ee9c\u00a0\u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0: n\u1ebfu\u00a0\u0111i\u1ec3m trung b\u00ecnh m\u00e0 tr\u00f9ng, th\u00ec t\u1ea1i nh\u1eefng ng\u01b0\u1eddi b\u1ecb tr\u00f9ng\u00a0\u0111\u00f3 s\u1ebd x\u1ebfp h\u1ea1ng h\u1ecd theo\u00a0\u0111i\u1ec3m m\u00f4n to\u00e1n, theo th\u1ee9 t\u1ef1 t\u0103ng\u00a0d\u1ea7n.<\/p>\n

* L\u01b0u\u00a0\u00fd\u00a0\u1edf\u00a0\u0111\u00e2y: T\u1ea1i sao th\u1ee9 t\u1ef1\u00a0\u01b0u ti\u00ean l\u1ea1i x\u1ebfp t\u0103ng d\u1ea7n m\u00e0 kh\u00f4ng ph\u1ea3i gi\u1ea3m d\u1ea7n.<\/p>\n

B\u1edfi v\u00ec nh\u01b0 v\u1eady ai\u00a0\u0111i\u1ec3m c\u00e0ng cao th\u00ec th\u1ee9 t\u1ef1 c\u00e0ng l\u00e0 s\u1ed1 l\u1edbn => S\u1ed1 th\u1ee9 h\u1ea1ng n\u00e0y c\u0169ng ch\u00ednh l\u00e0 s\u1ed1 s\u1ebd\u00a0\u0111\u01b0\u1ee3c c\u1ed9ng th\u00eam v\u00e0o\u00a0\u0111i\u1ec3m g\u1ed1c\u00a0\u0111\u1ec3 l\u00e0m c\u0103n c\u1ee9 x\u1ebfp h\u1ea1ng v\u1edbi\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0\u01b0u ti\u00ean => S\u1ed1\u00a0\u0111i\u1ec3m c\u00e0ng cao th\u00ec\u00a0\u0111i\u1ec3m c\u1ed9ng c\u00e0ng nhi\u1ec1u<\/p>\n

B\u01b0\u1edbc 2<\/em><\/strong>: T\u00ednh l\u1ea1i\u00a0\u0111i\u1ec3m trung b\u00ecnh khi c\u00f3\u00a0\u0111i\u1ec3m\u00a0\u01b0u ti\u00ean<\/p>\n

<\/p>\n

V\u00ec\u00a0\u0111i\u1ec3m trung b\u00ecnh c\u00f3 2 s\u1ed1 sau d\u1ea5u ph\u1ea9y n\u00ean\u00a0\u0111i\u1ec3m\u00a0\u01b0u ti\u00ean s\u1ebd t\u00ednh sau d\u1ea5u ph\u1ea9y 3 ch\u1eef s\u1ed1 (chia th\u1ee9 h\u1ea1ng\u00a0\u1edf c\u1ed9t\u00a0\u01b0u ti\u00ean cho 1000)<\/p>\n

Khi\u00a0\u0111\u00f3 ta s\u1ebd\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111i\u1ec3m trung b\u00ecnh m\u1edbi bao g\u1ed3m\u00a0\u0111i\u1ec3m trung b\u00ecnh c\u0169 +\u00a0\u0111i\u1ec3m x\u1ebfp h\u1ea1ng v\u1edbi nh\u1eefng \u0111i\u1ec3m tr\u00f9ng m\u00e0 x\u00e9t\u00a0\u01b0u ti\u00ean v\u1edbi\u00a0\u0111i\u1ec3m to\u00e1n<\/p>\n

\u0110i\u1ec3m x\u1ebfp h\u1ea1ng\u00a0\u01b0u ti\u00ean n\u00e0y n\u00ean\u00a0\u0111\u1eb7t ph\u00eda sau\u00a0\u0111i\u1ec3m g\u1ed1c\u00a0\u0111\u1ec3 vi\u1ec7c s\u1eafp x\u1ebfp th\u1ee9 h\u1ea1ng t\u1ed1t h\u01a1n v\u00e0 d\u1ec5 ph\u00e2n bi\u1ec7t h\u01a1n.<\/p>\n

B\u01b0\u1edbc 3<\/strong><\/em>: X\u1ebfp h\u1ea1ng d\u1ef1a tr\u00ean\u00a0\u0111i\u1ec3m trung b\u00ecnh m\u1edbi<\/p>\n

<\/p>\n

H\u00e0m x\u1ebfp h\u1ea1ng\u00a0\u1edf\u00a0\u0111\u00e2y ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m RANK.EQ\u00a0\u0111\u1ec3 x\u1ebfp h\u1ea1ng cho\u00a0\u0111i\u1ec3m trung b\u00ecnh m\u1edbi.<\/p>\n

Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 hi\u1ec3u\u00a0\u0111\u01b0\u1ee3c c\u00e1ch x\u1ebfp h\u1ea1ng theo 1\u00a0\u0111i\u1ec1u ki\u1ec7n. Trong b\u00e0i vi\u1ebft\u00a0\u1edf ph\u1ea7n sau, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u c\u00e1ch x\u1ebfp h\u1ea1ng theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n (theo th\u1ee9 t\u1ef1\u00a0\u01b0u ti\u00ean)<\/p>\n

\u0110\u00f3n xem:\u00a0Ph\u1ea7n 3:\u00a0x\u1ebfp h\u1ea1ng theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0(theo th\u1ee9 t\u1ef1\u00a0\u01b0u ti\u00ean)<\/a><\/p>\n

C\u00e1c h\u00e0m v\u00e0 c\u00f4ng th\u1ee9c trong Excel th\u1eadt ph\u1ee9c t\u1ea1p ph\u1ea3i kh\u00f4ng? Kh\u00f4ng h\u1eb3n nh\u01b0 v\u1eady, n\u1ebfu b\u1ea1n bi\u1ebft c\u00e1ch s\u1eafp x\u1ebfp, s\u1eed d\u1ee5ng c\u00f3 h\u1ec7 th\u1ed1ng th\u00ec Excel tr\u1edf n\u00ean v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n. \u0110\u00e2y l\u00e0 v\u0169 kh\u00ed \u0111\u1eafc l\u1ef1c \u0111\u1ec3 b\u1ea1n gi\u1ea3i quy\u1ebft c\u00e1c c\u00f4ng vi\u1ec7c trong th\u1eddi gian ng\u1eafn v\u00e0 \u0111\u1ea3m b\u1ea3o hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c cao.<\/p>\n

Blog Ho\u0323c Excel Online \u0111a\u0303 m\u01a1\u0309 r\u00e2\u0301t nhi\u00ea\u0300u ca\u0301c kho\u0301a ho\u0323c \u0111a\u0300o ta\u0323o v\u00ea\u0300\u00a0H\u1ecdc Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/a>\u00a0v\u01a1\u0301i ca\u0301c chuy\u00ean gia ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam. Ch\u00fang t\u00f4i se\u0303 mang \u0111\u00ea\u0301n cho ba\u0323n nh\u01b0\u0303ng bu\u00f4\u0309i ho\u0323c b\u00f4\u0309 i\u0301ch, hi\u1ec7u qua\u0309 co\u0301 th\u00ea\u0309 s\u01b0\u0309 du\u0323ng tha\u0300nh tha\u0323o Excel \u0111\u00ea\u0309 a\u0301p du\u0323ng trong c\u00f4ng vi\u00ea\u0323c. Ngoa\u0300i ra, chu\u0301ng t\u00f4i \u0111ang co\u0301 nhi\u00ea\u0300u ch\u01b0\u01a1ng tri\u0300nh khuy\u00ea\u0301n ma\u0323i l\u01a1\u0301n cho ca\u0301c ho\u0323c vi\u00ean \u0111\u0103ng ki\u0301 trong tha\u0301ng na\u0300y, v\u00e2\u0323y co\u0300n tr\u1ea7n tr\u01b0\u0300 gi\u0300 n\u01b0\u0303a ma\u0300 kh\u00f4ng \u0111\u0103ng ki\u0301 ngay th\u00f4i. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/p>\n

\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n

D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n


\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5976,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5975","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\/5975","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=5975"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5975\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5976"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5975"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5975"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5975"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}