Excel Duplicate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

|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.
 
Back
Top