Excel support for Filter function

Copper Contributor

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

Hi @Gayathri01 

 

This is how you add a filter

2020-01-23_08h07_21.png

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