A nos of data is in excel sheet. If i want to find the duplicate or similar data what procedure should i follow?

Question

Accepted Answer

To find duplicate or similar data in an Excel sheet, you can use the 'Conditional Formatting' feature.

Select the range of data you want to check for duplicates or similarities.
Go to the 'Home' tab in Excel and click on 'Conditional Formatting'.
Choose 'Highlight Cells Rules' and then 'Duplicate Values'.
Select the formatting options for highlighting duplicates or similar values.
Excel will then highlight the duplicate or similar data in the selected range.
You can also use the 'Remove Duplicates' feature under the 'Data' tab to remove duplicate entries.

Accepted Answer

By using conditional formatting- highlight cell- duplicate value all the similar data will be highlight with selected colour afte that i use filter using colour to show the all duplicate entries

A nos of data is in excel sheet. If i want to find the duplicate or similar data what procedure should i follow?

Popular interview questions of Supervisor