Thank you but that does not cover all my scenarios. Though the first digit is
3 in all it is not 7 in the rest. It would have to be nested somehow to
include all. Here's the list of all 7:

3.xxx.xxx.7
3.xxx.xxx.71
3.xxx.xxx.135
3.xxx.xxx.199
3.xxx.xxx.110
3.xxx.xxx.111
3.xxx.xxx.115

Thanks for coming to my aide. :-)
--
Hile


"Teethless mama" wrote:

Create a helper column B.

In B2: =AND(LEFT(A2)="3",MID(A2,11,1)="7")
Auto Filter the TRUE


"Hile" wrote:

I have a list of IP addresses, over 30K records. I need to filter out those
records which meet specific IP range i.e. within:
3.xxx.xxx.7
3.xxx.xxx.71

I have seven of these ranges. How can I do this programatically. I can't
think of a way to do this in a pivot table and will like to stay away from VB
if possible because I don't know it. But I'll take anything at this point. I
thought of doing custom filter with 'contains' 3.*.7 but it is giving me
records that end in something other than .7 AND I can only do up to 2
criteria not seven.

I have a short timeframe for this. I use Excel 2003 on winXP Pro 2002 SP3

Thank you for your time!!!!

--
Hile