Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gre Gre is offline
external usenet poster
 
Posts: 8
Default How can I delete redundant records in Excel without then leaving b

How can I delete redundant records in Excel without then leaving behind what
will become a unique entry? I want all records that have a duplicate to be
completely deleted from my list, no original from the duplicate left behind.
Thanks!!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default How can I delete redundant records in Excel without then leaving b

Chip has lots of stuff on duplicates at
www.cpearson.com
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"GRE" wrote in message
...
How can I delete redundant records in Excel without then leaving behind
what
will become a unique entry? I want all records that have a duplicate to
be
completely deleted from my list, no original from the duplicate left
behind.
Thanks!!



Reply
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
delete a duplicate in column while leaving other duplicates daphoenix Excel Worksheet Functions 1 June 25th 08 04:15 PM
Delete certain records in Excel and then Change a # in another col jeannie v Excel Worksheet Functions 8 July 22nd 07 04:54 AM
How to delete values in each row leaving only last value ? Oleg Excel Discussion (Misc queries) 1 March 10th 06 07:17 PM
Remove ALL duplicated records, leaving behind NONE Christopher Dawes Excel Discussion (Misc queries) 2 June 6th 05 11:04 PM
automatically delete records w/duplicate address in excel PUSH Excel Discussion (Misc queries) 1 May 24th 05 12:48 PM


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

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

About Us

"It's about Microsoft Excel"