Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete duplicate rows, keep one
I would like to delete duplicate rows but to keep one row
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete duplicate rows, keep one
Very simple. Say we have 150 rows. Starting with row # 150, compare each
cell in row #150 with the cells in the rows above it. If for some earlier row, all the cells match, then delete row #150 and repeat the process moving upwards. -- Gary''s Student - gsnu200908 "Wasdell" wrote: I would like to delete duplicate rows but to keep one row |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete rows with duplicate values | Excel Discussion (Misc queries) | |||
delete duplicate rows | Excel Worksheet Functions | |||
Delete rows with duplicate values | Excel Worksheet Functions | |||
How do I delete both duplicate rows from a spreadsheet? | Excel Discussion (Misc queries) | |||
I want to delete rows with duplicate entries within one column. | Excel Discussion (Misc queries) |