Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 10th 04, 11:09 PM
musicgirl
 
Posts: n/a
Default automatic delete possible?

Is there a way that I can have my excel worksheet automatically delete
repeats? For example: I have sorted by name, date and hours and have items
like this:

John Smith, 10/1/2004, 20 hours
John Smith, 10/1/2004, -20hours

Is there anyway to automatically have these items automatically deleted?

  #2   Report Post  
Old November 11th 04, 05:06 AM
Myrna Larson
 
Posts: n/a
Default

No, Excel doesn't automatically delete things (thank heavens!). But the two
rows you show are not duplicates. One has +20 hours, the other -20 hours.

If they WERE complete duplicates, you could use Data/Filter/Advanced Filter
select Unique Records, and copy to another location. That new list will have
no duplicates.

On Wed, 10 Nov 2004 15:09:03 -0800, musicgirl
wrote:

Is there a way that I can have my excel worksheet automatically delete
repeats? For example: I have sorted by name, date and hours and have items
like this:

John Smith, 10/1/2004, 20 hours
John Smith, 10/1/2004, -20hours

Is there anyway to automatically have these items automatically deleted?




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
Automatic backup copy craigq Charts and Charting in Excel 2 April 11th 05 04:57 PM
How do you delete a cell then shift cell up? Isela Excel Discussion (Misc queries) 4 January 22nd 05 01:41 AM
delete row contains specific word in an macro Jean-Francois Excel Discussion (Misc queries) 4 January 11th 05 11:40 PM
Saving to a network share without delete permssions SteveHoot Excel Discussion (Misc queries) 1 January 5th 05 09:50 PM
Delete carrots in a string [email protected] Excel Worksheet Functions 2 November 9th 04 02:10 AM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017