ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Duplicate Rows (https://www.excelbanter.com/excel-discussion-misc-queries/29446-duplicate-rows.html)

instauratio

Duplicate Rows
 
I have exported an Act 6.0 contact database into a .csv excel spreadsheet. It
worked perfect! Each contact occupies a single row. However, some of the
contacts are duplicates (existing before the export). Is there an easy way
that I can remove duplicated rows in a spreadsheet? I know there must be, but
how?
Thanks

bigwheel

"instauratio" wrote in message
...
I have exported an Act 6.0 contact database into a .csv excel spreadsheet.

It
worked perfect! Each contact occupies a single row. However, some of the
contacts are duplicates (existing before the export). Is there an easy way
that I can remove duplicated rows in a spreadsheet? I know there must be,

but
how?
Thanks


Have a look at http://www.cpearson.com/excel/duplicat.htm




All times are GMT +1. The time now is 12:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com