Finding/Removing Duplicate Numbers In A Column ?

  • Thread starter Thread starter Robert11
  • Start date Start date
R

Robert11

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.
 
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
 
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 :-)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Excel Function (Find Duplicate values) 3
Finding duplicates in column 4
Access Auto Matching Duplicates? 0
Changing A "Lot Of" Data With One Command ? 2
Deleting Duplicate Data in a Column. 7
Deleting Duplicate Numbers In A Column: How ? 1
How to find duplicates within same column 2
Determining Duplicate numbers In A Column ? 2

Back
Top