LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kim Kim is offline
external usenet poster
 
Posts: 284
Default how can i get rid of duplicate records in excel?

I tried this but is does not hide the duplicates. Can you help?

"Gord Dibben" wrote:

DataFilterAdvanced Filter.

Unique records only and copy to another location.


Gord Dibben Excel MVP

On Thu, 23 Jun 2005 14:47:04 -0700, "Amber"
wrote:

I have a large spreadsheet and because of system parameters, it has lots of
duplicate records. How can I get just one of each record without manually
deleting the duplicates?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
why do I have duplicate excel files - name:1 [vsync], name:2 [vsy harry38 Excel Discussion (Misc queries) 2 January 19th 07 08:16 PM
How do I find duplicate entries in Excel cher Excel Discussion (Misc queries) 2 June 23rd 05 06:29 PM
find duplicate cells in Excel shawneyv Excel Discussion (Misc queries) 2 January 5th 05 01:39 AM
Duplicate records in Excel Sheidsa Excel Discussion (Misc queries) 1 November 30th 04 12:23 AM


All times are GMT +1. The time now is 04:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"