software

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: www.excelforum.com/member.php...oamp;userid=29130
View this thread: www.excelforum.com/showthread...hreadid=494746
Hi, how about:

=IF(B1gt;quot;quot;,COUNTA($B$1:B1),quot;quot;)

HTH
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=494746
Hi,

It is recognising if there's text or not, but it just keeps putting a 0
in the cell rather than starting at 1 and then going up by 1 each time,
ie. 1,2,3,4 etc...

Any ideas?--
mevetts------------------------------------------------------------------------
mevetts's Profile: www.excelforum.com/member.php...oamp;userid=29130
View this thread: www.excelforum.com/showthread...hreadid=494746On Mon, 19 Dec 2005 16:59:47 -0600, mevetts
gt; wrote:

gt;
gt;Hi,
gt;
gt;Does anyone know of a formula that essentially looks to the cell next
gt;to it and if there's text in it put a number in. The numer needs to be
gt;one more than the one above it.
gt;
gt;So the first in the list will place a 1, then in the next row the
gt;number would be 2, then 3 and so on. But only if there is text in the
gt;cell next to it.
gt;
gt;Essentially I want a numbered list.
gt;
gt;Can this be done?
gt;
gt;Many thanks,
gt;
gt;Mark.An example:

A1: =IF(ISTEXT(B1),ROW(),quot;quot;)

Enter text in B1.

--ron


Hi, did u ajust the formula to your needs?

=IF(B1gt;quot;quot;,COUNTA($B$1:B1),quot;quot;)

or

=IF(B1=quot;quot;,quot;quot;,COUNTA($B$1:B1)

where row 1 is the first row and column B is your text column?

JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=494746
That doesn't seem to work Ron, being new to formulas I'm not too sure
why?--
mevetts------------------------------------------------------------------------
mevetts's Profile: www.excelforum.com/member.php...oamp;userid=29130
View this thread: www.excelforum.com/showthread...hreadid=494746I think this might be what you're looking for:

=IF(ISTEXT(B2),COUNT($A$1:$A1) 1,quot;quot;)

This assumes that your count is in Column A, your text is in Column B, and
Row 1 is a header row or blank.

HTH,
Elkar

quot;mevettsquot; wrote:

gt;
gt; Hi,
gt;
gt; Does anyone know of a formula that essentially looks to the cell next
gt; to it and if there's text in it put a number in. The numer needs to be
gt; one more than the one above it.
gt;
gt; So the first in the list will place a 1, then in the next row the
gt; number would be 2, then 3 and so on. But only if there is text in the
gt; cell next to it.
gt;
gt; Essentially I want a numbered list.
gt;
gt; Can this be done?
gt;
gt; Many thanks,
gt;
gt; Mark.
gt;
gt;
gt; --
gt; mevetts
gt;
gt;
gt; ------------------------------------------------------------------------
gt; mevetts's Profile: www.excelforum.com/member.php...oamp;userid=29130
gt; View this thread: www.excelforum.com/showthread...hreadid=494746
gt;
gt;


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?--
mevetts------------------------------------------------------------------------
mevetts's Profile: www.excelforum.com/member.php...oamp;userid=29130
View this thread: www.excelforum.com/showthread...hreadid=494746
Ok....then:

=IF(B58=quot;quot;,quot;quot;,COUNTA($B$58:B58))
copied down

Regards
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=494746
Wahey!!

Thanks so much for your help....and patience!

All the best.--
mevetts------------------------------------------------------------------------
mevetts's Profile: www.excelforum.com/member.php...oamp;userid=29130
View this thread: www.excelforum.com/showthread...hreadid=494746