Try...

=LOOKUP(9.99999999999999E+307,FIND("-",A2:A100),ROW(A2:A100))

--
Domenic
Microsoft Excel MVP
www.xl-central.com
Your Quick Reference to Excel Solutions

In article ,
dhstein wrote:

Thanks teethless and Domenic. That's great - but I don't want the value - I
want the row number. How could I get that ?



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