{"id":24489,"date":"2021-05-13T09:03:30","date_gmt":"2021-05-13T02:03:30","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24489"},"modified":"2024-10-29T23:07:05","modified_gmt":"2024-10-29T16:07:05","slug":"ham-loc-du-lieu-trung-nhau-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-loc-du-lieu-trung-nhau-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng nhau trong Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"24489\" class=\"elementor elementor-24489\" data-elementor-settings=\"[]\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-44fde0a2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"44fde0a2\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-299b0d56\" data-id=\"299b0d56\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-620269 elementor-widget elementor-widget-text-editor\" data-id=\"620269\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t\tC\u00e1c d\u1eef li\u1ec7u tr\u00f9ng nhau trong Excel \u0111\u00f4i khi c\u00f3 th\u1ec3 l\u00e0 v\u1ea5n \u0111\u1ec1 khi\u1ebfn nhi\u1ec1u ng\u01b0\u1eddi \u0111au \u0111\u1ea7u, nh\u1ea5t l\u00e0 khi ch\u00fang ta \u0111ang l\u00e0m vi\u1ec7c tr\u00ean b\u1ea3ng t\u00ednh ch\u1ee9a l\u01b0\u1ee3ng d\u1eef li\u1ec7u nhi\u1ec1u. \u0110\u1ec3 kh\u1eafc ph\u1ee5c t\u00ecnh tr\u1ea1ng n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <strong>h\u00e0m l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng nhau <\/strong>trong Excel \u0111\u1ec3 l\u1ecdc v\u00e0 x\u00f3a c\u00e1c d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng n\u00e0y.\r\n\r\nN\u1ebfu b\u1ea1n v\u1eabn ch\u01b0a bi\u1ebft c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng nhau nh\u01b0 th\u1ebf n\u00e0o, v\u1eady th\u00ec h\u00e3y tham kh\u1ea3o b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u00f9ng Ben Computer nh\u00e9.\r\n<h2><strong>H\u00e0m l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng nhau trong Excel<\/strong><\/h2>\r\nC\u00e1c d\u1eef li\u1ec7u tr\u00f9ng nhau trong Excel c\u00f3 th\u1ec3 l\u00e0 c\u00e1c d\u1eef li\u1ec7u trong c\u00f9ng m\u1ed9t c\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t, ho\u1eb7c c\u00f3 th\u1ec3 l\u00e0 to\u00e0n b\u1ed9 h\u00e0ng trong b\u1ea3ng t\u00ednh.\r\n<h3><strong>L\u1ecdc v\u00e0 \u0111\u00e1nh d\u1ea5u d\u1eef li\u1ec7u tr\u00f9ng nhau trong c\u1ed9t Excel<\/strong><\/h3>\r\n\u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng nhau trong m\u1ed9t c\u1ed9t Excel, b\u1ea1n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:\r\n\r\n<strong><em>B\u01b0\u1edbc 1:<\/em>\u00a0<\/strong>\u0110\u1ea7u ti\u00ean b\u00f4i \u0111en, ch\u1ecdn ph\u1ea7n d\u1eef li\u1ec7u c\u1ea7n l\u1ecdc trong b\u1ea3ng t\u00ednh.\r\n\r\n<img loading=\"lazy\" decoding=\"async\" width=\"129\" height=\"299\" class=\"aligncenter wp-image-16934 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-5.png\" alt=\"h\u00e0m l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng nhau\" \/>\r\n\r\n<strong><em>B\u01b0\u1edbc 2:<\/em>\u00a0<\/strong>Truy c\u1eadp<strong>\u00a0Home<\/strong>\u00a0=&gt;\u00a0<strong>Conditional Formatting<\/strong>\u00a0=&gt;\u00a0<strong>Highlight Cell Rules<\/strong>\u00a0=&gt;\u00a0<strong>Duplicate Values.<\/strong>\r\n\r\n<img loading=\"lazy\" decoding=\"async\" width=\"380\" height=\"421\" class=\"aligncenter wp-image-16935 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-5.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-5-271x300.png 271w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-5.png 380w\" alt=\"l\u1ecdc tr\u00f9ng excel\" \/>\r\n\r\n<strong><em>B\u01b0\u1edbc 3:<\/em><\/strong>\u00a0L\u00fac n\u00e0y tr\u00ean m\u00e0n h\u00ecnh s\u1ebd hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i Duplicate Values, t\u1ea1i \u0111\u00e2y trong<strong>\u00a0menu Duplicate<\/strong>\u00a0\u1edf khung b\u00ean tr\u00e1i, click ch\u1ecdn<strong>\u00a0Duplicate.<\/strong>\u00a0Ch\u1ecdn m\u1ed9t m\u00e0u m\u00e0 b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u, l\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng nhau.\r\n\r\n<img loading=\"lazy\" decoding=\"async\" width=\"392\" height=\"148\" class=\"aligncenter wp-image-16936 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-4.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-4-300x113.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-4.png 392w\" alt=\"c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong excel\" \/>\r\n\r\n<strong>H\u00e0m l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng nhau<\/strong> v\u00e0 \u0111\u00e1nh d\u1ea5u c\u00e1c d\u1eef li\u1ec7u n\u00e0y nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:\r\n\r\n<img loading=\"lazy\" decoding=\"async\" width=\"128\" height=\"180\" class=\"aligncenter wp-image-16937 size-jnews-360x180\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-5-128x180.png\" alt=\"l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong excel\" \/>\r\n<h3><strong>L\u1ecdc v\u00e0 \u0111\u00e1nh d\u1ea5u d\u1eef li\u1ec7u tr\u00f9ng nhau trong h\u00e0ng trong Excel<\/strong><\/h3>\r\nC\u00e1c b\u01b0\u1edbc \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng nhau trong c\u00e1c h\u00e0ng trong Excel ph\u1ee9c t\u1ea1p h\u01a1n so v\u1edbi l\u1ecdc d\u1eef li\u1ec7u trong c\u00e1c c\u1ed9t.\r\n\r\nCho b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 sau:\r\n\r\n<img loading=\"lazy\" decoding=\"async\" width=\"723\" height=\"326\" class=\"aligncenter wp-image-16938 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/5-4.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/5-4-300x135.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/5-4.png 723w\" alt=\"c\u00e1ch l\u1ecdc tr\u00f9ng trong excel\" \/>\r\n\r\nTh\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:\r\n\r\nTrong c\u1ed9t li\u1ec1n k\u1ec1, ch\u00fang ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c, h\u00e0m Excel d\u01b0\u1edbi \u0111\u00e2y:\r\n\r\n<strong>= A2&amp;B2&amp;C2&amp;D2<\/strong>\r\n\r\nK\u00e9o c\u00f4ng th\u1ee9c n\u00e0y xu\u1ed1ng t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng trong b\u1ea3ng t\u00ednh. C\u00f4ng th\u1ee9c Excel tr\u00ean k\u1ebft h\u1ee3p t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb \u00f4 d\u01b0\u1edbi d\u1ea1ng m\u1ed9t chu\u1ed7i duy nh\u1ea5t. Ngo\u00e0i ra ch\u00fang ta c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Concatenate \u0111\u1ec3 n\u1ed1i, k\u1ebft h\u1ee3p c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n.\r\n\r\n<img loading=\"lazy\" decoding=\"async\" width=\"498\" height=\"276\" class=\"aligncenter wp-image-16939 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/6-3.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/6-3-300x166.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/6-3.png 498w\" alt=\"l\u1ecdc tr\u00f9ng trong excel\" \/>\r\nB\u1eb1ng c\u00e1ch tr\u00ean ch\u00fang ta t\u1ea1o \u0111\u01b0\u1ee3c m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n duy nh\u1ea5t cho m\u1ed7i h\u00e0ng. N\u1ebfu c\u00f3 h\u00e0ng n\u00e0o ch\u1ee9a d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng l\u1eb7p, c\u00e1c chu\u1ed7i \u0111\u01b0\u1ee3c t\u1ea1o s\u1ebd gi\u1ed1ng nhau.\r\n\r\nTi\u1ebfp theo th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng nhau trong Excel:\r\n\r\nCh\u1ecdn ph\u1ea1m vi c\u00f3 c\u00e1c chu\u1ed7i k\u1ebft h\u1ee3p (E2: E16 trong v\u00ed d\u1ee5 n\u00e0y).\r\n\r\n<strong><em>B\u01b0\u1edbc 1<\/em>:<\/strong> Ch\u1ecdn ph\u1ea1m vi c\u00f3 c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c n\u1ed1i b\u1eb1ng h\u00e0m Excel \u1edf tr\u00ean, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 E2 : E16.\r\n\r\n<strong><em>B\u01b0\u1edbc 2:<\/em>\u00a0<\/strong>Ti\u1ebfp theo truy c\u1eadp\u00a0<strong>Home<\/strong>\u00a0=&gt;\u00a0<strong>Conditional Formatting<\/strong>\u00a0=&gt;\u00a0<strong>Highlight Cell Rules<\/strong>\u00a0=&gt;\u00a0<strong>Duplicate Values.<\/strong>\r\n\r\n<strong><em>B\u01b0\u1edbc 3:<\/em>\u00a0<\/strong>Tr\u00ean h\u1ed9p tho\u1ea1i Duplicate Values hi\u1ec3n th\u1ecb tr\u00ean m\u00e0n h\u00ecnh, ch\u1ecdn gi\u00e1 tr\u1ecb l\u00e0\u00a0<strong>Duplicate<\/strong>\u00a0t\u1eeb menu v\u00e0 ch\u1ec9 \u0111\u1ecbnh m\u00e0u m\u00e0 b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb, d\u1eef li\u1ec7u tr\u00f9ng nhau.\r\n\r\nTrong h\u1ed9p tho\u1ea1i Gi\u00e1 tr\u1ecb Tr\u00f9ng l\u1eb7p, h\u00e3y \u0111\u1ea3m b\u1ea3o r\u1eb1ng B\u1ea3n sao \u0111\u01b0\u1ee3c ch\u1ecdn v\u00e0 sau \u0111\u00f3 ch\u1ec9 \u0111\u1ecbnh m\u00e0u m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p.\r\n\r\nL\u00fac n\u00e0y c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng nhau trong c\u1ed9t E s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u v\u00e0 l\u00e0m n\u1ed5i b\u1eadt.\r\n\r\n<img loading=\"lazy\" decoding=\"async\" width=\"566\" height=\"300\" class=\"aligncenter wp-image-16940 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/7-3.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/7-3-300x159.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/7-3.png 566w\" alt=\"h\u00e0m l\u1ecdc tr\u00f9ng\" \/>\r\n\r\nTrong v\u00ed d\u1ee5 tr\u00ean, ch\u00fang ta ch\u1ec9 l\u1ecdc v\u00e0 \u0111\u00e1nh d\u1ea5u c\u00e1c d\u1eef li\u1ec7u l\u00e0 c\u00e1c chu\u1ed7i m\u00e0 ch\u00fang ta \u0111\u00e3 t\u1ea1o. \u0110\u1ec3 l\u1ecdc v\u00e0 \u0111\u00e1nh d\u1ea5u t\u1ea5t c\u1ea3 c\u00e1c d\u1eef li\u1ec7u trong t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng tr\u00f9ng nhau, b\u1ea1n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:\r\n\r\nTrong c\u1ed9t li\u1ec1n k\u1ec1, nh\u1eadp c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y:\r\n\r\n<strong>=A2&amp;B2&amp;C2&amp;D2<\/strong>\r\n\r\nK\u00e9o c\u00f4ng th\u1ee9c tr\u00ean xu\u1ed1ng t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng trong b\u1ea3ng t\u00ednh. C\u00f4ng th\u1ee9c n\u00e0y n\u1ed1i, k\u1ebft h\u1ee3p t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb \u00f4 d\u01b0\u1edbi d\u1ea1ng m\u1ed9t chu\u1ed7i duy nh\u1ea5t.\r\n\r\nCh\u1ecdn v\u00f9ng d\u1eef li\u1ec7u t\u1eeb A2: D16.\r\n\r\n<img loading=\"lazy\" decoding=\"async\" width=\"498\" height=\"276\" class=\"aligncenter wp-image-16941 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/8-2.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/8-2-300x166.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/8-2.png 498w\" alt=\"h\u00e0m l\u1ecdc tr\u00f9ng trong excel\" \/>\r\n\r\nTi\u1ebfp theo truy c\u1eadp\u00a0<strong>Home<\/strong>\u00a0=&gt;\u00a0<strong>Conditional Formatting<\/strong>\u00a0=&gt;\u00a0<strong>New Rule.<\/strong>\r\n\r\n<img loading=\"lazy\" decoding=\"async\" width=\"194\" height=\"376\" class=\"aligncenter wp-image-16943 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/9-2.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/9-2-155x300.png 155w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/9-2.png 194w\" alt=\"c\u00e1ch l\u1ecdc t\u00ean tr\u00f9ng trong excel\" \/>\r\nTr\u00ean h\u1ed9p tho\u1ea1i New Formatting Rule, b\u1ea1n click ch\u1ecdn\u00a0<strong>Use a formula to determine which cells to format.<\/strong>\r\n\r\nNh\u1eadp c\u00f4ng th\u1ee9c, h\u00e0m Countif d\u01b0\u1edbi \u0111\u00e2y v\u00e0o khung b\u00ean\u00a0<strong>Format values where this formula is true:<\/strong>\r\n\r\n<strong>=COUNTIF($E$2:$E$16,$E2)&gt;1<\/strong>\r\n\r\n<img loading=\"lazy\" decoding=\"async\" width=\"393\" height=\"379\" class=\"aligncenter wp-image-16944 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/10.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/10-300x289.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/10.png 393w\" alt=\"c\u00e1ch l\u1ecdc tr\u00f9ng t\u00ean trong excel\" \/>\r\n\r\nCu\u1ed1i c\u00f9ng click ch\u1ecdn Format r\u1ed3i click ch\u1ecdn\u00a0<strong>OK.<\/strong>\u00a0C\u00f4ng th\u1ee9c h\u00e0m Excel tr\u00ean s\u1ebd l\u1ecdc v\u00e0 \u0111\u00e1nh d\u1ea5u t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng c\u00f3 d\u1eef li\u1ec7u tr\u00f9ng nhau.\r\n\r\n<img loading=\"lazy\" decoding=\"async\" width=\"370\" height=\"298\" class=\"aligncenter wp-image-16945 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/11.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/11-300x242.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/11.png 370w\" alt=\"l\u1ecdc tr\u00f9ng\" \/>\r\n<h2><strong>X\u00f3a d\u1eef li\u1ec7u tr\u00f9ng nhau trong Excel<\/strong><\/h2>\r\n<h3><strong>X\u00f3a d\u1eef li\u1ec7u tr\u00f9ng nhau trong m\u1ed9t c\u1ed9t trong Excel<\/strong><\/h3>\r\n\u0110\u1ec3 x\u00f3a c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng nhau trong m\u1ed9t c\u1ed9t trong Excel, b\u1ea1n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:\r\n\r\n<strong><em>B\u01b0\u1edbc 1:<\/em>\u00a0<\/strong>Ch\u1ecdn d\u1eef li\u1ec7u tr\u00f9ng nhau m\u00e0 b\u1ea1n mu\u1ed1n x\u00f3a.\r\n\r\n<strong><em>B\u01b0\u1edbc 2:<\/em>\u00a0<\/strong>Truy c\u1eadp\u00a0<strong>Data<\/strong>\u00a0=&gt;<strong>\u00a0Data Tools<\/strong>\u00a0=&gt;\u00a0<strong>Remove Duplicates.<\/strong>\r\n\r\n<img loading=\"lazy\" decoding=\"async\" width=\"455\" height=\"137\" class=\"aligncenter wp-image-16946 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/12.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/12-300x90.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/12.png 455w\" alt=\"12 - C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng nhau trong Excel - Ben Computer\" \/>\r\n\r\n<strong><em>B\u01b0\u1edbc 3:<\/em>\u00a0<\/strong>Tr\u00ean h\u1ed9p tho\u1ea1i Remove Duplicates hi\u1ec3n th\u1ecb tr\u00ean m\u00e0n h\u00ecnh:\r\n<ul>\r\n \t<li>N\u1ebfu d\u1eef li\u1ec7u b\u1ea1n ch\u1ecdn c\u00f3 ch\u1ee9a ti\u00eau \u0111\u1ec1, \u0111\u00e1nh t\u00edch ch\u1ecdn t\u00f9y ch\u1ecdn <strong>My data has headers.<\/strong><\/li>\r\n \t<li>\u0110\u1ea3m b\u1ea3o c\u1ed9t \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn (trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u1ec9 c\u00f3 m\u1ed9t c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ecdn) r\u1ed3i click ch\u1ecdn <strong>OK<\/strong>\u00a0\u0111\u1ec3 \u00e1p d\u1ee5ng thay \u0111\u1ed5i.<\/li>\r\n<\/ul>\r\n<img loading=\"lazy\" decoding=\"async\" width=\"466\" height=\"309\" class=\"aligncenter wp-image-16947 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/13.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/13-300x199.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/13.png 466w\" alt=\"H\u00e0m x\u00f3a d\u1eef li\u1ec7u tr\u00f9ng nhau trong Excel\" \/>\r\n<h3><strong>X\u00f3a d\u1eef li\u1ec7u h\u00e0ng tr\u00f9ng nhau trong Excel<\/strong><\/h3>\r\nTh\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:\r\n\r\n<strong><em>B\u01b0\u1edbc 1:<\/em>\u00a0<\/strong>Ch\u1ecdn to\u00e0n b\u1ed9 d\u1eef li\u1ec7u.\r\n\r\n<strong><em>B\u01b0\u1edbc 2:<\/em><\/strong>\u00a0Truy c\u1eadp\u00a0<strong>Data<\/strong>\u00a0=&gt;\u00a0<strong>Data Tools<\/strong>\u00a0=&gt;\u00a0<strong>Remove Duplicates.<\/strong>\r\n\r\n<img loading=\"lazy\" decoding=\"async\" width=\"455\" height=\"137\" class=\"aligncenter wp-image-16948 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/14.png\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/14-300x90.png 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/14.png 455w\" alt=\"14 - C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng nhau trong Excel - Ben Computer\" \/>\r\n<strong><em>B\u01b0\u1edbc 3<\/em>:<\/strong> Tr\u00ean h\u1ed9p tho\u1ea1i Remove Duplicates hi\u1ec3n th\u1ecb tr\u00ean m\u00e0n h\u00ecnh:\r\n<ul>\r\n \t<li>N\u1ebfu d\u1eef li\u1ec7u b\u1ea1n ch\u1ecdn c\u00f3 ch\u1ee9a ti\u00eau \u0111\u1ec1, \u0111\u00e1nh t\u00edch ch\u1ecdn t\u00f9y ch\u1ecdn <strong>My data has headers.<\/strong><\/li>\r\n \t<li>\u0110\u1ea3m b\u1ea3o b\u1ea1n \u0111\u00e3 ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t r\u1ed3i click ch\u1ecdn <strong>OK<\/strong>\u00a0\u0111\u1ec3 \u00e1p d\u1ee5ng thay \u0111\u1ed5i.<\/li>\r\n<\/ul>\r\nNh\u01b0 v\u1eady b\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y Ben Computer v\u1eeba h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng nhau trong Excel<\/strong>. Hy v\u1ecdng v\u1edbi nh\u1eefng th\u1ee7 thu\u1eadt tr\u00ean \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n l\u00e0m ch\u1ee7 \u0111\u01b0\u1ee3c h\u00e0m Excel n\u00e0y. Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!\r\n\r\nXem th\u00eam b\u00e0i vi\u1ebft c\u00f9ng ch\u1ee7 \u0111\u1ec1:\r\n<ul>\r\n \t<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-random-trong-excel\/\">H\u00e0m Random trong Excel<\/a><\/li>\r\n \t<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-trim-trong-excel\/\">H\u00e0m Trim trong Excel<\/a><\/li>\r\n \t<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-tru-trong-excel\/\">H\u00e0m tr\u1eeb trong Excel<\/a><\/li>\r\n \t<li><a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-find-trong-excel\/\">H\u00e0m Find trong Excel<\/a><\/li>\r\n<\/ul>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-69b0f8ad elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"69b0f8ad\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;gradient&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-custom\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-4f5cab13\" data-id=\"4f5cab13\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-541d38e7 elementor--h-position-center elementor--v-position-middle elementor-arrows-position-inside elementor-pagination-position-inside elementor-widget elementor-widget-slides\" data-id=\"541d38e7\" data-element_type=\"widget\" data-settings=\"{&quot;navigation&quot;:&quot;both&quot;,&quot;autoplay&quot;:&quot;yes&quot;,&quot;pause_on_hover&quot;:&quot;yes&quot;,&quot;pause_on_interaction&quot;:&quot;yes&quot;,&quot;autoplay_speed&quot;:5000,&quot;infinite&quot;:&quot;yes&quot;,&quot;transition&quot;:&quot;slide&quot;,&quot;transition_speed&quot;:500}\" data-widget_type=\"slides.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-swiper\">\n\t\t\t<div class=\"elementor-slides-wrapper elementor-main-swiper swiper-container\" dir=\"ltr\" data-animation=\"fadeInUp\">\n\t\t\t\t<div class=\"swiper-wrapper elementor-slides\">\n\t\t\t\t\t<div class=\"elementor-repeater-item-e2dec7a swiper-slide\"><div class=\"swiper-slide-bg\"><\/div><div class=\"swiper-slide-inner\" ><div class=\"swiper-slide-contents\"><\/div><\/div><\/div><div class=\"elementor-repeater-item-7449ca5 swiper-slide\"><div class=\"swiper-slide-bg\"><\/div><div class=\"swiper-slide-inner\" ><div class=\"swiper-slide-contents\"><\/div><\/div><\/div><div class=\"elementor-repeater-item-31fcf00 swiper-slide\"><div class=\"swiper-slide-bg\"><\/div><div class=\"swiper-slide-inner\" ><div class=\"swiper-slide-contents\"><\/div><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"swiper-pagination\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-swiper-button elementor-swiper-button-prev\">\n\t\t\t\t\t\t\t<i class=\"eicon-chevron-left\" aria-hidden=\"true\"><\/i>\n\t\t\t\t\t\t\t<span class=\"elementor-screen-only\">Previous<\/span>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"elementor-swiper-button elementor-swiper-button-next\">\n\t\t\t\t\t\t\t<i class=\"eicon-chevron-right\" aria-hidden=\"true\"><\/i>\n\t\t\t\t\t\t\t<span class=\"elementor-screen-only\">Next<\/span>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-25d90343 elementor-button-success elementor-align-center elementor-widget elementor-widget-button\" data-id=\"25d90343\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a href=\"https:\/\/zalo.me\/0978.660.995\" target=\"_blank\" class=\"elementor-button-link elementor-button elementor-size-xl\" role=\"button\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Zalo: 0978.660.995<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-54b6c99a\" data-id=\"54b6c99a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-76584e1f elementor-widget elementor-widget-text-editor\" data-id=\"76584e1f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t\t<p class=\"mb-3\"><span style=\"color: #ffffff;\"><span style=\"font-size: 20px;\"><span style=\"font-size: 22px;\"><strong>M\u00e0n h\u00ecnh m\u00e1y t\u00ednh Dell Ultrasharp U2424H Professional<\/strong><\/span><br \/><\/span>\u2611 Ki\u1ec3u d\u00e1ng m\u00e0n h\u00ecnh: Ph\u1eb3ngT\u1ec9 l\u1ec7 khung h\u00ecnh: 16:9K\u00edch th\u01b0\u1edbc m\u1eb7c \u0111\u1ecbnh: 23.8 inch<\/span><br \/><span style=\"color: #ffffff;\">\u2611 C\u00f4ng ngh\u1ec7 t\u1ea5m n\u1ec1n: IPS<\/span><br \/><span style=\"color: #ffffff;\">\u2611 Ph\u00e2n gi\u1ea3i \u0111i\u1ec3m \u1ea3nh: FHD &#8211; 1920 x 1080<\/span><br \/><span style=\"color: #ffffff;\">\u2611 \u0110\u1ed9 s\u00e1ng hi\u1ec3n th\u1ecb: 250 Nits cd\/m2<\/span><br \/><span style=\"color: #ffffff;\">\u2611 T\u1ea7n s\u1ed1 qu\u00e9t m\u00e0n: 120 Hz (Hertz)<\/span><br \/><span style=\"color: #ffffff;\">\u2611 Th\u1eddi gian \u0111\u00e1p \u1ee9ng: 8 ms (Normal) &#8211; 5 ms (Fast)<\/span><br \/><span style=\"color: #ffffff;\">\u2611 Ch\u1ec9 s\u1ed1 m\u00e0u s\u1eafc: 16.7 tri\u1ec7u m\u00e0u &#8211; s100% sRGB, 100% BT.709, 85% DCI-P3, Delta E &lt; 2 (average) (sRGB and BT.709)<\/span><br \/><span style=\"color: #ffffff;\">\u2611 H\u1ed7 tr\u1ee3 ti\u00eau chu\u1ea9n: VESA (100 mm x 100 mm), DRR for Microsoft Windows, TMDS as per specified in HDMI 1.4<\/span><br \/><span style=\"color: #ffffff;\">\u2611 C\u1ed5ng c\u1eafm hi\u1ec3n th\u1ecb: 1x DisplayPort 1.4 (DRR for Microsoft Windows) (HDCP 1.4), 1x HDMI (HDCP 1.4) (supports up to FHD 1920 x 1080 120Hz TMDS as per specified in HDMI 1.4), 1x DisplayPort 1.4 (Out) with MST (HDCP 1.4)<\/span><\/p><div class=\"cf-hero-bts-img-wrap\"><div class=\"heroTech__title\"><span style=\"color: #ffffff; font-size: 24px;\"><b>&#8211; B\u1ea3o h\u00e0nh 3 n\u0103m ch\u00ednh h\u00e3ng<\/b><\/span><\/div><\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-623749ca elementor-widget elementor-widget-html\" data-id=\"623749ca\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<div id=\"getfly-optin-form-iframe-1730101126922\"><\/div> <script type=\"text\/javascript\"> (function(){ var r = window.document.referrer != \"\"? window.document.referrer: window.location.origin; var regex = \/(https?:\\\/\\\/.*?)\\\/\/g; var furl = regex.exec(r); r = furl ? furl[0] : r; var f = document.createElement(\"iframe\"); const url_string = new URLSearchParams(window.location.search); var utm_source, utm_campaign, utm_medium, utm_content, utm_term; if((!url_string.has('utm_source') || url_string.get('utm_source') == '') && document.cookie.match(new RegExp('utm_source' + '=([^;]+)')) != null){ r+= \"&\" +document.cookie.match(new RegExp('utm_source' + '=([^;]+)'))[0]; } else { r+= url_string.get('utm_source') != null ? \"&utm_source=\" + url_string.get('utm_source') : \"\";} if((!url_string.has('utm_campaign') || url_string.get('utm_campaign') == '') && document.cookie.match(new RegExp('utm_campaign' + '=([^;]+)')) != null){ r+= \"&\" +document.cookie.match(new RegExp('utm_campaign' + '=([^;]+)'))[0]; } else { r+= url_string.get('utm_campaign') != null ? \"&utm_campaign=\" + url_string.get('utm_campaign') : \"\";} if((!url_string.has('utm_medium') || url_string.get('utm_medium') == '') && document.cookie.match(new RegExp('utm_medium' + '=([^;]+)')) != null){ r+= \"&\" +document.cookie.match(new RegExp('utm_medium' + '=([^;]+)'))[0]; } else { r+= url_string.get('utm_medium') != null ? \"&utm_medium=\" + url_string.get('utm_medium') : \"\";} if((!url_string.has('utm_content') || url_string.get('utm_content') == '') && document.cookie.match(new RegExp('utm_content' + '=([^;]+)')) != null){ r+= \"&\" +document.cookie.match(new RegExp('utm_content' + '=([^;]+)'))[0]; } else { r+= url_string.get('utm_content') != null ? \"&utm_content=\" + url_string.get('utm_content') : \"\";} if((!url_string.has('utm_term') || url_string.get('utm_term') == '') && document.cookie.match(new RegExp('utm_term' + '=([^;]+)')) != null){ r+= \"&\" +document.cookie.match(new RegExp('utm_term' + '=([^;]+)'))[0]; } else { r+= url_string.get('utm_term') != null ? \"&utm_term=\" + url_string.get('utm_term') : \"\";} if((!url_string.has('utm_user') || url_string.get('utm_user') == '') && document.cookie.match(new RegExp('utm_user' + '=([^;]+)')) != null){ r+= \"&\" +document.cookie.match(new RegExp('utm_user' + '=([^;]+)'))[0]; } else { r+= url_string.get('utm_user') != null ? \"&utm_user=\" + url_string.get('utm_user') : \"\";} if((!url_string.has('utm_account') || url_string.get('utm_account') == '') && document.cookie.match(new RegExp('utm_account' + '=([^;]+)')) != null){ r+= \"&\" +document.cookie.match(new RegExp('utm_account' + '=([^;]+)'))[0]; } else { r+= url_string.get('utm_account') != null ? \"&utm_account=\" + url_string.get('utm_account') : \"\";} r+=\"&full_url=\"+encodeURIComponent(window.location.href); f.setAttribute(\"src\", \"https:\/\/ben.getflycrm.com\/api\/forms\/viewform\/?key=N4v6OqYsig1vvggogCRPv001lsicPpnuw9z0lwwCjvrECydSOy&referrer=\"+r); f.style.width = \"100%\";f.style.height = \"300px\";f.setAttribute(\"frameborder\",\"0\");f.setAttribute(\"marginheight\",\"0\"); f.setAttribute(\"marginwidth\",\"0\");var s = document.getElementById(\"getfly-optin-form-iframe-1730101126922\");s.appendChild(f); })(); <\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>C\u00e1c d\u1eef li\u1ec7u tr\u00f9ng nhau trong Excel \u0111\u00f4i khi c\u00f3 th\u1ec3 l\u00e0 v\u1ea5n \u0111\u1ec1 khi\u1ebfn nhi\u1ec1u ng\u01b0\u1eddi \u0111au \u0111\u1ea7u, nh\u1ea5t l\u00e0 khi ch\u00fang ta \u0111ang l\u00e0m vi\u1ec7c tr\u00ean b\u1ea3ng t\u00ednh ch\u1ee9a l\u01b0\u1ee3ng d\u1eef li\u1ec7u nhi\u1ec1u. \u0110\u1ec3 kh\u1eafc ph\u1ee5c t\u00ecnh tr\u1ea1ng n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng nhau trong Excel [&hellip;]<\/p>\n","protected":false},"author":39,"featured_media":24490,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-24489","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24489","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=24489"}],"version-history":[{"count":11,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24489\/revisions"}],"predecessor-version":[{"id":79720,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24489\/revisions\/79720"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/24490"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=24489"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=24489"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=24489"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}