Chip as lots about duplicates at www.cpearson.com
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Tariq" wrote in message
...
I have a MS Excel 2003 sheet with with rows of information about staff,
first
name, surname and staff, staff no.

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

A duplicate row will be where the first name, surname and staff no. match
another in the spreadsheet and where one entry needs to be deleted.