Search notes:

Excel: Data -> Data Tools -> Remove Duplicates

The functionality Remove Duplicates removes duplicate rows from a sheet.
The columns in which duplicates are looked for are choosable.

See also

Microsoft/Office/Excel/GUI/Ribbon/tabs/Home/Styles/Conditional-Formatting/Highlight-Cells-Rules/Duplicate-Values
Formula to count occurence of a value

Index