Excel formula
 

I am looking for a formula that will give me an increasing number in a cell
if there is a value (words) in a corresponding cell, and a blank if there is
nothing in the cell. Any ideas?
--
Michelle

Hi Michelle

With your data in Column A starting in Row 2. In B2 enter:

=IF(A2="","",SUMPRODUCT(--($A$2:A2<"")))

and copy down to end of data.

Does this help?

Regards
Rowan

"Michelle" wrote:

I am looking for a formula that will give me an increasing number in a cell
if there is a value (words) in a corresponding cell, and a blank if there is
nothing in the cell. Any ideas?
--
Michelle

Let B3:B7 house

dfa
wqa
=""

xsa

where B5 is "", resulting from a formula and B6 empty.

In A1 enter a 0.

In A2:B2 enter the appropriate headers.

In A3 enter & copy down:

=IF(B3<"",LOOKUP(9.99999999999999E+307,$A$1:A2)+1 ,"")

Note that a formula-blank is treated in the same way as an empty cell.

Michelle wrote:
I am looking for a formula that will give me an increasing number in a cell
if there is a value (words) in a corresponding cell, and a blank if there is
nothing in the cell. Any ideas?

Thank you - that works perfectly, although I don't understand how the
SUMFUNCTION part of it works.
--
Michelle


"Rowan" wrote:

Hi Michelle

With your data in Column A starting in Row 2. In B2 enter:

=IF(A2="","",SUMPRODUCT(--($A$2:A2<"")))

and copy down to end of data.

Does this help?

Regards
Rowan

"Michelle" wrote:

I am looking for a formula that will give me an increasing number in a cell
if there is a value (words) in a corresponding cell, and a blank if there is
nothing in the cell. Any ideas?
--
Michelle