Lookup, return value in first column if other2 collumns meet condition

[TVB]

Version: 2008

Hi!

I have a worksheet that has 3 columns: Column A contains ticker symbols, B contains a value, and C contains a value.

I need Excel to list all the unique ticker symbols that meet two conditions: the value in column B is less than 1.5 and the value in column C is greater than .5.

How do I do this?

 

[JE McGimpsey]

Version: 2008

Hi!

I have a worksheet that has 3 columns: Column A contains ticker symbols, B
contains a value, and C contains a value.

I need Excel to list all the unique ticker symbols that meet two conditions:
the value in column B is less than 1.5 and the value in column C is greater
than .5.

How do I do this?

Easiest way:

Use Data/Filter/Autofilter to filter the list. In the dropdown in column
B, choose Custom Filter. In the Filter dialog, choose "less than" from
the dropdown and enter 1.5 in the input box.

Similarly, filter column C for "greater than" and 0.5.