Forum Discussion
Arend
Jan 11, 2025Copper Contributor
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.
- ArendCopper Contributor
Thanks!
The formule only on the SEARCH tab.