All TalkersTech Sections

How To Find Duplicate Values In Different Excel Sheets

Last Updated : Feb 11, 2022

How To Find Duplicate Values In Different Excel Sheets

In this article we will show you how to find duplicate values in different excel sheets, Microsoft Excel is an important business tool that makes data keeping easier in the business environment.

You can use it to keep unique data for comparison, or future reference. On Excel you can make different kinds of graphs and charts.

You can also compare data on Excel, find duplicate values and use it for many other functions. It is one of the in-demand software used in the business environment. There are various advantages of using Excel.

Thus, knowing all the tricks and shortcuts of Excel can help you achieve success with your business career.

In this article we will have a look at steps to find duplicate values in different Excel sheets. Follow the steps given below in this article properly.

Step By Step Guide On How To Find Duplicate Values In Different Excel Sheets :-

  1. Open the Excel sheets with the data you want to find duplicates.
  2. Highlight the data on the first sheet.
  3. Go to conditional formatting on the home tab.

    How To Find Duplicate Values In Different Excel Sheets

  4. When you click on it, a drop down menu will appear on your desktop screen.
  5. Select new formatting rules from the given menu.
  6. Type a formula: =countif('List of <column name>' ! $<column>$<number>:$<column>$<number>, <column number>) >0. For example if you have the column A called names with a list of names, then you have to write the following formula:=countif('List of names'! $A$2:$A$8,A2) >0

    How To Find Duplicate Values In Different Excel Sheets

  7. Click on Format after you have typed in the required formula. You will get a dialog box with different colors to choose the background color.
  8. Go to Fill option.
  9. And choose whatever color you want.

    How To Find Duplicate Values In Different Excel Sheets

  10. Then, click OK button at the bottom of the pop-up box.
  11. Again click on OK. You will then get redirected back to the sheet.
  12. You will find that the duplicate names are highlighted on your sheet based on the name on other sheets.

    How To Find Duplicate Values In Different Excel Sheets

Conclusion :-

If you accurately follow the steps mentioned above, you can easily find duplicates in multiple Excel sheets at once.

Having the basic concept of conditional formatting and how to write a formula on Excel is important. It will make the task easier for you.

With proper knowledge of Excel and how to handle different functions, it can save you a lot of time and help you get ahead in your professional career. So, work on your Excel skills to get better job opportunities.

I hope this article on how to find duplicate values in different excel sheets helps you and you enjoyed reading this article and it also helps you to find the duplicate values in different excel sheets.

LATEST ARTICLES