Forum Discussion

mustafabagci's avatar
mustafabagci
Copper Contributor
Dec 15, 2022
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 is a combination of several different formulas.

When I enter the formula to the cell, it gives error and shows "#VALUE!" in the cell. However, when I click on the fx button next to the formula bar, I can see the correct result. How is it possible?

I appreciate anyone's help who solves my problem.

 

excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Dec 15, 2022

    mustafabagci 

    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.

     

2 Replies

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Dec 15, 2022

    mustafabagci 

    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.

     

Resources