Finding Duplicate numbers

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
 
B

Bob Phillips

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

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
M

Mike

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.
 
Top