| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel - Identify and delete duplicate rows
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to identify duplicate rows & staffs xfr frm one depart to anot | Excel Discussion (Misc queries) | |||
| Delete Duplicate rows in an Excel list | Excel Discussion (Misc queries) | |||
| Identify duplicate rows | Excel Discussion (Misc queries) | |||
| Identify the duplicate and delete with details in excel | Excel Discussion (Misc queries) | |||
| Identify and move duplicate rows? | Excel Programming | |||
Threaded Mode
