Filter Function in Excel 2019

Copper Contributor

Hello All,

Microsoft informs that the FILTER function is available not only for 365, but as well for 2019. (=Filter Funktion: Excel für Microsoft 365 Excel für Microsoft 365 für Mac Excel für das Web Excel 2021 Excel 2021 für Mac Excel 2019 Excel für iPad Excel für iPhone Excel für Android-Tablets Excel für Android-Smartphones)

I cannot find the function, my MS-Office should have all updates .


When I write FILTER, excel comes back with FILTERXML only. 


Is there a special way to "activate" the new function?

Thanks for your help!

2 Replies


The documentation is incorrect. FILTER is only available in Microsoft 365 and Office 2021, not in Office 2019 and earlier versions.


Thanks, then it is clear now ... what a pity..