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