Duplicate Rows

G

Guest

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
 
B

bigwheel

instauratio said:
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
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete duplicate and original row 3
Duplicates 2
Subdividing a Row into Multiple Rows 2
locating and deleting duplicate cell entries 2
Identify duplicate rows 1
Duplicate Records 2
Combine data that spans two rows, preserving cells? 1
How do I delete both duplicate rows from a spreadsheet? 3

Top