Forum Discussion
Solved
Activex Search box
Hello everyone, I created a search box using activex box with a filter function to search for various text in a table. The issue I have is, when the search box is empty it displays the entire table...
LouP629 One option is to use
=IF(FILTER('2022 Submissions'!A3:V799,(G1<>"")*(LEFT('2022 Submissions'!C3:C799,LEN(G1))=G1),"No records Found!!!")="","",FILTER('2022 Submissions'!A3:V799,(G1<>"")*(LEFT('2022 Submissions'!C3:C799,LEN(G1))=G1),"No records Found!!!"))
Another is not to show zero values, in File > Options > Advanced > Display options for this worksheet:
Question, Is there a way to leave search results blank instead of populating with zeros?
I have blank fields and they get populated with zeros, not a big deal but would be cleaner!
I have blank fields and they get populated with zeros, not a big deal but would be cleaner!
LouP629 One option is to use
=IF(FILTER('2022 Submissions'!A3:V799,(G1<>"")*(LEFT('2022 Submissions'!C3:C799,LEN(G1))=G1),"No records Found!!!")="","",FILTER('2022 Submissions'!A3:V799,(G1<>"")*(LEFT('2022 Submissions'!C3:C799,LEN(G1))=G1),"No records Found!!!"))
Another is not to show zero values, in File > Options > Advanced > Display options for this worksheet:
- works great, again thank you