| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete duplicate rows
Hi. I’ve got this...
90312966 MRS LEE JONES 21 FORE STREET REDRUTH 90312968 MISS RACHEL GOLDING FLAT 3 OLD PLACE ALMA PLACE 90312979 Miss Lily Pascoe The Cottage the lizard 90312984 mr david carr pitch 02 mullion holiday park 90312984 MR DAVID CARR PITCH 02 MULLION HOLIDAY PARK RUAN MINOR 90312984 MR DAVID CARR PITCH 02 MULLION HOLIDAY PARK RUAN MINOR 90312991 MISS Nerys Hughes 7 POLDARK VIEW CARHARRACK 90312991 MISS Nerys Hughes 7 POLDARK VIEW CARHARRACK 90312992 MR ADRIAN TREWERN FLAT VOGUE YARD GEW TERRACE .... and there are further address columns to the right. Also, the same number+person+address might appear more than twice. I want a macro that will look at the number in col A and delete all the rows above it with the same number, so that I am left with only the last row for each person. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete duplicate rows | Excel Worksheet Functions | |||
| Delete Duplicate rows | Excel Programming | |||
| Delete duplicate rows | Excel Programming | |||
| HELP delete duplicate rows. | Excel Programming | |||
| Delete duplicate rows | Excel Programming | |||
Threaded Mode
