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

How to automate update on weekly reports spreadsheet 0
Need Help with Macro Security 1
Need Help with a VBA subroutine 0
Grouping Names in Mail Merge 0
Linking data in MS Word into Excel 5
I have an excel spreadsheet. I want to export each single rows into a new email on mi 1
Pulling a specific email from cells and putting info in new row 4
Dealing with a Pivot Table (when I don't want to) 0

Top