Export duplicate data into another spreadsheet

C

Chrissy

How do I pull duplicate data from one cell of a spreadsheet and export it
into another spreadsheet?
 
S

Shane Devenshire

Hi,

In Excel 2007 copy the entire range to the new spreadsheet and then choose
the Data, Remove Duplicates command.

Actually we need more info - you say pull duplicate data from "a" cell? So
one cell has "abd abd rrt" and you want to put the abd abd part in another
spreadsheet?
 

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

Excel 2007 - extracting duplicate names 1
Lookups - how to obtain data from a master spreadsheet into another 5
How to export data from excel spreadsheet to outlook distribution 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
edited spreadsheet saves as template 9
Refreshing formulas automatically 3
Creating a duplicate worksheet 1
Export data from the same cell from multiple spreadsheets into a n 1

Top