{"id":5893,"date":"2017-01-03T01:18:03","date_gmt":"2017-01-03T01:18:03","guid":{"rendered":"http:\/\/tapchicntt.com\/?p=5893"},"modified":"2017-01-02T05:24:19","modified_gmt":"2017-01-02T05:24:19","slug":"excel-danh-so-thu-tu-lap-lai-theo-chu-ky-va-tu-dong-xep-phong-thi","status":"publish","type":"post","link":"https:\/\/tapchicntt.com\/excel-danh-so-thu-tu-lap-lai-theo-chu-ky-va-tu-dong-xep-phong-thi\/","title":{"rendered":"[Excel] \u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 l\u1eb7p l\u1ea1i theo chu k\u1ef3 v\u00e0 t\u1ef1 \u0111\u1ed9ng x\u1ebfp ph\u00f2ng thi"},"content":{"rendered":"

Trong c\u00e1c k\u1ef3 thi \u1edf c\u00e1c tr\u01b0\u1eddng h\u1ecdc c\u00f3 2 y\u00eau c\u1ea7u \u0111\u1eb7t ra: 1. M\u1ed7i ph\u00f2ng ch\u1ec9 \u0111\u01b0\u1ee3c x\u1ebfp 20 sinh vi\u00ean, l\u00e0m th\u1ebf n\u00e0o \u0111\u00e1nh s\u1ed1 t\u1eeb 1 \u0111\u1ebfn 20, h\u00e0ng ti\u1ebfp theo l\u1ea1i l\u1eb7p l\u1ea1i t\u1eeb 1 \u0111\u1ebfn 20, c\u00e1ch \u0111\u00e1nh s\u1ed1 n\u00e0y g\u1ecdi l\u00e0 \u0111\u00e1nh s\u1ed1 l\u1eb7p l\u1ea1i theo chu k\u1ef3 trong Excel. 2. X\u1ebfp c\u00e1c sinh vi\u00ean v\u00e0o t\u1eebng ph\u00f2ng, m\u1ed7i ph\u00f2ng 20 sinh vi\u00ean.<\/p>\n

B\u01b0\u1edbc 1: Thi\u1ebft k\u1ebf b\u1ea3ng t\u00ednh<\/h3>\n

T\u1ea1i Sheet1, b\u1ea1n \u0111\u1ed5i t\u00ean l\u00e0 Danh s\u00e1ch sinh vi\u00ean.<\/p>\n

Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh g\u1ed3m: S\u1ed1 b\u00e1o danh, s\u1ed1 ph\u1ee5, M\u00e3 SV, H\u1ecd t\u00ean, L\u1edbp, Ph\u00f2ng thi nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n\"\u0110\u00e1nh\n

T\u1ea1i Sheet2, b\u1ea1n \u0111\u1ed5i t\u00ean l\u00e0 Ph\u00f2ng thi g\u1ed3m 2 c\u1ed9t, c\u1ed9t S\u1ed1 th\u1ee9 t\u1ef1 v\u00e0 c\u1ed9t Ph\u00f2ng thi.<\/p>\n\"\u0110\u00e1nh\n

B\u1ea1n qu\u00e9t ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u tr\u1eeb h\u00e0ng ti\u00eau \u0111\u1ec1 trong th\u00ed d\u1ee5 n\u00e0y, t\u1eeb \u00f4 A2 \u0111\u1ebfn B1000 ch\u1eb3ng h\u1ea1n, b\u1ea5m th\u1ebb Formulas ch\u1ecdn Define Name, r\u1ed3i nh\u1eadp A, b\u1ea5m OK. Nh\u01b0 v\u1eady, t\u00ean v\u00f9ng d\u1eef li\u1ec7u n\u00e0y l\u00e0 A.<\/p>\n\"\u0110\u00e1nh\n

B\u01b0\u1edbc 2: Thi\u1ebft l\u1eadp h\u00e0m \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 l\u1eb7p l\u1ea1i theo chu k\u1ef3<\/h3>\n

T\u1ea1i \u00f4 B4, b\u1ea1n nh\u1eadp s\u1ed1 1.
\nT\u1ea1i \u00f4 B5, b\u1ea1n nh\u1eadp =IF(B4=20,1,B4+1)<\/strong><\/p>\n\"\u0110\u00e1nh\n

Sau \u0111\u00f3, b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c \u00f4 B5 t\u1edbi c\u00e1c \u00f4 kh\u00e1c trong c\u1ed9t B.
\nK\u1ebft qu\u1ea3, b\u1ea1n s\u1ebd c\u00f3 c\u00e1c s\u1ed1 \u0111\u01b0\u1ee3c \u0111\u00e1nh t\u1eeb 1 \u0111\u1ebfn 20 sau \u0111\u00f3 l\u1ea1i l\u1eb7p l\u1ea1i t\u1eeb 1 \u0111\u1ebfn 20.<\/p>\n

B\u01b0\u1edbc 3: G\u00e1n s\u1ed1 ph\u00f2ng thi<\/h3>\n

T\u1ea1i \u00f4 F4, b\u1ea1n nh\u1eadp =IF(A4=\u201d\u201d,\u201d\u201d,VLOOKUP(A4,A,2))
\nSau \u0111\u00f3, b\u1ea1n sao ch\u00e9p c\u00f4ng th\u1ee9c \u00f4 F5 t\u1edbi c\u00e1c \u00f4 kh\u00e1c trong c\u1ed9t F, s\u1ed1 ph\u00f2ng thi s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt v\u00e0o cho b\u1ea1n.<\/p>\n\"\u0110\u00e1nh\n

\u0110\u1ebfn s\u1ed1 21 b\u1ea1n s\u1ebd th\u1ea5y s\u1ed1 th\u1ee9 t\u1ef1 \u1edf c\u1ed9t s\u1ed1 ph\u1ee5 s\u1ebd l\u1ea1i l\u1eb7p l\u1ea1i, s\u1ed1 ph\u00f2ng thi s\u1ebd chuy\u1ec3n sang ph\u00f2ng kh\u00e1c.<\/p>\n","protected":false},"excerpt":{"rendered":"

Trong c\u00e1c k\u1ef3 thi \u1edf c\u00e1c tr\u01b0\u1eddng h\u1ecdc c\u00f3 2 y\u00eau c\u1ea7u \u0111\u1eb7t ra: 1. M\u1ed7i ph\u00f2ng ch\u1ec9 \u0111\u01b0\u1ee3c x\u1ebfp […]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[128],"tags":[],"class_list":["post-5893","post","type-post","status-publish","format-standard","hentry","category-van-phong"],"views":690,"_links":{"self":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/posts\/5893","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/comments?post=5893"}],"version-history":[{"count":0,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/posts\/5893\/revisions"}],"wp:attachment":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/media?parent=5893"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/categories?post=5893"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/tags?post=5893"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}