Thanks - used "MATCH" function and your function to get the last row - thanks
again



"Teethless mama" wrote:

=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.