On Nov 16, 2:29 pm, "T. Valko" wrote:
*Assuming* the data is numeric *and* the values will *always* be <1000:
=IF(D2<"",ROW(),ROW(INDEX(D:D,MATCH(1000,D$1:D1)) ))

We can even reduce that further to:

=IF(D2<"",ROW(),MATCH(1000,D$1:D1))

Thanks, I changed that to this to work with text:

=IF(D13375<"",ROW(),MATCH("ÿÿÿ",D$1:D13374))

And it works great. Pretty fast too.

The "ÿ" is ascii 255.

Greg