Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Eliminate Duplicate Row
I have a worksheet with approx 4,000 rows. Some of the items in Column A are
duplicates. How do I delete an entire Row if there is a duplicate of the item in Column A ?? Thanks.. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Eliminate Duplicate Row
Sortuse a loop macro from the bottom up asking if cell +1<cell then
row.delete for i=cells(rows.count,1).end(xlup).row to 1 step -1 if cells(i+1,1)<cells(i,1)then rows(i+1).delete next i -- Don Guillett Microsoft MVP Excel SalesAid Software "Chip" wrote in message ... I have a worksheet with approx 4,000 rows. Some of the items in Column A are duplicates. How do I delete an entire Row if there is a duplicate of the item in Column A ?? Thanks.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to eliminate duplicate numbers | Excel Worksheet Functions | |||
Eliminate duplicate values in drop down list | Excel Discussion (Misc queries) | |||
Eliminate Duplicate Rows - Add columns Accordingly | Excel Discussion (Misc queries) | |||
In 2 Excel worksheets, I am trying to eliminate duplicate entries | Excel Worksheet Functions | |||
How to eliminate duplicate entries | Excel Discussion (Misc queries) |