Remove duplicated items from MS Excel

Asked By Sad Sidan 0 points N/A Posted on - 08/10/2011

I have a database of contacts in Excel sheet. Much duplication of numbers exists in the list. I want to remove the duplicate of any number from the list. Guide me how I remove duplicate numbers from the list of database?

• Status: Open
• Question Views: 988
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Denver Sua

Go To Solution

Best Answer

Best Answer

Answered By Denver Sua 0 points N/A #113391

Remove duplicated items from MS Excel

• First step is open the list in your Excel file just make sure each entry is in its own row.
• Now click the Data tab found in the left side of the window. And it will bring up a data menu on the screen, then look for data  tools in the toolbar section.
• Now select the range of the cells you want to delete duplicates, by doing this you will drag a box around the data, or you can select the entire row within a single click that corresponds by a letter / number  then to the column or row,
• Then click the remove duplicates button, by doing that a dialog box will come up  and ask what column you want the duplicates to be removed, once down click ok, then duplicate data will be deleted.

Images are shown below for reference.

About Denver Sua

Questions
0

Answers
9

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 08/10/2011
• Question Category: MS Excel

Answered By trprasad78 0 points N/A #113392

Remove duplicated items from MS Excel

• If you want find the duplicate in A column of the Excel sheet apply this formula 
• If you have header apply this formula =countif(A$2:A2,A2)
• No header apply this formula  =countif(B$2:B2,B2) and drag fully. where 2 or greater than 2 is duplicate.
• You can remove by sort Z-A.
• For more details you can also refer following post. what is the best way to eliminate duplicates?

About trprasad78

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/17/2011
• Question Category: MS Excel

Answered By Sharath Reddy 590495 points N/A #330742

Remove duplicated items from MS Excel

In Microsoft Office Excel, if you have a worksheet that has duplicate numbers and you want to remove them, here’s how to do it. First, select the cells you want to check for duplicates. Next, go to “Home” tab then click “Conditional Formatting,” “Highlight Cells Rules” then “Duplicate Values.” In “values with” box, select the formatting you want to apply to the duplicate values then click “OK.”

Next up is to remove the duplicates. Select the cells that have duplicate values you want to remove. Next, go to “Data” tab then click “Remove Duplicates” and then under “Columns,” check or uncheck the columns where you want to remove the duplicates then click “OK.”

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 06/12/2020
• Question Category: MS Excel