No, this doesn't do what I want.

If Column 1 has dept X in rows 3,5,8 but also has dept X in column 2 rows 7,
12 & 14 - the firsy filter will only disply 3,5 & 8 and then the 2nd filter
finds nothing.

I need a filter which says something like " show all rows where cell value =
Dept x for Column 1 or Colum 2"

Thanks

"Per Jessen" wrote:

Select your entire table, goto Data Filter Autofilter.

Now select the department to filter for in column 1 and 2.


Regards,
Per

"Dave Eade" skrev i meddelelsen
...
but I want to look in both columns for the same value.

Column 1 has 20 different depts as 'inputs' adn column 2 has the same 20
as
outputs - I want to filter so that I can see all outputs / inputs for one
dept?

make sense?

Thanks