Find the last cell in a column which contains "-"
=LOOKUP(2,1/(ISNUMBER(FIND("-",A:A))),A:A)
"dhstein" wrote:
I have a column of values that contain text like XX-YY, ZZZ-DD4, etc. I want
to find the last row of the column that has a "-". Is there a function I can
use to find this (maybe SUMPRODUCT ?). Thanks for any help with this.
|