Remove duplicated items from MS Excel

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Best Answer by Denver Sua
Best Answer
Best Answer
Answered By 0 points N/A #113391

Remove duplicated items from MS Excel

qa-featured
  • 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.

Answered By 0 points N/A #113392

Remove duplicated items from MS Excel

qa-featured
  • 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?

Login/Register to Answer

Related Questions