Forum Discussion
Solved
Excel Formula
Hello, I am using Excel 2016 and need to use the "Filter" formula; however, I learned from the internet that this formula is not available for the 2016 version. Then I found an alternative one which...
Your formula is probably an arrayformula which has to be entered with ctrl+shift+enter in Excel 2016.
I have Excel 2013 and the formula returns the value error in the cell until i click in the formula bar and confirm the formula with ctrl+shift+enter.
When i click the fx button the formula already shows the expected result.
Your formula is probably an arrayformula which has to be entered with ctrl+shift+enter in Excel 2016.
I have Excel 2013 and the formula returns the value error in the cell until i click in the formula bar and confirm the formula with ctrl+shift+enter.
When i click the fx button the formula already shows the expected result.
- OliverScheurich
I really thank you for your prompt reply and successful proposal. You solved my problem once.
