Forum Discussion

Arend's avatar
Arend
Copper Contributor
Jan 11, 2025
Solved

FILTER problem in Excel 365

I am facing a filter problem. - I have created a table called Table_1. This table is on the tab TABLE In addition, the filter below is on the SEARCH tab =ALS.ERROR(FILTER(Table_1;NOT(ISFOUT(FIND....
excel
  • HansVogelaar's avatar
    HansVogelaar
    Jan 13, 2025

    Did you create the formula in a table on the SEARCH sheet? That won't work - a formula in a table cannot return a result to multiple cells.

    So you'll have to enter the formula in a cell outside a table, in an ordinary range.

    As for the other problem: make sure you're not editing the cell while you try to change the alignment, and also that the worksheet is not protected.

HansVogelaar's avatar
HansVogelaar
MVP
Jan 13, 2025

Did you create the formula in a table on the SEARCH sheet? That won't work - a formula in a table cannot return a result to multiple cells.

So you'll have to enter the formula in a cell outside a table, in an ordinary range.

As for the other problem: make sure you're not editing the cell while you try to change the alignment, and also that the worksheet is not protected.

  • Arend's avatar
    Arend
    Copper Contributor
    Jan 14, 2025

    Thanks!

    The formule only on the SEARCH tab.

     

Resources