Filter Function improvement

%3CLINGO-SUB%20id%3D%22lingo-sub-2071139%22%20slang%3D%22en-US%22%3EFilter%20Function%20improvement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2071139%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EFILTER%20Function%2C%20many%20thanks%20to%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Ffeed%2Fhashtag%2F%3Fkeywords%3Dexcel%26amp%3BhighlightedUpdateUrns%3Durn%253Ali%253Aactivity%253A6756944349029773312%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%23Excel%3C%2FA%3E%3CSPAN%3E%26nbsp%3Bteam%2C%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI%20have%20some%20suggestions%20to%20improve%20Filter%20function%20it%20will%20be%20better%20if%20you%20add%20the%20option%20to%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E1)%20Extract%20many%20columns%20non-adjacents%20without%20using%20CHOOSE%20function%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E2)%20Extract%20Top%20or%20bottom%20n%20items%20without%20using%20LARGE%20or%20SMALL%20Functions%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E3)%20Using%20wildcards%20without%20using%20SEARCH%20or%20FIND%20Functions%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EWhat%20do%20you%20think%20%3Athinking_face%3A%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2071139%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2072350%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20Function%20improvement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2072350%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F933127%22%20target%3D%22_blank%22%3E%40MouraData%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20better%20to%20suggest%20at%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EWelcome%20to%20Excel%E2%80%99s%20Suggestion%20Box!%20(uservoice.com)%3C%2FA%3E%26nbsp%3Band%20within%20this%20thread%20ask%20people%20to%20vote%20if%20they%20agree.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

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

@MouraData 

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