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 / November 2006

Tip: Looking for answers? Try searching our database.

Finding/Removing Duplicate Numbers In A Column ?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Robert11 - 26 Nov 2006 12:14 GMT
Hi,

I have a long list of numbers in a column.

How would I determine if there are duplicates, and "flag" them ?

How would I remove all the duplicates in a single, perhaps, step ?

Thanks,
B.
JE McGimpsey - 26 Nov 2006 13:35 GMT
See

   http://cpearson.com/excel/duplicat.htm

> Hi,
>
[quoted text clipped - 6 lines]
> Thanks,
> B.
Robert11 - 26 Nov 2006 15:11 GMT
Hello again,

Thank you very much for help.
Appreciate it.

Can't seem to get it to work, undoubtedly because I'm doing something really
dumb
with this.  Relatively new user.

Would just like to highlight any and all duplicates.

Have my mumbers in Col B, from row 2 to row 483

Entered:
changed to Formula Is.

=if(countif($B$2:$B$483,B2)>1, true,false)

When trying to run it, I get an error msg. that says:

You may not use unions, intersections, or array constants for conditional
formatting criteria.

Any idea what I might be doing wrong ?

Thanks again, Bob
--------------------------------

> See
>
[quoted text clipped - 10 lines]
>> Thanks,
>> B.
Teethless mama - 26 Nov 2006 16:53 GMT
Let's say your data in A2:A100
create a dummy column B, in B2=COUNTIF(A2:A100)>1
Auto Filter all the TRUE, then highlight all filter rows, then go to
Edit>Delete Rows,
then delete a dummy column :-)

> Hi,
>
[quoted text clipped - 6 lines]
> Thanks,
> B.
Robert11 - 26 Nov 2006 22:47 GMT
Hi All,

Much thanks to everyone for all the help.

Got it to work now !

Bob
---------------------
> Hi,
>
[quoted text clipped - 6 lines]
> Thanks,
> B.
 
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.