Forum Discussion
Restrict spill range when TextBox is empty using FILTER, ISNUMBER, SEARCH?
I am using a FILTER, ISNUMBER, SEARCH formula that is linked to a TextBox I am using to search the advTable of data.
When the search box is empty the entire data table spills out of Cell B6 (which is where the formula is placed).
Is it possible to hide the data that is spilling out of cell B6 while the search box is blank?
So that no data begins spilling into the search columns until the user begins typing into the search box? Any advice? Tips and Tricks?
exceltw What do you get when you just enter =ISBLANK(C2) is some other cell? And I wonder why you have a text box to begin with. Can't you just enter the search word in C2 directly?
7 Replies
exceltw Try this:
=IF(ISBLANK(C2),"",<formula>)
where <formula> is what you currently have in B6 excluding the =-sign.
Thanks Riny_van_Eekelen,
I tried your formula and the data from the formula in B6 continues to display/spill out.
I think this may be because the SearchBox hovering over C2 is linked to cell C2 so the logic of the ISBLANK(C2) formula is returning FALSE when nothing is in the SearchBox.
This is what has left me stumped.
exceltw What do you get when you just enter =ISBLANK(C2) is some other cell? And I wonder why you have a text box to begin with. Can't you just enter the search word in C2 directly?
