I have an Excel spreadsheet page that contains a text string in a certain row. I know the column, but the row can change.
I need a non-VBA method of searching through the page and finding the row # of the row containing that string.
what is the command that will scan through col A and locate the row number (5) of the row containing ODC?
this can’t use VBA. It needs to run on PCs, Mac, and with OpenOffice.