I want to search for specific letters in a word list and sort the words that contain those words.
The order of letters within a word is not important. I tried using this formula but it didn’t work for me.
This screenshot shows what I mean:
This is the link to the file:
Sheets link][Sheets link]
How can I correct this formula?
>Solution :
You may try:
=filter(A2:A,byrow(A2:A,lambda(Σ,sum(index(search(I3:K3,Σ))))))

