Hi,

I have a list of numbers example,
In a2
1
2
1
3
3
4
2
2
2
What I want to do is create a combo box in a1 that has a list 1, 2 ,3, 4.
Once the user select e.g. 1 , auto filter will be applied on the range from
a2 to €¦.. showing only cells that have 1 . how to do that??