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.