How to Remove Duplicate Rows Based on Two Columns in Excel

To remove duplicate rows based on two columns in Excel, you can use the 'Remove Duplicates' feature. Follow these steps:

1. Open your Excel workbook and select the worksheet containing the data.
2. Click on any cell within the data range to make it the active cell.
3. Go to the 'Data' tab in the Excel ribbon.
4. In the 'Data Tools' group, click on 'Remove Duplicates'.
5. In the 'Remove Duplicates' dialog box, you will see a list of all columns in your data range. By default, all columns are selected.
6. Deselect all columns by unchecking the 'Select All' checkbox.
7. Now, select the two columns you want to base your duplicate removal on by checking the boxes next to their names.
8. Click 'OK' button to remove the duplicates.
9. A message will appear, indicating how many duplicate rows have been removed and how many unique rows remain. Click 'OK' to close the message.

Example

Let's assume you have the following data in your Excel worksheet:

A      B      C
1 Name  Age    City
2 John  25     New York
3 Jane  28     Los Angeles
4 John  25     New York
5 Jane  30     San Francisco
6 John  25     New York

You want to remove duplicate rows based on columns 'Name' and 'Age'. Follow the steps above and select columns A and B in step 7. After removing duplicates, your data should look like this:

A      B      C
1 Name  Age    City
2 John  25     New York
3 Jane  28     Los Angeles
4 Jane  30     San Francisco

As you can see, the duplicate rows (rows 4 and 6) based on columns 'Name' and 'Age' have been removed.