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