{"id":8741,"date":"2021-08-24T20:34:16","date_gmt":"2021-08-24T13:34:16","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=8741"},"modified":"2021-08-24T20:34:16","modified_gmt":"2021-08-24T13:34:16","slug":"meo-loc-so-dien-thoai-trong-excel","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/meo-loc-so-dien-thoai-trong-excel\/","title":{"rendered":"M\u1eb9o l\u1ecdc s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel"},"content":{"rendered":"

Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c tr\u00ean b\u1ea3ng t\u00ednh Excel, vi\u1ec7c th\u01b0\u1eddng xuy\u00ean \u0111\u1ec3 x\u1ea3y ra ra c\u00e1c sai s\u00f3t nh\u01b0 tr\u00f9ng d\u1eef li\u1ec7u l\u00e0 m\u1ed9t \u0111i\u1ec1u kh\u00f4ng th\u1ec3 tr\u00e1nh kh\u1ecfi. Ch\u00ednh v\u00ec th\u1ebf, s\u1eed d\u1ee5ng thao t\u00e1c l\u1ecdc c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng nhau trong c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh Excel \u0111\u01b0\u1ee3c xem l\u00e0 m\u1ed9t trong nh\u1eefng th\u1ee7 thu\u1eadt m\u00e0 nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng c\u1ea7n ph\u1ea3i bi\u1ebft \u0111\u1ec3 c\u00f3 th\u1ec3 h\u1ed7 tr\u1ee3 cho qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c di\u1ec5n ra ch\u00ednh x\u00e1c v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t.<\/p>\n

B\u01b0\u1edbc 1: Khi b\u1ea1n \u0111\u00e3 c\u00f3 s\u1eb5n m\u1ed9t b\u1ea3ng t\u00ednh Excel v\u1edbi h\u00e0ng tr\u0103m, th\u1eadm ch\u00ed l\u00e0 h\u00e0ng ngh\u00ecn s\u1ed1 \u0111i\u1ec7n tho\u1ea1i kh\u00e1c nhau. B\u1ea1n nh\u1ea5n \u0111\u00fap chu\u1ed9t tr\u00e1i v\u00e0o m\u1ee5c\u201cHome\u201d<\/strong><\/em>n\u1eb1m tr\u00ean thanh Menu c\u1ee7a b\u1ea3ng t\u00ednh\u00a0Excel -> Style->Conditional Formatting-> Highlight Cells Rule->Duplicate Values.<\/em><\/strong><\/p>\n

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

B\u01b0\u1edbc 2: Sau khi Click v\u00e0o h\u1ed9p tho\u1ea1i Duplicate Values, s\u1ebd xu\u1ea5t hi\u1ec7n 2 t\u00f9y ch\u1ecdn. C\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n

– Duplicate: Cho ra k\u1ebft qu\u1ea3 t\u1ed3n t\u1ea1i gi\u1ed1ng nhau duy nh\u1ea5t trong c\u1ed9t b\u00f4i \u0111en<\/p>\n

– Unique: Cho ra k\u1ebft qu\u1ea3 t\u1ed3n t\u1ea1i gi\u1ed1ng nhau m\u1ed9t b\u1ed9 ph\u1eadn n\u00e0o \u0111\u00f3 trong ph\u1ea7n b\u00f4i \u0111en.<\/p>\n

V\u1edbi c\u1ea3 hai t\u00f9y ch\u1ecdn Duplicate, Unique, ng\u01b0\u1eddi d\u00f9ng s\u1ebd ph\u1ea3i \u0111i\u1ec7n th\u00f4ng s\u1ed1 \u0111\u1ec3 ti\u1ebfn h\u00e0nh l\u1ecdc trong b\u1ea3ng t\u00ednh.<\/p>\n

L\u00fac n\u00e0y, b\u1ea1n s\u1ebd d\u1ec5 d\u00e0ng nh\u00ecn th\u1ea5y t\u00f9y ch\u1ecdn Values With. N\u00f3 mang \u00fd ngh\u0129a l\u00e0 l\u1ef1a ch\u1ecdn m\u00e0u s\u1eafc cho nh\u1eefng s\u1ed1 \u0111i\u1ec7n tho\u1ea1i b\u1ecb tr\u00f9ng l\u1eb7p \u0111\u1ec3 c\u00f3 th\u1ec3 l\u00e0m cho ch\u00fang tr\u1edf n\u00ean n\u1ed5i b\u1eadt v\u00e0 d\u1ec5 nh\u00ecn h\u01a1n. C\u1ee5 th\u1ec3:<\/p>\n

– Light Red Fill with Dark Red Text: Ch\u1eef v\u00e0 \u00f4 \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n b\u1eb1ng m\u00e0u s\u1eafc \u0111\u1ecf<\/p>\n

– Yellow Fill with Dark Red Text: M\u00e0u v\u00e0ng th\u1ec3 hi\u1ec7n ch\u1eef, c\u00f2n m\u00e0u \u0111en th\u1ec3 hi\u1ec7n \u00f4<\/p>\n

– Green Fill with Dark Red Text: M\u00e0u xanh l\u00e1 c\u00e2y th\u1ec3 hi\u1ec7n ch\u1eef, c\u00f2n m\u00e0u \u0111\u1ecf th\u1ec3 hi\u1ec7n \u00f4<\/p>\n

– Light Red Fill: M\u00e0u \u0111\u1ecf th\u1ec3 hi\u1ec7n ch\u1eef, c\u00f2n m\u00e0u tr\u1eafng th\u1ec3 hi\u1ec7n \u00f4<\/p>\n

– Red Text: Ch\u1eef m\u00e0u \u0111\u1ecf<\/p>\n

– Red Border: Ch\u1eef m\u00e0u \u0111en c\u00f3 vi\u1ec1n \u0111\u1ecf v\u00e0 m\u00e0u tr\u1eafng th\u1ec3 hi\u1ec7n \u00f4<\/p>\n

B\u01b0\u1edbc 3: T\u1ea1i\u00a0Duplicate Values -> ch\u1ecdn Duplicate -> Ok<\/strong><\/em>. Sau \u0111\u00f3, \u1edf b\u1ea3ng t\u00ednh Excel, b\u1ea1n s\u1ebd th\u1ea5y hi\u1ec3n th\u1ecb \u1edf c\u1ed9t s\u1ed1 \u0111i\u1ec7n tho\u1ea1i. L\u00fac n\u00e0y c\u00e1c s\u1ed1 \u0111i\u1ec7n tho\u1ea1i tr\u00f9ng nhau \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb d\u01b0\u1edbi d\u1ea1ng m\u00e0u m\u00e0 b\u1ea1n \u0111\u00e3 l\u1ef1a ch\u1ecdn \u1edf b\u01b0\u1edbc tr\u00ean. B\u1ea1n ch\u1ecdn m\u00e0u s\u1eafc n\u00e0o th\u00ec k\u1ebft qu\u1ea3 s\u1ebd cho ra m\u00e0u s\u1eafc hi\u1ec3n th\u1ecb nh\u01b0 v\u1eady.<\/p>\n

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

L\u01b0u \u00fd: – V\u1edbi c\u00e1ch l\u1ecdc nh\u01b0 tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00e1c thao t\u00e1c l\u00e0m cho c\u1ea3 c\u00e1c d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1 v\u00e0 d\u1ea1ng ch\u1eef.<\/p>\n

– Ch\u1ec9 c\u1ea7n thao t\u00e1c b\u00f4i \u0111en \u1edf c\u1ed9t d\u1eef li\u1ec7u l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng l\u1ecdc d\u1eef li\u1ec7u cho c\u1ea3 m\u1ed9t c\u1ed9t th\u00f4ng tin trong b\u1ea3ng t\u00ednh Excel. Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng ch\u00fang \u0111\u1ec3 l\u1ecdc tr\u00ean m\u1ed9t v\u00e0i h\u00e0ng b\u1eb1ng c\u00e1ch b\u00f4i \u0111en c\u00e1c h\u00e0ng c\u1ea7n l\u1ecdc.<\/p>\n

C\u00e1ch l\u1ecdc s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel trong tr\u01b0\u1eddng h\u1ee3p b\u1ecb l\u1eabn c\u00e1c s\u1ed1 kh\u00e1c<\/strong><\/h2>\n

V\u00ed d\u1ee5 khi b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, b\u1ea1n c\u1ea7n l\u1ecdc ra c\u00e1c s\u1ed1 \u0111i\u1ec7n tho\u1ea1i b\u1ecb l\u1eabn t\u1ea1p trong b\u1ea3ng t\u00ednh Excel, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c l\u1ecdc v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:<\/p>\n

B\u01b0\u1edbc 1: Ch\u1ecdn c\u1ed9t d\u1eef li\u1ec7u c\u1ea7n l\u1ecdc -> k\u00e9o xu\u1ed1ng cu\u1ed1i b\u1ecf tick\u00a0\u201cBlank\u201d.<\/em><\/strong><\/p>\n

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

B\u01b0\u1edbc 2: Copy ph\u1ea7n s\u1ed1 \u0111i\u1ec7n tho\u1ea1i \u0111ang hi\u1ec3n th\u1ecb tr\u00ean b\u1ea3ng t\u00ednh sang m\u1ed9t file Excel kh\u00e1c l\u00e0 b\u1ea1n \u0111\u00e3 ho\u00e0n th\u00e0nh xong C\u00e1ch l\u1ecdc s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel trong tr\u01b0\u1eddng h\u1ee3p b\u1ecb l\u1eabn c\u00e1c s\u1ed1 kh\u00e1c.<\/p>\n

Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng..<\/p>\n","protected":false},"excerpt":{"rendered":"

Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c tr\u00ean b\u1ea3ng t\u00ednh Excel, vi\u1ec7c th\u01b0\u1eddng xuy\u00ean \u0111\u1ec3 x\u1ea3y ra ra c\u00e1c sai s\u00f3t nh\u01b0 tr\u00f9ng d\u1eef li\u1ec7u l\u00e0 m\u1ed9t \u0111i\u1ec1u kh\u00f4ng th\u1ec3 tr\u00e1nh kh\u1ecfi. Ch\u00ednh v\u00ec th\u1ebf, s\u1eed d\u1ee5ng thao t\u00e1c l\u1ecdc c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng nhau trong c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh Excel \u0111\u01b0\u1ee3c xem l\u00e0 m\u1ed9t trong nh\u1eefng […]<\/p>\n","protected":false},"author":3,"featured_media":8743,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[508],"tags":[],"class_list":["post-8741","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8741","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=8741"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8741\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media\/8743"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=8741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=8741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=8741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}