I have a MS Excel sheet with with rows of information about staff, first
name, surname and staff, staff no.

The spreadsheet is very big how can I identify duplicate enties and delete
them for the whole speadsheet by using a macro or other method.