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
|