Searching for the existence of similar values between the excel worksheet columns manually is fine when we have few values in a column, but if you have thousands of values in a column which has to be compared with another column for identical values, it may take a decade to do so. Microsoft Excel is a powerful tool that can be used efficiently to do such a complex task in no time. Read Also: How to protect Microsoft Excel documents with password How to Find Duplicate Values In Excel by Comparing Columns:- For example, in the below image representation, In an Excel worksheet, we have values in two columns A and column C. In order to identify and highlight the values of column A which are also available in column C, Microsoft's Excel tool has several built-in functions and techniques to do so, whereas not every option is simple and efficient, so here we share one of the easiest ways among them. Sample Data With Employee ID's in Column A and Column C Step: C li