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)


"david" <(E-Mail Removed)> wrote in message
news:eJt$(E-Mail Removed)...
> 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
>
>

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.

"david" wrote:

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