{"id":8351,"date":"2024-12-22T10:12:15","date_gmt":"2024-12-22T10:12:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/huong-dan-nhan-doi-du-lieu-trong-danh-sach-tren-excel\/"},"modified":"2024-12-22T10:12:15","modified_gmt":"2024-12-22T10:12:15","slug":"huong-dan-nhan-doi-du-lieu-trong-danh-sach-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/huong-dan-nhan-doi-du-lieu-trong-danh-sach-tren-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn nh\u00e2n \u0111\u00f4i d\u1eef li\u1ec7u trong danh s\u00e1ch tr\u00ean Excel"},"content":{"rendered":"
\n

Trong Excel ch\u00fang ta c\u00f3 t\u00ednh n\u0103ng Remove Duplicates \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng trong m\u1ed9t danh s\u00e1ch. V\u1eady n\u1ebfu l\u00e0m ng\u01b0\u1ee3c l\u1ea1i th\u00ec sao? L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 th\u1ec3 nh\u00e2n \u0111\u00f4i, nh\u00e2n ba\u2026 nh\u00e2n d\u1eef li\u1ec7u trong danh s\u00e1ch l\u00ean nhi\u1ec1u l\u1ea7n? H\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y:\u00a0H\u01b0\u1edbng d\u1eabn nh\u00e2n \u0111\u00f4i d\u1eef li\u1ec7u trong danh s\u00e1ch tr\u00ean Excel<\/p>\n

Nh\u00e2n \u0111\u00f4i d\u1eef li\u1ec7u trong danh s\u00e1ch tr\u00ean Excel<\/h3>\n

C\u00f4ng th\u1ee9c ta s\u1eed d\u1ee5ng trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y s\u1ebd l\u00e0:<\/p>\n

\n

=INDEX(V\u00f9ng d\u1eef li\u1ec7u<\/em>,ROUNDUP(ROW(A1)\/ X<\/em>,0))<\/strong><\/p>\n<\/blockquote>\n

V\u1edbi X l\u00e0 s\u1ed1 l\u1ea7n mu\u1ed1n nh\u00e2n l\u00ean.<\/p>\n

Ta c\u00f3 th\u1ec3 xem qua v\u00ed d\u1ee5 sau:<\/p>\n

<\/p>\n

T\u1ea1i \u00f4 B4, \u0111\u1eb7t c\u00f4ng th\u1ee9c \u0111\u1ec3 nh\u00e2n d\u1eef li\u1ec7u nh\u00e2n vi\u00ean v\u00f9ng A4:A13 l\u00ean 5 l\u1ea7n:<\/p>\n

=INDEX($A$4:$A$13,ROUNDUP(ROW(A1)\/5,0))<\/strong><\/p>\n

<\/p>\n

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

Sau \u0111\u00f3 fill xu\u1ed1ng d\u01b0\u1edbi v\u00e0 ta c\u00f3 k\u1ebft qu\u1ea3:<\/p>\n

<\/p>\n

\n

Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 v\u1ec1 c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a INDEX:<\/p>\n

INDEX tr\u1ea3 v\u1ec1 h\u00ecnh \u1ea3nh trong Excel<\/strong><\/a><\/p>\n

S\u1eed d\u1ee5ng INDEX MATCH thay th\u1ebf VLOOKUP<\/strong><\/a><\/p>\n

S\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o INDEX MATCH<\/strong><\/a><\/p>\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
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8352,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8351","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8351","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=8351"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8351\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8352"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}