Forum Discussion

Arend's avatar
Arend
Copper Contributor
Jan 11, 2025

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.SPEC(A1;Table_1[Name]&“*”&Table_1[Zip Code]&“*”&Table_1[City] )))); “Nothing found”)

Unfortunately, I get a return message ifl I search in a programmed search field for, say, PLACE OF RESIDENCE the message #Overflowing! in Dutch #OVERLOOP!

In addition, I cannot center the text in the SEARCH FIELD vertically. For that, all options in the TAB START are all in gray; NOT available to make changes.

I don't know now what I am doing wrong.
Can you help me?

Thanks for any suggestion.

  • 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.

  • 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

      Thanks!

      The formule only on the SEARCH tab.

       

Resources