Hi Banu,

conditions like:

should read:

Criteria like:

---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi Baru,

Extract even and odd IP addresses using the Advanced filter with
conditions like:
:=MOD(RIGHT(A2,1),2)=0 (Even)
=MOD(RIGHT(A2,1),2)=1 (Odd)

If you are not familiar with the advanced filter feature, see Debra
Dalgleish's tutorial at:

http://www.contextures.com/xladvfilter01.html

---
Regards,
Norman