ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Export duplicate data into another spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/224075-export-duplicate-data-into-another-spreadsheet.html)

Chrissy[_3_]

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

Shane Devenshire

Export duplicate data into another spreadsheet
 
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?
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Chrissy" wrote:

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



All times are GMT +1. The time now is 04:08 AM.

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