| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete rows that have a duplicate id keeping the upper row
I neeed a macro that will delte a row based on a duplicate value in column A;
Row col A col B col C Claim Number DCC Warranty Code 1 0132482B DTYC 03D 2 0137448A 1 3 0141614A 01D 4 0141614A 5 0141614A 6 0143504B 1 7 0154120A DW77 01D 8 0154120A 9 0159953A DWL0 03D In this example I want to delete rows 4,5, and 8 How might this be accomlpished? Thanks. Bruce |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to delete all duplicate records - without keeping one of them | Excel Worksheet Functions | |||
| Collating Duplicate Rows Keeping all values intact and updating Qu | Excel Discussion (Misc queries) | |||
| remove duplicate rows but keeping all columns | Excel Worksheet Functions | |||
| Keeping duplicate rows | Excel Worksheet Functions | |||
| Deleting Duplicate Rows but keeping the most recent. | Excel Programming | |||
Threaded Mode
