On Mon, 19 Dec 2005 17:46:25 -0600, mevetts
wrote:


It's still not working.

I am beginning on row 58 using cols A and B.

So the formula goes in col A and the text will go in col B.

Does this help?

I specified the formula to start in A1.

If you start in some other row, you need to adjust it so the count reflects
that row. For example, starting in row 58, the formula would be:

=IF(ISTEXT(B58),ROW()-57,"")




--ron