Filtering two text columns at the same time - Microsoft Community

i want combine filter 2 text columns. @ moment when filter 1 hides data want filter other.

basically have 2 coloums buy & sell , example compnaies called a,b,c,d. want filter transcations company b! can work out how filter 1 column it'll hide transcations other  

         buyer     seller
1.                          c
2.       b                    a
3.       b                    d
4.       c                   b


appreciated   

hello matt,

you can filter data on both columns @ same time using advanced criteria. check link more information , detailed steps can resolve concern.

don’t hesitate update thread if have further questions.

Office / Excel / Windows 10 / Office 2010