duplicates

  • Thread starter Thread starter Tom McD
  • Start date Start date
T

Tom McD

What is the qickest way to find duplicates in a column of
more that 8000 numbers of which tere may be duplicates.
Thanks in advance.
 
Your range= A1:A800.
In B1 (& copy down)
=COUNTIF($A$1:$A$8000,A1)

or
=IF(=COUNTIF($A$1:$A$8000,A1)>1,"Duplicate","")
 
pls elaborate your problem
as there could be many ways

one ways could be
use countif function like
=countif(range ,cell no)

it will give you number of times a particular cell
content i srepeated in the range

further pls elaborate your problem
 
Back
Top