PC Review


Reply
Thread Tools Rate Thread

deduplication

 
 
scavvie
Guest
Posts: n/a
 
      4th Jan 2010
Trying to remove duplicates within one column can someone help
 
Reply With Quote
 
 
 
 
JMay
Guest
Posts: n/a
 
      4th Jan 2010
If your Data is in Column A , beginning in Cell A2
enter the following fomula in B2 and Copy down

=COUNTIF(A$2:A2,A2)>1

You will see True/False; All that are True are Duplicates
Suggest you do an AutoFilter Selecting True; and while
filtered, Delete all Selected Rows. Then Unfilter

"scavvie" wrote:

> Trying to remove duplicates within one column can someone help

 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      4th Jan 2010
Excel 2003.............Data>Filter>Advanced Filter.

Unique records only and copy to another location.

Excel 2007.............Data>Sort and Filter>Advanced Filter


Gord Dibben MS Excel MVP

On Mon, 4 Jan 2010 07:16:02 -0800, scavvie
<(E-Mail Removed)> wrote:

>Trying to remove duplicates within one column can someone help


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook Emails Deduplication Marcello Kai Microsoft Outlook Discussion 1 30th May 2008 02:22 PM
Deduplication of a sort Alex Microsoft Access Queries 5 8th Nov 2006 10:15 AM
how to perform a deduplication of names on large mailing list =?Utf-8?B?SVQgQXNzaXN0YW50?= Microsoft Excel Worksheet Functions 1 10th Nov 2005 08:09 PM
deduplication Richard Pitman Microsoft Access 2 20th Aug 2005 04:07 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:48 AM.