Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2005

Tip: Looking for answers? Try searching our database.

Duplicate entries

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Keggarboy - 12 Feb 2005 00:37 GMT
I have a column with many numbers that are duplicates.   How can excel help
me get rid of the duplicates with out doing each individual line one at a
time?
Max - 12 Feb 2005 00:58 GMT
One way ..

Assume the numbers are in col A, in A2 down

Put in B2: =IF(COUNTIF($A$2:A2,A2)>1,"X","")
Copy B2 down

This'll flag all duplicates in col A with an "X"

Now do a Data > Filter > Autofilter on col B
(put a label in B1 first)

In the droplist in B1, select "X"

This filters out all the duplicate rows

Select the row headers for the duplicates
(this will be all the "blue" colored filtered row headers)
Right-click > Delete Row

Remove the Autofilter
Signature

--
Rgds
Max
xl 97
---
GMT+8,  1? 22' N  103? 45' E
xdemechanik <at>yahoo<dot>com
----

> I have a column with many numbers that are duplicates.   How can excel help
> me get rid of the duplicates with out doing each individual line one at a
> time?
Christopher - 30 Apr 2005 08:21 GMT
> One way ..
>
[quoted text clipped - 32 lines]
>>me get rid of the duplicates with out doing each individual line one at a
>>time?

I also need help with this but when I do as you answered I get the
message "Wrong in formula" and :A2,A2 is highlighted in the formula. I
use a swedish localized Excel 2003 where the formulas use swedish names
but english should work as well right?
Peo Sjoblom - 30 Apr 2005 08:26 GMT
No, you would need to use

=OM(ANTAL.OM($A$2:A2;A2)>1;"X";"")

it will translate English formulas if you get a workbook with them but you
can't enter English formulas

Signature

Regards,

Peo Sjoblom

>> One way ..
>>
[quoted text clipped - 37 lines]
> swedish localized Excel 2003 where the formulas use swedish names but
> english should work as well right?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.