Forum Discussion
=SEARCH does not search all words in Name Box
I'm trying to automatically categorize my bank transfers with use of https://exceljet.net/formula/categorize-text-with-keywords. Unfortunately, I already get stuck at the =SEARCH formula. The follow...
Hi Thomas,
In single cell for the formula which returns an array you'll see only first element of that array. To return entire array first select the number of empty cells which is equal to the length of your keyword list and when enter the array formula in formula bar, like this