PC Review


Reply
Thread Tools Rate Thread

Finding Duplicate numbers

 
 
david
Guest
Posts: n/a
 
      18th Jul 2005
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


 
Reply With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      18th Jul 2005
=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
>
>



 
Reply With Quote
 
=?Utf-8?B?TWlrZQ==?=
Guest
Posts: n/a
 
      18th Jul 2005
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
>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding Duplicate Numbers chadhable Microsoft Excel Misc 1 16th May 2008 01:47 AM
Finding duplicate numbers in a spreadsheet wintergems Microsoft Excel Worksheet Functions 2 18th Jan 2008 04:40 PM
Finding duplicate serial/model numbers Ashley Microsoft Access Queries 3 8th Oct 2004 04:03 PM
finding duplicate numbers Jack Microsoft Excel Worksheet Functions 11 20th Aug 2004 10:51 PM
Finding duplicate numbers wookmaster Microsoft Excel Discussion 8 29th Jan 2004 02:06 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:57 PM.