Thread: Dulpicate rows
View Single Post
  #1   Report Post  
Vass
 
Posts: n/a
Default 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