| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
delete duplicate data
Can Somebody please explain this code to me? I think it may meet my needs
but I'm just not sure. I want to delete the previous row if the data in column G is the same in 2 consecutive rows. Sub deleledupsinpreviousrows() For i = Cells(Rows.Count, "a").End(xlUp).Row To 2 Step -1 If Cells(i - 1, 1) = Cells(i, 1) Then Rows(i - 1).Delete Next End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I delete all rows that contain no red highlighted data? | Excel Discussion (Misc queries) | |||
| Data values WON'T DELETE in PivotTable drop-downs | Excel Discussion (Misc queries) | |||
| Delete rows with no data | Setting up and Configuration of Excel | |||
| Unique and duplicate data between 2 Excel worksheets | Excel Worksheet Functions | |||
| How do I find duplicate rows in a list in Excel, and not delete it | Excel Discussion (Misc queries) | |||
Threaded Mode
