Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dulpicate rows
I have imported a load of data from an accounts package and for some reason
every line is duplicated once How do I remove the duplicated rows in one action ? I used to do this in Lotus 1-2-3 with a CELL REF compare with the cursor position looking at the cell below, IF SAME DELETE kinda thing any ideas for Excel ? thanks -- Vass |
#2
|
|||
|
|||
Hi Vass
If all the entries are repeated and are in adjucent rows you can do this simple exercise. Insert a new column and write 1in every odd row and 2 in every even row till the last non blank row. Now put an auto filter, select 1 or 2 , this will show one set of entries. Select the visible cells and do CRTL - (minus) or right click and select delete rows.. When prompted "Delete Enrire Row?" click OK. Now remove the filters and you have only one set of entries. This can also be done using simple VBA code.. Thanks Karthik Bhat Bangalore |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
REALLY miussing rows in Excel2000 | Excel Discussion (Misc queries) | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel |