IP Addesses

[sherbrooke805]

Hi.

I have 3 columns in an Excel worksheet.

The 1st column has the first IP address in a subnet.

The 2nd column has the last IP address in the subnet.

The 3rd column has the email address of the person responsible for the
subnet (a LAN admin).

Example:

IPStart ____ IPend ______ Admin
133.214.1.0 133.214.1.254 (e-mail address removed)
133.214.2.0 133.214.2.254 (e-mail address removed)

etc...

(underscores used for formatting on this post)

I run a scan every now and then on my network to see which computers
are not patched and I generate a list that I export into Excel in a
vertical column.

Example:

133.214.1.2
133.214.1.5
133.214.1.11
133.214.2.6
133.214.2.8

..etc.


I sort them in order. I would appreciate any assistance on how I can
write a formula or function to loop through each IP address in my scan
output and return an output that has the LAN admin's email address
(from the 3rd column) with all of the IP addresses that are within the
range assigned to that person.

So the output would be:

(e-mail address removed)
133.214.1.2
133.214.1.5
133.214.1.11
(e-mail address removed)
133.214.2.6
133.214.2.8

Thanks!

(e-mail address removed)

 

[Bob Phillips]

It's relatively straight-forward, but difficult to explain. I have sent you
a sample workbook by direct mail.


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[sherbrooke805]

Bob,

Thank you so much for spending the time to help me with my problem.
Unfortunately, I did not receive an email from you at:
(e-mail address removed)

Lots of time people think my email is a .com, not .net ...?

Sorry if that was confusing. can you resend it? I am curious to see
your work!

Thanks so much!

Danielle-Alexis
(e-mail address removed)

 

[Bob Phillips]

Danielle-Alexis,

I picked the email address from your post so it should be correct. I have
just checked, and I sent it to (e-mail address removed).

If you still haven't got it, mail me directly at (e-mail address removed)
, and I will send it in a reply.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

Danielle-Alexis,

Your email is in trouble! I get this delivery failure

<[email protected]>: host mailin-01.mx.netscape.net[205.188.158.25]

refused to talk to me: 554-(RLY:B1) The information presently available to

AOL indicates this 554-server is generating high volumes of member

complaints from AOL's 554-member base. Based on AOL's Unsolicited Bulk

E-mail policy at 554-http://www.aol.com/info/bulkemail.html AOL may not

accept further 554-e-mail transactions from this server or domain. For

more information, 554 please visit http://postmaster.info.aol.com.



If you don't mail me, I can't help.


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Danielle-Alexis,

I picked the email address from your post so it should be correct. I have
just checked, and I sent it to (e-mail address removed).

If you still haven't got it, mail me directly at (e-mail address removed)
, and I will send it in a reply.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[sherbrooke805]

Hi Bob,

thanks for the update. I sent you a new email from my cousin's account
to respond to. Hopefully that should work. Thanks again for your
understanding!

D-A