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.