Search for Text within a Range of String, Return IQR of Corresponding Cells

Read up on the SEARCH() function (F1 in Excel). It finds a string inside another string. So no need to do "*r*".... "r" is enough to search. But you tried it by now, right?

Please reread post #3.