Filter Function improvement


FILTER Function, many thanks to #Excel team, 
I have some suggestions to improve Filter function it will be better if you add the option to:

1) Extract many columns non-adjacents without using CHOOSE function

2) Extract Top or bottom n items without using LARGE or SMALL Functions

3) Using wildcards without using SEARCH or FIND Functions

What do you think ?

1 Reply


That's better to suggest at Welcome to Excel’s Suggestion Box! ( and within this thread ask people to vote if they agree.