Identifying Duplicate Values in Excel cells | Find Duplicate Values in Excel cells | Identifying Duplicate Values in Excel cells

Identifying Duplicate Values in Excel cells | Find Duplicate Values in Excel cells | Identifying Duplicate Values in Excel cells

In Ms Excel there is easy method to Identify the Duplicate values in rows and columns. 

For Example:

Identifying Duplicate Values in Excel cells | Find Duplicate Values in Excel cells | Identifying Duplicate Values in Excel cells 

 In the above Figure there are names list of fruits. Fruits names are repeated in column. So, to identify the duplicate values in ms excel cells 

Click on Conditional format in Home Menu

The select Highlight cell Rules

After selecting the Highlight cell rules you will find right side pane 

the select Duplicate Values, and click OK which is shown in below figure

Identifying Duplicate Values in Excel cells | Find Duplicate Values in Excel cells | Identifying Duplicate Values in Excel cells

Then all the cells which are repeated with fruit names are get highlighted.

Identifying Duplicate Values in Excel cells | Find Duplicate Values in Excel cells | Identifying Duplicate Values in Excel cells

To Identify duplicate values in two columns again repeat the same steps for identifying Duplicate Values in Excel cells.

Microsoft Excel Keyboard Shortcut Keys