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