I need a formula that will search a range of blank cells for the one that
includes text and report that text in a cell. For example, my range is A1:IV1
all are empty except for one cell that will change position within that range
depending on other criteria. I need that text to be found and reported in
cell A2. I tried the "T" function and it works as long as the text filled
cell is at the beginning of the range.
--
Many thanks