Home > Software Tutorial > Office Software > Remove duplicate cell data in excel

Remove duplicate cell data in excel

WBOY
Release: 2024-01-16 19:48:17
forward
1102 people have browsed it

excel clear duplicate cell data

Although Excel itself does not provide the function of clearing duplicate records, we can use its advanced filtering to achieve the same effect. Please refer to relevant information.

Note: The techniques described in this article have been tested in Microsoft Excel 2003 environment)

The specific steps are as follows:

1. Open an Excel document with duplicate records. As shown in Figure 1 (Note: This picture has been processed with Photoshop, and the colored parts are repeated records)

figure 1

2. Select all the records in the chart (note that the header row of each column should also be selected at this time, otherwise the filtered data table will no longer contain the header row), execute the "Data" menu → "Filter→Advanced Filter" command

3. In the pop-up "Advanced Filtering" dialog box, select the "Copy filter results to other location" item, and click the range button behind the "Copy to" selection box to select an area to store the filtered data. (Note: This must not overlap with the cell where the original data is located, otherwise the data table will be confused). Finally, after checking the "Select non-duplicate records" checkbox, click the "OK" button. . as shown in picture 2

figure 2

4. At this time, Excel will automatically delete all duplicate records. After confirming that they are correct, you can copy the newly generated data list to a new worksheet and continue to use it. As shown in Figure 3

image 3

How about it? Is it very convenient? Then quickly move your mouse and try it!

Advanced filtering! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! Advanced filterAdvanced filterAdvanced filterAdvanced filterAdvanced filterAdvanced filterAdvanced filterAdvanced filterAdvanced filterAdvanced filterAdvanced filterAdvanced filterAdvanced filterAdvanced filterAdvanced filterAdvanced filterAdvanced filterAdvanced filterAdvanced filterAdvanced filter Advanced FilterAdvanced FilterAdvanced Filter

How to delete rows with duplicate data in batches in EXCEL

1. We can select the data to be edited in the open Excel document

Remove duplicate cell data in excel

2. Next, click the “Data” tab at the top of Excel

Remove duplicate cell data in excel

3. Then in the opened data ribbon, we click the "Delete Duplicate Values" button.

Remove duplicate cell data in excel

4. A "Delete Duplicate Values" window will pop up. Select the data column to be edited in the window, and then click the "OK" button.

Remove duplicate cell data in excel

5. If there are duplicate values ​​in the selected data, a prompt window will pop up indicating that several duplicate values ​​have been found and deleted

Remove duplicate cell data in excel

6. Open the data we edited again, and you can see that all the data is now unique.

Remove duplicate cell data in excel

Extended information:

How to delete blank worksheets in Excel with one click

1. First open the data form and see that sheet1 has data content, sheet2 and 3-digit blank form, as shown in the figure below:

Remove duplicate cell data in excel

Remove duplicate cell data in excel

Remove duplicate cell data in excel

2. Find the square grid plug-in, as shown in the figure below:

Remove duplicate cell data in excel

3. Click Delete Blank Table in batch deletion, as shown in the figure below:

Remove duplicate cell data in excel

4. Click OK after the dialog box pops up, as shown below:

Remove duplicate cell data in excel

5. You can see that the blank worksheet has been deleted, as shown in the figure below:

Remove duplicate cell data in excel

The above is the detailed content of Remove duplicate cell data in excel. For more information, please follow other related articles on the PHP Chinese website!

source:docexcel.net
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template