Hi Brainiacs,
Need your help again.
=TRANSPOSE(FILTER(A:A,ISNUMBER(SEARCH('New starters'!$C30,A:A)),"No Results"))
I am trying to hide the search results if 'New starters'!$C30 is a blank cell, at the moment it is populating the entire list in the transpose and I don't want it to do that.
Sadly where I work they don't yet have the excel build to search large data validation lists, so having to create a searchable list, but it means saving the excel sheet takes a couple seconds (which is huge from the split second it normally takes us to save a doc)
Unfortunately I can't create a dud sheet to upload, so hoping the above is enough.
Bookmarks