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.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=494746