Dec 21 2022 01:15 PM - edited Dec 21 2022 01:23 PM
Hi,
Can anyone help me out with this very basic scenario involving a search box.
I have added a snippet but cannot understand why its not filtering when trying to search "Advisor Name".
any ideas please? sorry, completely new to Excel here.
Dec 21 2022 01:57 PM
Dec 21 2022 01:59 PM
SolutionDec 21 2022 02:03 PM
Dec 21 2022 02:21 PM
Dec 21 2022 02:36 PM
Dec 21 2022 04:03 PM
=IF(ISBLANK(H2),"",FILTER(Gradbay,ISNUMBER(SEARCH(H2,Gradbay[Advisor Name])),"No Record"))
Dec 21 2022 01:59 PM
SolutionTry this:
=FILTER(Gradbay,ISNUMBER(SEARCH(H2,Gradbay[Advisor Name])),"No Record")