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