Home

Excel support for Filter function

%3CLINGO-SUB%20id%3D%22lingo-sub-1124252%22%20slang%3D%22en-US%22%3EExcel%20support%20for%20Filter%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1124252%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20seen%20Filter%20function%20in%20google%20excel%20sheets.%20In%20which%20version%20of%20office%20support%20this%20function%3F%20I%20was%20not%20able%20to%20use%20this%20function%20in%20my%20system%20excel.%20This%20is%20really%20a%20nice%20feature.%20I%20need%20it%20for%20my%20office%20purpose.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1124252%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1124266%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20support%20for%20Filter%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1124266%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F529498%22%20target%3D%22_blank%22%3E%40Gayathri01%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20how%20you%20add%20a%20filter%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20429px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F166720i4D1F9E14A0A32051%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222020-01-23_08h07_21.png%22%20title%3D%222020-01-23_08h07_21.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1124887%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20support%20for%20Filter%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1124887%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F529498%22%20target%3D%22_blank%22%3E%40Gayathri01%3C%2FA%3E%26nbsp%3BFILTER()%20function%20is%20available%20on%20monthly%20channel%20for%20Excel%20Desktop%20and%20for%20Excel%20Online%20for%20Office%20365%20subscribers.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have seen Filter function in google excel sheets. In which version of office support this function? I was not able to use this function in my system excel. This is really a nice feature. I need it for my office purpose.

2 Replies
Highlighted

Hi @Gayathri01 

 

This is how you add a filter

2020-01-23_08h07_21.png

Highlighted

@Gayathri01 FILTER() function is available on monthly channel for Excel Desktop and for Excel Online for Office 365 subscribers.

Related Conversations
How to Remove the Table
Tim18283848585 in Excel on
0 Replies
Excel problem
Vinni420 in Excel on
0 Replies
Remove #SPILL! in Excel web version
Rebecca_Elle in Excel on
0 Replies
Using Table Headers as ranges in Data Validation
prabutr28 in Excel on
0 Replies
VLOOKUP with 2 conditions
Leanne2490 in Excel on
1 Replies