On Mon, 19 Dec 2005 16:59:47 -0600, mevetts
wrote:


Hi,

Does anyone know of a formula that essentially looks to the cell next
to it and if there's text in it put a number in. The numer needs to be
one more than the one above it.

So the first in the list will place a 1, then in the next row the
number would be 2, then 3 and so on. But only if there is text in the
cell next to it.

Essentially I want a numbered list.

Can this be done?

Many thanks,

Mark.


An example:

A1: =IF(ISTEXT(B1),ROW(),"")

Enter text in B1.




--ron