L\u1ef1a ch\u1ecdn Microsoft Excel \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng cung c\u1ea5p nhi\u1ec1u l\u1ee3i \u00edch v\u00ec Excel l\u00e0 m\u1ed9t trong nh\u1eefng \u1ee9ng d\u1ee5ng ph\u1ed5 bi\u1ebfn nh\u1ea5t v\u00e0 m\u1ea1nh m\u1ebd trong vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00e0 b\u1ea3ng t\u00ednh. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u00fd do t\u1ea1i sao b\u1ea1n n\u00ean s\u1eed d\u1ee5ng Excel \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y:<\/p>\n
D\u1ec5 s\u1eed d\u1ee5ng: Excel c\u00f3 giao di\u1ec7n th\u00e2n thi\u1ec7n v\u00e0 \u0111\u01a1n gi\u1ea3n, cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng m\u1edbi l\u00e0m quen d\u1ec5 d\u00e0ng. C\u00e1c t\u00ednh n\u0103ng l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng \u0111\u01b0\u1ee3c t\u00edch h\u1ee3p s\u1eb5n v\u00e0 d\u1ec5 t\u00ecm th\u1ea5y trong menu.<\/p>\n
M\u1ea1nh m\u1ebd v\u00e0 linh ho\u1ea1t: Cung c\u1ea5p nhi\u1ec1u t\u00f9y ch\u1ecdn v\u00e0 c\u00e1ch th\u1ee9c \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel. B\u1ea1n c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn d\u1ef1a tr\u00ean m\u1ed9t c\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t, v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n l\u1ecdc kh\u00e1c nhau.<\/p>\n
X\u1eed l\u00fd d\u1eef li\u1ec7u l\u1edbn: Excel c\u00f3 kh\u1ea3 n\u0103ng x\u1eed l\u00fd c\u00e1c t\u1ec7p d\u1eef li\u1ec7u l\u1edbn m\u00e0 kh\u00f4ng g\u00e2y tr\u1edf ng\u1ea1i \u0111\u00e1ng k\u1ec3. B\u1ea1n c\u00f3 th\u1ec3 thao t\u00e1c v\u1edbi h\u00e0ng ng\u00e0n d\u00f2ng d\u1eef li\u1ec7u m\u00e0 kh\u00f4ng g\u1eb7p v\u1ea5n \u0111\u1ec1 hi\u1ec7u su\u1ea5t.<\/p>\n Kh\u1ea3 n\u0103ng t\u01b0\u01a1ng t\u00e1c: Sau khi l\u1ecdc d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 t\u01b0\u01a1ng t\u00e1c v\u1edbi k\u1ebft qu\u1ea3 b\u1eb1ng c\u00e1ch th\u00eam, s\u1eeda \u0111\u1ed5i ho\u1eb7c x\u00f3a d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/p>\n C\u00f3 s\u1eb5n tr\u00ean nhi\u1ec1u n\u1ec1n t\u1ea3ng: Excel kh\u00f4ng ch\u1ec9 c\u00f3 phi\u00ean b\u1ea3n cho m\u00e1y t\u00ednh c\u00e1 nh\u00e2n, m\u00e0 c\u00f2n c\u00f3 \u1ee9ng d\u1ee5ng tr\u00ean nhi\u1ec1u n\u1ec1n t\u1ea3ng di \u0111\u1ed9ng. \u0110i\u1ec1u n\u00e0y cho ph\u00e9p b\u1ea1n truy c\u1eadp v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u tr\u00ean c\u1ea3 m\u00e1y t\u00ednh v\u00e0 \u0111i\u1ec7n tho\u1ea1i di \u0111\u1ed9ng.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00f4 c\u00f9ng th\u00f4ng minh. \u0110\u1ec3 l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng tr\u00ean c\u00f4ng c\u1ee5 n\u00e0y c\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1ch, c\u00f9ng tham kh\u1ea3o d\u01b0\u1edbi \u0111\u00e2y nh\u00e9.<\/p>\n Microsoft Excel c\u00f3 m\u1ed9t t\u00ednh n\u0103ng m\u1ea1nh m\u1ebd \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 “Remove Duplicates” (Lo\u1ea1i b\u1ecf tr\u00f9ng l\u1eb7p) gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u1ec5 d\u00e0ng lo\u1ea1i b\u1ecf c\u00e1c d\u00f2ng d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p m\u00e0 kh\u00f4ng c\u1ea7n quan t\u00e2m \u0111\u1ebfn n\u1ed9i dung b\u00ean trong c\u1ee7a ch\u00fang. T\u00ednh n\u0103ng n\u00e0y \u0111\u00e3 c\u00f3 t\u1eeb r\u1ea5t l\u00e2u v\u00e0 \u0111\u01b0\u1ee3c t\u00edch h\u1ee3p s\u1eb5n trong c\u00e1c phi\u00ean b\u1ea3n Excel. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng t\u00ednh n\u0103ng n\u00e0y \u0111\u1ec3 lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t:<\/p>\n B\u01b0\u1edbc 1: M\u1edf t\u1ec7p Excel m\u00e0 b\u1ea1n mu\u1ed1n l\u1ecdc d\u1eef li\u1ec7u. Sau \u0111\u00f3, b\u1ea1n h\u00e3y ch\u1ecdn v\u00e0 ki\u1ec3m tra khu v\u1ef1c d\u1eef li\u1ec7u c\u1ea7n t\u00ecm c\u00e1c d\u00f2ng tr\u00f9ng l\u1eb7p.<\/p>\n B\u01b0\u1edbc 2: Tr\u00ean thanh c\u00f4ng c\u1ee5 \u1edf \u0111\u1ec9nh m\u00e0n h\u00ecnh, h\u00e3y nh\u1ea5p v\u00e0o th\u1ebb “Data” (D\u1eef li\u1ec7u). Ti\u1ebfp theo, ch\u1ecdn “Data Tools” (C\u00f4ng c\u1ee5 D\u1eef li\u1ec7u) v\u00e0 sau \u0111\u00f3 ch\u1ecdn t\u00ednh n\u0103ng “Remove Duplicates” (Lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u tr\u00f9ng).<\/p>\n B\u01b0\u1edbc 3: M\u1ed9t b\u1ea3ng “Remove Duplicates” (Lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u tr\u00f9ng) s\u1ebd xu\u1ea5t hi\u1ec7n. B\u1ea1n h\u00e3y ch\u1ecdn c\u1ed9t (ho\u1eb7c c\u00e1c c\u1ed9t) m\u00e0 b\u1ea1n mu\u1ed1n d\u00f9ng \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel v\u00e0 \u0111\u00e1nh d\u1ea5u \u00f4 vu\u00f4ng t\u01b0\u01a1ng \u1ee9ng. N\u1ebfu b\u1ea1n mu\u1ed1n l\u1ecdc d\u1eef li\u1ec7u t\u1eeb t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn “Select All” (Ch\u1ecdn t\u1ea5t c\u1ea3).<\/p>\n B\u01b0\u1edbc 4: Sau khi b\u1ea1n \u0111\u00e3 l\u1ef1a ch\u1ecdn c\u00e1c c\u1ed9t d\u1eef li\u1ec7u theo \u00fd mu\u1ed1n, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat “OK”. H\u1ec7 th\u1ed1ng s\u1ebd nhanh ch\u00f3ng x\u1eed l\u00fd v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u1ecdc d\u1eef li\u1ec7u d\u1ef1a tr\u00ean c\u00e1c l\u1ef1a ch\u1ecdn c\u1ee7a b\u1ea1n.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n Khi b\u1ea1n mu\u1ed1n ki\u1ec3m tra d\u1eef li\u1ec7u tr\u01b0\u1edbc khi x\u00f3a v\u00e0 kh\u00f4ng ch\u1eafc ch\u1eafn v\u1ec1 ch\u00fang, t\u00ednh n\u0103ng “Conditional Formatting” (\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n) trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p.<\/p>\n B\u01b0\u1edbc 1: Ch\u1ecdn c\u1ed9t d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n ki\u1ec3m tra. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p v\u00e0o ti\u00eau \u0111\u1ec1 c\u1ed9t t\u01b0\u01a1ng \u1ee9ng.<\/p>\n B\u01b0\u1edbc 2: Trong th\u1ebb “Home” c\u1ee7a Excel, \u0111i\u1ec1u h\u01b0\u1edbng \u0111\u1ebfn ph\u1ea7n “Styles” v\u00e0 ch\u1ecdn “Conditional Formatting,” sau \u0111\u00f3 ch\u1ecdn “Highlight Cells Rules” v\u00e0 ti\u1ebfp theo l\u00e0 “Duplicate Values.”<\/p>\n B\u01b0\u1edbc 3: Trong c\u1eeda s\u1ed5 hi\u1ec3n th\u1ecb, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1ch m\u00e0 c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u. B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn “Duplicate” n\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p, ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 s\u1eeda \u0111\u1ed5i \u00f4 n\u00e0y th\u00e0nh “Unique” n\u1ebfu b\u1ea1n mu\u1ed1n n\u1ed5i b\u1eadt c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong ph\u1ea1m vi d\u1eef li\u1ec7u n\u00e0y.<\/p>\n B\u01b0\u1edbc 4: B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh m\u00e0u s\u1eafc \u0111\u1ec3 d\u1ec5 d\u00e0ng ph\u00e2n bi\u1ec7t. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn m\u00e0u \u0111\u1ecf nh\u1ea1t v\u1edbi ch\u1eef m\u00e0u \u0111\u1ecf \u0111\u1eadm \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p.<\/p>\n B\u01b0\u1edbc 5: Cu\u1ed1i c\u00f9ng, x\u00e1c nh\u1eadn b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o “OK,” v\u00e0 b\u1ea1n s\u1ebd th\u1ea5y r\u1eb1ng c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p (n\u1ebfu b\u1ea1n \u0111\u00e3 ch\u1ecdn “Duplicate”) ho\u1eb7c c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u b\u1eb1ng m\u00e0u s\u1eafc b\u1ea1n \u0111\u00e3 ch\u1ecdn tr\u01b0\u1edbc \u0111\u00f3.<\/p>\n Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap b\u1ea1n l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n v\u00e0 ch\u00ednh x\u00e1c. \u0110\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng n\u00e0y, b\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o r\u1eb1ng t\u1eadp tin d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh \u0111\u00e1p \u1ee9ng c\u00e1c y\u00eau c\u1ea7u sau:<\/p>\n B\u01b0\u1edbc 1: M\u1edf t\u1ec7p Excel v\u00e0 ch\u1ecdn ph\u1ea1m vi \u00f4\/c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n l\u1ecdc gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p.<\/p>\n B\u01b0\u1edbc 2: Trong thanh c\u00f4ng c\u1ee5, trong nh\u00f3m “Sort & Filter,” b\u1ea1n ch\u1ecdn “Advanced.”<\/p>\n B\u01b0\u1edbc 3: M\u1ed9t h\u1ed9p tho\u1ea1i “Advanced Filter” s\u1ebd xu\u1ea5t hi\u1ec7n, v\u00e0 b\u1ea1n s\u1ebd th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c sau:<\/p>\n B\u01b0\u1edbc 4: Khi b\u1ea1n ho\u00e0n th\u00e0nh c\u00e1c b\u01b0\u1edbc tr\u00ean, t\u1ea1i v\u1ecb tr\u00ed m\u00e0 b\u1ea1n \u0111\u00e3 ch\u1ecdn trong m\u1ee5c “Copy to,” c\u00e1c d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c l\u1ecdc s\u1ebd hi\u1ec3n th\u1ecb<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel l\u00e0 s\u1eed d\u1ee5ng Pivot Table. Pivot Table l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd cho ph\u00e9p b\u1ea1n th\u1ed1ng k\u00ea v\u00e0 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng Pivot Table \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p:<\/p>\n B\u01b0\u1edbc 1: B\u1eaft \u0111\u1ea7u b\u1eb1ng vi\u1ec7c ch\u1ecdn ph\u1ea1m vi d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n l\u1ecdc. Sau \u0111\u00f3, tr\u00ean thanh c\u00f4ng c\u1ee5, ch\u1ecdn “Insert,” v\u00e0 sau \u0111\u00f3 ch\u1ecdn “Pivot Table.” H\u00e3y ki\u1ec3m tra r\u1eb1ng “Table\/Range” \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1eb7t \u0111\u00fang cho ph\u1ea1m vi d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n. \u1ede m\u1ee5c “Choose where you want the PivotTable to be placed,” b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn “New Worksheet” n\u1ebfu b\u1ea1n mu\u1ed1n Pivot Table xu\u1ea5t hi\u1ec7n tr\u00ean m\u1ed9t trang t\u00ednh m\u1edbi ho\u1eb7c “Existing Worksheet” n\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1eb7t Pivot Table \u1edf v\u1ecb tr\u00ed c\u1ee5 th\u1ec3. Sau \u0111\u00f3, nh\u1ea5n OK.<\/p>\n B\u01b0\u1edbc 2: C\u00e1c t\u00f9y ch\u1ecdn c\u1ee7a Pivot Table s\u1ebd xu\u1ea5t hi\u1ec7n. Trong c\u1eeda s\u1ed5 “PivotTable Fields,” b\u1ea1n k\u00e9o c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng v\u00e0o \u00f4 “Rows.” V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong c\u1ed9t “H\u1ecd v\u00e0 T\u00ean,” h\u00e3y k\u00e9o c\u1ed9t n\u00e0y v\u00e0o \u00f4 “Rows.” Sau \u0111\u00f3, k\u00e9o c\u1ed9t \u0111\u00f3 v\u00e0o \u00f4 “Values” v\u00e0 ch\u1ecdn “Value Field Settings” l\u00e0 “Count”.<\/p>\n B\u01b0\u1edbc 3: Click 2 l\u1ea7n c\u00e1c\u00a0gi\u00e1 tr\u1ecb c\u00f3 s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n l\u1edbn h\u01a1n 1. Excel s\u1ebd hi\u1ec3n th\u1ecb danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng l\u1eb7p cho b\u1ea1n.<\/p>\n \u0110\u1ec3 l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel gi\u1eefa nhi\u1ec1u sheet, b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng c\u00e1c h\u00e0m v\u00e0 c\u00f4ng th\u1ee9c.<\/p>\n B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, b\u1ea1n c\u1ea7n th\u00eam m\u1ed9t c\u1ed9t “Ki\u1ec3m Tra” v\u00e0o v\u00f9ng d\u1eef li\u1ec7u th\u1ee9 hai tr\u00ean sheet th\u1ee9 hai.<\/p>\n B\u01b0\u1edbc 2: Sau \u0111\u00f3, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c cho c\u1ed9t “Ki\u1ec3m Tra.” H\u00e3y gi\u1ea3 s\u1eed c\u1ed9t “H\u1ecd v\u00e0 T\u00ean” c\u1ee7a b\u1ea1n n\u1eb1m \u1edf c\u1ed9t A. Nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o \u00f4 C2 (ho\u1eb7c \u00f4 b\u1ea5t k\u1ef3 trong c\u1ed9t “Ki\u1ec3m Tra”) tr\u00ean sheet th\u1ee9 hai:<\/p>\n Trong c\u00f4ng th\u1ee9c n\u00e0y, “Sheet1” l\u00e0 t\u00ean c\u1ee7a sheet ch\u1ee9a d\u1eef li\u1ec7u th\u1ee9 nh\u1ea5t, “A:C” l\u00e0 ph\u1ea1m vi d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n so s\u00e1nh, v\u00e0 “1” l\u00e0 s\u1ed1 c\u1ed9t b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 n\u1ebfu t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p. C\u00f4ng th\u1ee9c n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 “Unique” n\u1ebfu gi\u00e1 tr\u1ecb kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y \u1edf sheet th\u1ee9 nh\u1ea5t v\u00e0 “Duplicate” n\u1ebfu t\u00ecm th\u1ea5y.<\/p>\n B\u01b0\u1edbc 3: Cu\u1ed1i c\u00f9ng, b\u1ea1n c\u1ea7n \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y cho to\u00e0n b\u1ed9 c\u1ed9t “Ki\u1ec3m Tra” tr\u00ean sheet th\u1ee9 hai. C\u1ed9t “Ki\u1ec3m Tra” s\u1ebd tr\u1ea3 v\u1ec1 “Duplicate” cho nh\u1eefng gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p v\u00e0 “Unique” cho nh\u1eefng gi\u00e1 tr\u1ecb duy nh\u1ea5t.<\/p>\n Nh\u01b0 v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c nh\u1eefng gi\u00e1 tr\u1ecb n\u00e0o b\u1ecb tr\u00f9ng l\u1eb7p gi\u1eefa hai v\u00f9ng d\u1eef li\u1ec7u tr\u00ean hai sheet kh\u00e1c nhau.<\/p>\n \u0110\u1ec3 \u0111\u1ea3m b\u1ea3o k\u1ebft qu\u1ea3 l\u1ecdc ra ch\u00ednh x\u00e1c ho\u1eb7c h\u1ea1n ch\u1ebf c\u00e1c t\u00ecnh tr\u1ea1ng m\u1ea5t ho\u1eb7c h\u1ecfng d\u1eef li\u1ec7u th\u00ec khi l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p trong Excel c\u1ea7n l\u01b0u \u00fd m\u1ed9t s\u1ed1 y\u1ebfu t\u1ed1 sau:<\/p>\n Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta \u0111\u00e3 t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t. Vi\u1ec7c l\u00e0m s\u1ea1ch v\u00e0 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u l\u00e0 m\u1ed9t ph\u1ea7n quan tr\u1ecdng c\u1ee7a c\u00f4ng vi\u1ec7c v\u1edbi Excel, v\u00e0 kh\u1ea3 n\u0103ng lo\u1ea1i b\u1ecf c\u00e1c b\u1ea3n ghi tr\u00f9ng l\u1eb7p c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c h\u01a1n. Hy v\u1ecdng th\u00f4ng qua b\u00e0i vi\u1ebft b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm \u0111\u01b0\u1ee3c c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u c\u1ee7a m\u00ecnh.<\/p>\n Tham kh\u1ea3o th\u00eam:<\/p>\n Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Microsoft Excel, vi\u1ec7c qu\u1ea3n l\u00fd v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u th\u01b0\u1eddng l\u00e0 m\u1ed9t ph\u1ea7n quan tr\u1ecdng v\u00e0 th\u01b0\u1eddng xuy\u00ean. M\u1ed9t trong nh\u1eefng th\u00e1ch th\u1ee9c ph\u1ed5 bi\u1ebfn khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u l\u00e0 x\u00e1c \u0111\u1ecbnh v\u00e0 lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u tr\u00f9ng. D\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p kh\u00f4ng ch\u1ec9 l\u00e0m t\u0103ng […]<\/p>\n","protected":false},"author":85,"featured_media":266986,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-266561","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"yoast_head":"\n![\"Cach-loc-du-lieu-trung-trong-excel-3\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/Cach-loc-du-lieu-trung-trong-excel-3.jpg.webp)
<\/picture><\/p>\nH\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng tr\u00ean Excel nhanh ch\u00f3ng<\/h2>\n
L\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel v\u1edbi Remove Duplicate<\/h3>\n
![\"loc-du-lieu-trung-trong-excel-16\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/loc-du-lieu-trung-trong-excel.jpg.webp)
<\/picture><\/p>\n![\"loc-du-lieu-trung-trong-excel-13\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/loc-du-lieu-trung-trong-excel-2.jpg.webp)
<\/picture><\/p>\nC\u00e1ch t\u00ecm v\u00e0 l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel v\u1edbi Conditional Formatting<\/h3>\n
![\"loc-du-lieu-trung-trong-excel-15\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/loc-du-lieu-trung-trong-excel-4.jpg.webp)
<\/picture><\/p>\n![\"loc-du-lieu-trung-trong-excel-5\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/loc-du-lieu-trung-trong-excel-5.jpg.webp)
<\/picture><\/p>\n![\"loc-du-lieu-trung-trong-excel-6\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/loc-du-lieu-trung-trong-excel-6.jpg.webp)
<\/picture><\/p>\nC\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel b\u1eb1ng Advanced Filter<\/h3>\n
\n
![\"loc-du-lieu-trung-trong-excel-7\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/loc-du-lieu-trung-trong-excel-7.jpg.webp)
<\/picture><\/p>\n\n
![\"loc-du-lieu-trung-trong-excel-8\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/loc-du-lieu-trung-trong-excel-8.jpg.webp)
<\/picture><\/p>\nH\u01b0\u1edbng d\u1eabn L\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p b\u1eb1ng Pivot Table<\/h3>\n
![\"loc-du-lieu-trung-trong-excel-9\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/loc-du-lieu-trung-trong-excel-9.jpg.webp)
<\/picture><\/p>\n![\"loc-du-lieu-trung-trong-excel-10\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/loc-du-lieu-trung-trong-excel-10.jpg.webp)
<\/picture><\/p>\n![\"loc-du-lieu-trung-trong-excel-11\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/loc-du-lieu-trung-trong-excel-11.jpg.webp)
<\/picture><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\nH\u01b0\u1edbng d\u1eabn L\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng\u00a0b\u1eb1ng h\u00e0m<\/h3>\n
![\"loc-du-lieu-trung-trong-excel-12\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/loc-du-lieu-trung-trong-excel-12.jpg.webp)
<\/picture><\/p>\n=IF(ISNA(VLOOKUP(A2, Sheet1!A:C, 1, 0)), \"Unique\", \"Duplicate\")<\/code><\/strong><\/p>\n![\"Cach-loc-du-lieu-trung-trong-excel-4\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/Cach-loc-du-lieu-trung-trong-excel.jpg.webp)
<\/picture><\/p>\nM\u1ed9t s\u1ed1 l\u01b0u \u00fd khi l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel ch\u00ednh x\u00e1c<\/h2>\n
\n
K\u1ebft lu\u1eadn<\/h2>\n
\n