Find next occupied row up in another column
On Nov 16, 3:01 pm, "T. Valko" wrote:
Occupied with a text value.
the whole column is formatted as text
Ok, try this:
=IF(D2<"",ROW(),MATCH(REPT("z",255),D$1:D1))
Thanks, but this is working great:
=IF(D13375<"",ROW(),MATCH("ÿÿÿ",D$1:D13374))
Greg
|