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.

http://xldynamic.com/source/xld.Deleting.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Tariq" wrote in message ...
|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.

I would like to find and delete any duplicate row entries in my MS Excel 2003
spreadsheet.

What I want to do is, where three cells within a row match three other
cells within a different row then identify and or delete one of the matching
row.