Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Keensie
 
Posts: n/a
Default Deleting duplicate records

I have a worksheet with over twelve thousand records, however there are
several duplicate records in this worksheet. Is there anyway I could quickly
locate these duplicate records and delete them?
  #2   Report Post  
Posted to microsoft.public.excel.misc
mrice
 
Posts: n/a
Default Deleting duplicate records


There are several ways to do this.

Assuming that your data is in column A....

Type the following formula into B1

=COUNTIF(A:A,A1)

and copy this down to the other cells in column B adjacent to your
data.

If a value is replicated, the number returned by the formula will be
greater than 1. Using autofilters will allow you to quickly identify
the rows which appear multiple times.

Another way is to sort the data by column A and use the EXACT function
to test if two adjacent rows are identical.

Type =EXACT(A1,A2) into B1

You will get a value of TRUE if adjacent rows are identical.


--
mrice

Reserach Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=535055

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
Deleting specific records [email protected] Excel Discussion (Misc queries) 6 June 22nd 05 11:35 PM
Deleting both duplicate records ruth_austin50 Excel Discussion (Misc queries) 1 June 22nd 05 05:06 PM
deleting duplicate records in a mail merge Mimi Excel Discussion (Misc queries) 1 April 7th 05 05:55 PM
How to delete duplicate records when I merge two lists (deleting . rinks Excel Worksheet Functions 10 December 11th 04 01:03 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 12:38 AM.

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"