How can I use Filter for specified columns only. Here I have attached a excel file. There I want filter in Column C (field:TYPE) and in column E (field: STATUS). Thank you and hope to get solution.
How can I use Filter for specified columns only. Here I have attached a excel file. There I want filter in Column C (field:TYPE) and in column E (field: STATUS). Thank you and hope to get solution.
Have you tried a simple autofilter? Does that not do what you want?
This is an AND filter. However if you want an OR filter you'll need to use an Advanced Filter with a Criteria range.
Alternatively and more elegantly just apply a Pivot table to your data.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks