As long as you know the column is A, you can use MATCH to find the row number:
="A"&MATCH("m",A1:A26)
returns A13
"m" is in row 13 of col. A
HTH
Bruce
As long as you know the column is A, you can use MATCH to find the row number:
="A"&MATCH("m",A1:A26)
returns A13
"m" is in row 13 of col. A
HTH
Bruce
Bruce
The older I get, the better I used to be.
USA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks