N
nastech
With a hyperlink, is it possible to find a cell in a column, for the first
instance of a word starting with a letter, say "a" with something like?:
=HYPERLINK("[file.xls]sheet!(LEFT($A:$A,1)=$B$5)","goto")
where B5 has the letter A entered. Selecting a column seems to work with:
=HYPERLINK("[file.xls]sheet!A:A","goto")
Thanks
instance of a word starting with a letter, say "a" with something like?:
=HYPERLINK("[file.xls]sheet!(LEFT($A:$A,1)=$B$5)","goto")
where B5 has the letter A entered. Selecting a column seems to work with:
=HYPERLINK("[file.xls]sheet!A:A","goto")
Thanks