#1   Report Post  
Vass
 
Posts: n/a
Default remove duplications

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 ?
thanks
--
Vass


  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi Vass

Visit Chip Pearsons site
http://www.cpearson.com/excel/duplicat.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Vass" wrote in message ...
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 ?
thanks
--
Vass




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
remove last three characters of cell mira Excel Discussion (Misc queries) 8 July 28th 05 12:06 AM
=IF(TRIM(RIGHT(D4,1))="X",MID(D4,1,LEN(D4)-1),D4) ? remove error Muhammad Nasir Excel Worksheet Functions 9 June 24th 05 10:22 AM
Remove link fr a column of entries Rasoul Khoshravan Azar Excel Discussion (Misc queries) 1 December 18th 04 10:51 PM
Remove link fr a column of entries Rasoul Khoshravan Azar Excel Discussion (Misc queries) 1 December 17th 04 08:07 PM
Remove link fr a column of entries Rasoul Khoshravan Azar Excel Discussion (Misc queries) 1 December 17th 04 06:44 PM


All times are GMT +1. The time now is 11:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"