How to find duplicates in a Column using Excel

Many of the times there is a need to find duplicates in Excel.

  • The solution is select the column where we want to find duplicates;
  • Select create formatting,
  • Select duplicates
  • if any duplicates are there it highlights on duplicates with different color.

Hope you enjoyed with the above tip.

Do not forget to read other Mainframe articles here.

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.