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.