filtering a list depending on corresponding row in another column

  • Thread starter Thread starter Dave the Man
  • Start date Start date
D

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
 
Back
Top