Search a range for instances of a text string, return neighboring cell values each ti
Please see attached worksheet. For each "nth" instance of a particular text string appearing in a range (a column), I'd like to return the value of the cell to it's left (in the same row).
|