Forum Discussion
Filter Function
Morning I am using Microsoft Office 365, suddenly the Function "Filter" is Excel is not working. There is an expression (_xlfn._xlws) appeared in front of a formula. I searching on this expression a...
The _xlfn._xlws prefix in your formula means that your version of Excel does not support the FILTER function. This can be happens if:
You opened the file in an older version of Excel (Excel 2019, 2016, or earlier), which does not support FILTER. If using older Excel, replace FILTER with SUMIFS or SUMPRODUCT.
or…
Your Office 365 installation is outdated and needs an update to restore FILTER. .
My answers are voluntary and without guarantee!
Hope this will help you.