Auto Filter by Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for a way to have the data auto filtered according to the
criteria.
For example, I have data as following:
1
1
2
2
3
4

I have another cell for criteria input. If users input "2" in the cell.
The those data are not "2" will be filtered out.
Can I have a way by using excel functions only? Or Macro is needed?
Thanks all.
 
Check the Advanced Filter (Data > Filters > Advanced Filter...). Its
arguments are the data range plus a criteria range. You'd set the criteria
range to be two rows by one column, with the first cell containing the column
header (it must match the corresponding header in your data table) and the
second cell the selected value. (Advanced filters allow more complex and/or
criteria, but it doesn't sound like you need that yet).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Filter function only provide 2 criteria input 5
remembering the same filtering criteria 13
Select rows which satisfy 2 criteria 16
VBA: How can I use a string variable as autofilter criteria? 4
Excel Need Countifs Formula Help 0
Macro - How to not copy blank criteria? 1
Data validation list & vlookup 4
VBA to Filter on variable column 5

Back
Top