How to find text in a range of cells?
You could always search with [ctrl]+F and type in what you're looking for.
It'll take you to wherever it is in the document, and you should be able to
see the column and row from there.
"r.e.s." wrote:
Can someone please put me out of my misery? ...
Suppose each cell in a range contains a single letter,
and the letters are all distinct. Is there a way to
use workbook functions (not a macro) to find the row
& column of the cell that contains a pariticular letter?
|