| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
duplicate
I have spreadsheet that contains about 200,000 records. Many of them are
duplicated. How can I sort them out so that I can only have one of each? |
|
#2
|
|||
|
|||
|
Metalteck wrote:
|| I have spreadsheet that contains about 200,000 records. Many of them || are duplicated. How can I sort them out so that I can only have one || of each? have a look he http://www.cpearson.com/excel/duplic...tingDuplicates -- Gordon Burgess-Parker Interim Systems and Management Accounting www.gbpcomputing.co.uk |
|
#3
|
|||
|
|||
|
ASAP Utilities has a feature that does this nicely..........
Free at www.asap-utilities.com Vaya con Dios, Chuck, CABGx3 "Metalteck" wrote in message ... I have spreadsheet that contains about 200,000 records. Many of them are duplicated. How can I sort them out so that I can only have one of each? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping duplicate rows | Excel Worksheet Functions | |||
| Showing Duplicate Rows | Excel Discussion (Misc queries) | |||
| Preventing Duplicate Entries within a column | Excel Discussion (Misc queries) | |||
| How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
| Duplicate records in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
