Hi Anand,

I think your need is not supported by Excel filters. Maybe the
solutions for your problem is a VBA code which perform the logic tests
and produce a new spreadsheet with the result or a list box, depending
on the number of rows selected.

Marcelo Rychter
Hi Marcelo Rychter,
Thanks for the rely
I feel that this could be solved by using Advanced filter, but since it
has more than one column I am having doubt as to how to set the
criteria..... Does anybody have an idea on resilving this through
Advanced filter rather than a VBA code.

Thanks & Regards
Anand


--
anandmr65
------------------------------------------------------------------------
anandmr65's Profile: http://www.excelforum.com/member.php...o&userid=30728
View this thread: http://www.excelforum.com/showthread...hreadid=548449