filtering a list depending on corresponding row in another column

[Dave the Man]

Right, I'll try and be as clear as possible. I'm not very advanced a
using Excel so what I want might be very simple.

I have a column with a list of numbers in it. I want the values to b
displayed in another list depending on whether there is somethin
written in a corresponding row in another column on the worksheet.

For example: if e6 = "1" and h6 = "yes" then I would want that value t
be in a new list. But if e6 = "1" and h6 ="" then I wouldn't.

I hope you see what I mean. Any help would be appreciated. Cheers

 

[Peo Sjoblom]

Use data>autofilter and filter on 1 and yes in the respective columns