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


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