Advanced Filter

Originally Posted by Marcelo Rychter

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