Exclude duplicate data in the table in the table using Excel

If you use the cousin to organize the file habits, System Home Xiaobian recommends that you use Excel. The following small series can use the IF and COUNTIF functions in the Excel function to easily find the subtables from the summary table. Content. Importing the tile into the TXT first put the contents of the TXT file into the Excel worksheet. In this process, you need to use the "File → Open" command in Excel to separate the contents of the two TXT files into two worksheets of Excel, and put the TV series broadcasted by CCTV in Sheet1. Name list, a list of favorite TV show names placed in Sheet2, and a tag field name (Figure 1) added to Sheet1. After the two worksheets are created, the records in Sheet1 are compared with all the records in Sheet2. If the records in Sheet1 are found in Sheet2, the records in Sheet1 are marked. On “recorded”; if not found then marked “unrecorded”. So enter the formula in the C2 cell in Sheet1: =IF(COUNTIF(Sheet2!B:B,B2),"recorded","unrecorded") (Figure 2). After the carriage return, use the mouse to select the C2 cell and drag the fill handle to fill it down. At this point, each record is marked (Figure 3). Sorting or filtering through the above process, we have made each record in Sheet1 a "recorded" or "unrecorded" mark, and we can use these two methods to perform these records. Classification: One is "sort" " method; one is & ldquo; screening & rdquo; “Sort & rdquo; method using "sort & rdquo; method is by the "mark" & rdquo; field in ascending or descending order. First select “ mark & ​​rdquo; this field name, that is, "C1", this cell, here I remind you not to select "C", the entire column, otherwise it will be misplaced. Then click on the “ascending order" or “descending" button to sort the records by tag. If you want to restore the original arrangement, just sort by the "sequence" field (Figure 4). “Filter & rdquo; method use & ldquo; filter & rdquo; method is by the "mark" & rdquo; field by & ldquo; recorded & rdquo; or & ldquo; unrecorded & rdquo; record screening. First select the "tag" this field name, which is “C1” this cell, then click “data →filter →automatic filter” menu, then a black appears on the right side of each field With the small arrow, you can sort the records by tag by clicking the arrow at the "mark" field and selecting “recorded” or “unrecorded” If you want to cancel the screening, just click “Data & Rarr; Filter & Rarr; AutoFilter & rdquo; menu (Figure 5). After sorting the records, select the “Or not recorded” section in the copy sort result or filter result and paste it into a new worksheet or TXT file. This article comes from [System Home] www.xp85.com