Always custom filter equal to or greater than.

[GordieT3]

I need to filter columns. The auto filter does what is chosen and if I use a custom filter I can get what I need for one value.

What I need is no matter what value is selected in the filter I need it to always show equal to or greater than the selected value.

 

[nbrcrunch]

Yes, that is an option in the filter list options. What is the question?

 

[GordieT3]

I need it to custom filter without having to edit the customer filter every time.

Lets say I'm comparing specs of a product.

Specs:
1
1.1
1.2
1.3
1.5
2.1
2.2

and so on

So in the filter when I select 1.3 I want to see 1.3 and greater. Then I select 2.1 I want to see 2.1 and greater without having to go back and change the custom filter.

This will always be the case where we will always want to see the selected spec and those greater than.

 

[nbrcrunch]

See if any of these videos can help. Essentially, they explain Excel's Advanced Filter option

http://www.youtube.com/results?search_type=&search_query=excel+advanced+filter&aq=f