Finding Text within an Array
I have an array (A1:A25) and I have written a formula in each cell that
ensures only one cell will populate with text. All other cells that do not
match the criteria will populate as blank cells.
My question is, how would I go about searching for the cell that contains the
text and then returning the text from the cell?
You could concatenate all the cells. Since only one is non-blank, that returns its text.
|