{"id":914,"date":"2012-01-16T02:40:58","date_gmt":"2012-01-16T02:40:58","guid":{"rendered":"http:\/\/congnghepc.com\/2012\/01\/16\/ms-excel-loc-cac-ban-ghi-trung-lap-trong-excel-2007\/"},"modified":"2012-01-16T02:40:58","modified_gmt":"2012-01-16T02:40:58","slug":"ms-excel-loc-cac-ban-ghi-trung-lap-trong-excel-2007","status":"publish","type":"post","link":"https:\/\/tapchicntt.com\/ms-excel-loc-cac-ban-ghi-trung-lap-trong-excel-2007\/","title":{"rendered":"MS Excel: L\u1ecdc c\u00e1c b\u1ea3n ghi tr\u00f9ng l\u1eb7p trong Excel 2007"},"content":{"rendered":"<p>\n\tV&iacute; d\u1ee5:<\/p>\n<p class=\"slideTable\" style=\"text-align: center;\">\n\t<span class=\"_lightBox\"><img decoding=\"async\" alt=\"L\u1ecdc c\u00e1c b\u1ea3n ghi tr\u00f9ng l\u1eb7p trong Excel 2007\" src=\"http:\/\/dl.dropbox.com\/u\/1552467\/forum\/2012\/loc-ban-ghi-trung-lap-trong-excel\/Excel1.jpg\" style=\"border-width: 0px; border-style: solid; width: 600px; height: 338px;\" \/><\/span><\/p>\n<p>\n\tC&aacute;c d&ograve;ng b&ocirc;i m&agrave;u \u0111\u1ecf c&oacute; d\u1eef li\u1ec7u tr&ugrave;ng tr&ecirc;n tr\u01b0\u1eddng <em>T\u1edc BD, S\u1ed0 TH\u1eecA<\/em>. Tr\u01b0\u1eddng <em>H\u1ecc T&Ecirc;N 1: Nguy\u1ec5n Ho&agrave;ng An<\/em> c&oacute; 2 d&ograve;ng b\u1ea3n ghi ch\u1ee9a c&ugrave;ng th&ocirc;ng tin v\u1ec1 <em>T\u1edc BD, S\u1ed0 TH\u1eecA<\/em>.<\/p>\n<p class=\"slideTable\" style=\"text-align: center;\">\n\t<span class=\"_lightBox\"><img decoding=\"async\" alt=\"L\u1ecdc c\u00e1c b\u1ea3n ghi tr\u00f9ng l\u1eb7p trong Excel 2007\" src=\"http:\/\/dl.dropbox.com\/u\/1552467\/forum\/2012\/loc-ban-ghi-trung-lap-trong-excel\/Excel2.jpg\" style=\"border-width: 0px; border-style: solid; width: 600px; height: 338px;\" \/><\/span><\/p>\n<p>\n\tCh\u1ee9c n\u0103ng n&agrave;y s\u1ebd l\u1ecdc b\u1ecf b\u1edbt c&aacute;c d&ograve;ng b\u1ea3n ghi tr&ugrave;ng l\u1eb7p th&ocirc;ng tin:<\/p>\n<p>\n\t\u0110\u1ea7u ti&ecirc;n, b\u1ea1n ch\u1ecdn v&ugrave;ng c\u1ea7n l\u1ecdc d\u1eef li\u1ec7u, \u1edf \u0111&acirc;y l&agrave; t\u1eeb <strong>A1:J21<\/strong>, ch\u1ecdn menu <strong>Data <\/strong>-&gt; n&uacute;t <strong>Remove Duplicate<\/strong><\/p>\n<p style=\"text-align: center;\">\n\t<img decoding=\"async\" alt=\"\" src=\"http:\/\/dl.dropbox.com\/u\/1552467\/forum\/2012\/loc-ban-ghi-trung-lap-trong-excel\/Excel7.jpg\" style=\"width: 550px; height: 110px;\" \/><\/p>\n<p>\n\tTrong h\u1ed9p tho\u1ea1i <em>Remove Duplicate<\/em>, c&aacute;c b\u1ea1n s\u1ebd th\u1ea5y 2 n&uacute;t l\u1ec7nh:<\/p>\n<ul>\n<li>\n\t\t<em>Select All<\/em>: \u0111\u1ec3 ch\u1ecdn t\u1ea5t c\u1ea3 c&aacute;c tr\u01b0\u1eddng trong b\u1ea3ng d\u1eef li\u1ec7u<\/li>\n<li>\n\t\t<em>Unselect All<\/em>: h\u1ee7y ch\u1ecdn t\u1ea5t c\u1ea3 c&aacute;c tr\u01b0\u1eddng trong b\u1ea3ng d\u1eef li\u1ec7u<\/li>\n<\/ul>\n<p>\n\tN&uacute;t check <em>My data has header<\/em>: n\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n c&oacute; ho\u1eb7c kh&ocirc;ng c&oacute; c&aacute;c \u0111\u1eb7t t&ecirc;n c&aacute;c tr\u01b0\u1eddng, n\u1ebfu c&oacute; \u0111\u1eb7t t&ecirc;n tr\u01b0\u1eddng m&agrave; kh&ocirc;ng d\u1ea5u ch\u1ecdn ki\u1ec3m tra n&uacute;t n&agrave;y th&igrave; c&aacute;c tr\u01b0\u1eddng s\u1ebd th&agrave;nh th\u1ee9 t\u1ef1 c&aacute;c c\u1ed9t theo ABC<\/p>\n<p style=\"text-align: center;\">\n\t<img decoding=\"async\" alt=\"L\u1ecdc c\u00e1c b\u1ea3n ghi tr\u00f9ng l\u1eb7p trong Excel 2007\" src=\"http:\/\/dl.dropbox.com\/u\/1552467\/forum\/2012\/loc-ban-ghi-trung-lap-trong-excel\/Excel3.jpg\" \/><\/p>\n<p>\n\tN\u1ebfu c&oacute; t&ecirc;n tr\u01b0\u1eddng v&agrave; th\u1ef1c hi\u1ec7n \u0111&aacute;nh d\u1ea5u ki\u1ec3m tra v&agrave;o m\u1ee5c n&agrave;y th&igrave; t&ecirc;n tr\u01b0\u1eddng s\u1ebd hi\u1ec3n th\u1ecb.<\/p>\n<p style=\"text-align: center;\">\n\t<img decoding=\"async\" alt=\"L\u1ecdc c\u00e1c b\u1ea3n ghi tr\u00f9ng l\u1eb7p trong Excel 2007\" src=\"http:\/\/dl.dropbox.com\/u\/1552467\/forum\/2012\/loc-ban-ghi-trung-lap-trong-excel\/Excel4.jpg\" \/><\/p>\n<p>\n\tV&iacute; d\u1ee5 \u1edf \u0111&acirc;y \u0111\u1ec3 l\u1ecdc c&aacute;c th&ocirc;ng tin tr&ugrave;ng tr&ecirc;n tr\u01b0\u1eddng <em>T\u1edc BD, S\u1ed0 TH\u1eecA<\/em> ta th\u1ef1c hi\u1ec7n thao t&aacute;c:<\/p>\n<p>\n\t&#8211; Ch\u1ecdn n&uacute;t <strong>Unselect All<\/strong> \u0111\u1ec3 h\u1ee7y ch\u1ecdn<\/p>\n<p>\n\t&#8211; \u0110&aacute;nh d\u1ea5u ch\u1ecdn v&agrave;o 2 tr\u01b0\u1eddng <strong>T\u1edc B\u0110, S\u1ed0 TH\u1eecA<\/strong>, ti\u1ebfp theo ch\u1ecdn <strong>OK <\/strong><\/p>\n<p style=\"text-align: center;\">\n\t<img decoding=\"async\" alt=\"L\u1ecdc c\u00e1c b\u1ea3n ghi tr\u00f9ng l\u1eb7p trong Excel 2007\" src=\"http:\/\/dl.dropbox.com\/u\/1552467\/forum\/2012\/loc-ban-ghi-trung-lap-trong-excel\/Excel5.jpg\" \/><\/p>\n<p>\n\tCh\u01b0\u01a1ng tr&igrave;nh s\u1ebd l\u1ecdc c&aacute;c b\u1ea3n ghi tr&ugrave;ng theo k\u1ebft qu\u1ea3 \u1edf b\u1ea3ng d\u1eef li\u1ec7u sau:<\/p>\n<p class=\"slideTable\" style=\"text-align: center;\">\n\t<span class=\"_lightBox\"><img decoding=\"async\" alt=\"L\u1ecdc c\u00e1c b\u1ea3n ghi tr\u00f9ng l\u1eb7p trong Excel 2007\" src=\"http:\/\/dl.dropbox.com\/u\/1552467\/forum\/2012\/loc-ban-ghi-trung-lap-trong-excel\/Excel6.jpg\" style=\"border-width: 0px; border-style: solid; height: 338px;\" \/><\/span><\/p>\n<p>\n\tC&aacute;c b\u1ea1n s\u1ebd th\u1ea5y \u1edf \u0111&acirc;y c&oacute; t\u1ed5ng c\u1ed9ng 20 d&ograve;ng b\u1ea3n ghi, sau khi th\u1ef1c hi\u1ec7n cho k\u1ebft qu\u1ea3 c&oacute; 03 b\u1ea3n ghi tr&ugrave;ng s\u1ebd lo\u1ea1i b\u1ecf v&agrave; c&ograve;n 17 b\u1ea3n ghi.<\/p>\n<p>\n\tHy v\u1ecdng v\u1edbi th\u1ee7 thu\u1eadt nh\u1ecf tr&ecirc;n c&aacute;c b\u1ea1n s\u1ebd th\u1ea5y hi\u1ec7u qu\u1ea3 khi l\u1ecdc c&aacute;c b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn, th\u1eddi gian th\u1ef1c hi\u1ec7n r\u1ea5t nhanh.<\/p>\n<p style=\"text-align: right;\">\n\t<i>V\u0169 Ho&agrave;ng Th\u01b0\u01a1ng<\/i><\/p>\n","protected":false},"excerpt":{"rendered":"<p class=\"slideTable\" style=\"text-align: center;\">\n\t<span class=\"_lightBox\"><img decoding=\"async\" alt=\"L\u1ecdc c\u00e1c b\u1ea3n ghi tr\u00f9ng l\u1eb7p trong Excel 2007\" src=\"http:\/\/www.quantrimang.com.vn\/photos\/image\/112011\/24\/Excel1.jpg\" style=\"border-width: 0px; border-style: solid; width: 100px; height: 56px; margin-left: 5px; margin-right: 5px; float: left;\" \/><\/span><\/p>\n<p>\n\tTrong th\u1ef1c t\u1ebf ch&uacute;ng ta th\u01b0\u1eddng xuy&ecirc;n ph\u1ea3i g\u1eb7p c&aacute;c tr\u01b0\u1eddng h\u1ee3p tr&ugrave;ng l\u1eb7p d\u1eef li\u1ec7u trong m\u1ed9t danh s&aacute;ch ho\u1eb7c m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u v&agrave; th\u01b0\u1eddng l&agrave;m th\u1ee7 c&ocirc;ng l&agrave; d&ograve; t&igrave;m th&ocirc;ng tin t\u1eebng b\u1ea3n ghi m\u1ed9t v&agrave; lo\u1ea1i b\u1ecf ch&uacute;ng, c&ocirc;ng vi\u1ec7c n&agrave;y c&oacute; th\u1ec3 m\u1ea5t r\u1ea5t nhi\u1ec1u th\u1eddi gian v&agrave; d\u1ec5 sai s&oacute;t, nh\u1ea7m l\u1eabn \u0111\u1ed1i v\u1edbi d\u1eef li\u1ec7u h&agrave;ng ng&agrave;n b\u1ea3n ghi. \u0110\u1ec3 l&agrave;m cho c&ocirc;ng vi\u1ec7c n&agrave;y d\u1ec5 d&agrave;ng h\u01a1n, c&aacute;c b\u1ea1n c&oacute; th\u1ec3 s\u1eed d\u1ee5ng c&ocirc;ng c\u1ee5 l\u1ecdc b\u1ecf c&aacute;c b\u1ea3n ghi tr&ugrave;ng l\u1eb7p m\u1ed9t c&aacute;ch nhanh nh&oacute;ng, \u0111\u01a1n gi\u1ea3n v&agrave; hi\u1ec7u qu\u1ea3 nh\u1ea5t.<\/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-914","post","type-post","status-publish","format-standard","hentry","category-van-phong"],"views":359,"_links":{"self":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/posts\/914","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=914"}],"version-history":[{"count":0,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/posts\/914\/revisions"}],"wp:attachment":[{"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/media?parent=914"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/categories?post=914"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tapchicntt.com\/rest-api\/wp\/v2\/tags?post=914"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}