I am having a big Excel sheet with about 800 rows and 58 Columns.Where in I
have a Column Named IPNumbers. Basically as we might be knowing an IP numbe
is represented like //163.259.081.234 //.I am trying to filter out the Odd
and Even Numbered IP Numbered from the huge collection of list.I was
wondering If have to opt for the macro or a Custom Filter would be fine.
Any valid suggestions is greatly appreciated.
Thanks,
banu

Hi Banu,

You asked this question several days ago and received a number of replies:

http://tinyurl.com/75gwx

Were none of these responses useful?


---
Regards,
Norman



"banu" wrote in message
...
I am having a big Excel sheet with about 800 rows and 58 Columns.Where in
I
have a Column Named IPNumbers. Basically as we might be knowing an IP
numbe
is represented like //163.259.081.234 //.I am trying to filter out the Odd
and Even Numbered IP Numbered from the huge collection of list.I was
wondering If have to opt for the macro or a Custom Filter would be fine.
Any valid suggestions is greatly appreciated.
Thanks,
banu

Gday Norman,
Thanks for your attention.
I really dont know where will I see the replies that i got for my previous
posts.
Any help Pls.
Thank you very much

Regards,
Banu

"banu" wrote:

I am having a big Excel sheet with about 800 rows and 58 Columns.Where in I
have a Column Named IPNumbers. Basically as we might be knowing an IP numbe
is represented like //163.259.081.234 //.I am trying to filter out the Odd
and Even Numbered IP Numbered from the huge collection of list.I was
wondering If have to opt for the macro or a Custom Filter would be fine.
Any valid suggestions is greatly appreciated.
Thanks,
banu

Hi Banu,

News Group posts are stored by Google and can be accessed at:

http://groups-beta.google.com/group/...el.programming

Ron De Bruin has created a very useful addin which facilitates searches of
thr Google archive. The Google Search addin is freely downloadble at:

http://www.rondebruin.nl/Google.htm

But ... for the responses to the original post , I gave you the link:

http://tinyurl.com/75gwx

Clickin this latter link will take you to your post and all the resultant
responses.


---
Regards,
Norman



"banu" wrote in message
...
Gday Norman,
Thanks for your attention.
I really dont know where will I see the replies that i got for my previous
posts.
Any help Pls.
Thank you very much

Regards,
Banu

"banu" wrote:

I am having a big Excel sheet with about 800 rows and 58 Columns.Where
in I
have a Column Named IPNumbers. Basically as we might be knowing an IP
numbe
is represented like //163.259.081.234 //.I am trying to filter out the
Odd
and Even Numbered IP Numbered from the huge collection of list.I was
wondering If have to opt for the macro or a Custom Filter would be fine.
Any valid suggestions is greatly appreciated.
Thanks,
banu

Hi Norman,
Thanks Indeed for ur help.
Your Solution worked great for me !

Regards,
banu

"banu" wrote:

I am having a big Excel sheet with about 800 rows and 58 Columns.Where in I
have a Column Named IPNumbers. Basically as we might be knowing an IP numbe
is represented like //163.259.081.234 //.I am trying to filter out the Odd
and Even Numbered IP Numbered from the huge collection of list.I was
wondering If have to opt for the macro or a Custom Filter would be fine.
Any valid suggestions is greatly appreciated.
Thanks,
banu