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

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:


133.214.1.2
133.214.1.5
133.214.1.11

133.214.2.6
133.214.2.8

Thanks!





------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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" wrote in message
...
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
133.214.2.0 133.214.2.254

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:


133.214.1.2
133.214.1.5
133.214.1.11

133.214.2.6
133.214.2.8

Thanks!





------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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:


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




------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Danielle-Alexis,

I picked the email address from your post so it should be correct. I have
just checked, and I sent it to .

If you still haven't got it, mail me directly at
, 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" wrote in message
...
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:


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




------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Danielle-Alexis,

Your email is in trouble! I get this delivery failure

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

"Bob Phillips" wrote in message
...
Danielle-Alexis,

I picked the email address from your post so it should be correct. I have
just checked, and I sent it to .

If you still haven't got it, mail me directly at

, 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" wrote in
message
...
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:


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




------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/