excel tips about duplicate data

Remove Duplicate

1) Highlight table

2) click Data > Data Tools > Remove Duplicates 

3) can choose the column to remove

Highlight Duplicate

1) Highlight table
2) Click Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values