Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
105
Views
Topic starter
Not sure if I'm asking correctly, but... this is what I need to do (an example)
I have a user that wants to find a school with the words "western" "university" in them. (wildcard search basically). And I want the results to be below.
| Search | Results | |
| School Name | Western University | School1, School2, School4, School7 |
The data source is below
| School1 | Northwestern University |
| School2 | Junior University |
| School3 | Junior College |
| School4 | My University |
| School5 | That College |
| School6 | This College |
| School7 | Western College |
Is this even possible?
Thanks in advance!
Posted : 22/04/2022 2:53 pm
Hi Kenneth,
If you have Microsoft 365 you can use this formula:
=TEXTJOIN(", ",TRUE,FILTER(A4:A10,(ISNUMBER(SEARCH(B1,B4:B10))+ISNUMBER(SEARCH(B2,B4:B10)))))
See file attached.
Mynda
Posted : 23/04/2022 1:03 am
