A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Automatically deleting duplicate rows??



 
 
Thread Tools Display Modes
  #1  
Old June 30th, 2004, 11:56 AM
Ritchie Jones
external usenet poster
 
Posts: n/a
Default Automatically deleting duplicate rows??

Hello,

I have searched through the help but couldnt find out how
you can delete duplicate rows in an Excel spreadsheet
without having to manually go through and compare them. Is
it possible to automate it??

Ta folks,

Ritchie )
  #2  
Old June 30th, 2004, 12:11 PM
garfield-n-odie
external usenet poster
 
Posts: n/a
Default Automatically deleting duplicate rows??

Hi, Ritchie. See http://www.cpearson.com/excel/deleting.htm.


"Ritchie Jones" wrote:

Hello,

I have searched through the help but couldnt find out how
you can delete duplicate rows in an Excel spreadsheet
without having to manually go through and compare them. Is
it possible to automate it??

Ta folks,

Ritchie )

  #3  
Old June 30th, 2004, 01:19 PM
Anson
external usenet poster
 
Posts: n/a
Default Automatically deleting duplicate rows??

If you don't want to write a macro, I have an alternative idea:

First, sort the list by the column that you are trying to detect duplication, Say Column M. Second, insert a column in the table or find a blank column somewhere, say column N write this formulae: Cell N2 write : "=if(M2=M1, 1, 0)", copy this formula to the end of the list. Third, clear the fomulae by copypastespecial values. Finally, use either sort column N and delete the 1s or use a filter to flush out the 1s and delete them. I have been using this method for years, it only takes me a few seconds to do it.

"Ritchie Jones" wrote:

Hello,

I have searched through the help but couldnt find out how
you can delete duplicate rows in an Excel spreadsheet
without having to manually go through and compare them. Is
it possible to automate it??

Ta folks,

Ritchie )

  #4  
Old June 30th, 2004, 05:47 PM
Gord Dibben
external usenet poster
 
Posts: n/a
Default Automatically deleting duplicate rows??

Ritchie

Can be done through Advanced Filtering.

See Debra Dalgleish's site for instructions with pictures.

http://www.contextures.on.ca/xladvfi....html#FilterUR

Gord Dibben Excel MVP

On Wed, 30 Jun 2004 03:56:31 -0700, "Ritchie Jones"
wrote:

Hello,

I have searched through the help but couldnt find out how
you can delete duplicate rows in an Excel spreadsheet
without having to manually go through and compare them. Is
it possible to automate it??

Ta folks,

Ritchie )


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicate Rows Dtruelove Worksheet Functions 2 May 26th, 2004 03:15 PM
Deleting Empty Rows Dolphinv4 Worksheet Functions 0 March 15th, 2004 04:21 AM
Duplicate searching through multiple columns, rows Eliezer Worksheet Functions 1 January 30th, 2004 07:28 PM
deleting duplicate rows margaret Worksheet Functions 1 September 15th, 2003 09:13 PM


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


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