How To - Creating a new list based on conditions

How To - Creating a new list based on conditions

Hello,

I am trying to "Creating a new list based on conditions" where I want to use DATA from Sheet A and a Criteria I define to build a new list on Sheet B. This is d emonstrated for MS Excel at:

http://www.excelforum.com/excel-formulas-and-functions/646118-creating-a-new-list-based-on-conditions.html#post1926757

How is this possible in ZOCO Sheet please?