Finding Duplicate numbers

  • Thread starter Thread starter david
  • Start date Start date
D

david

Hi, I am creating a spreasheet of IP addresss. I need to find a macro for
checking for duplicate IP addresses. Any help or pointing me to where I can
find out more on this would be great.

Thanks
David
 
=IF(COUNTIF(A:A,A2)>1,"Duplicate","")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Run a sort then in the second column, row two have
=exact(a1,a2)
then highlight that cell and go all the way down your list then hit control d.
Then I think you can sort by the second column to get all the trues together.
 
Back
Top