Last year, I used a handy equation that allowed me to search rows of text strings for a variety of words i.e. university, université, college, collège... and then return a text value.
=IF(SUMPRODUCT(--ISNUMBER(SEARCH(Université,$S2))),"Université","").
I had a variant where I used a search range, which allowed me more flexibility. Do you think I can replicate this no!!! Sometimes it can be infuriating to work with Excel.
Any thoughts?
Bookmarks