How do I number columns based on adjacent cells?
 

Hello,

Subj: Filling-in data based on adjacent cells.

I am using Microsoft Excel 2000. Here's my (autofill?) question...
I have data in some rows, others are vacant; e.g.,
Col 1 Col 2 Col 3

1 line two line two line two
2 line three line three line three
empty
3 line five line five line five
empty

My first question I suppose should be just how to number the lines within a
range. Anyhoo, as you see, my question is not to number every line within a
range* but rather to number only those lines that
have data in the next column.

Thank you, -John


*I am aware "Edit, Fill, Series" will number every line.
This is not what I am looking for. Can you help please?

How do I number columns based on adjacent cells?
 

Assume your data starts in B2.

Enter this formula in A2 and copy down as needed:

=IF(B2="","",COUNTA(B$2:B2))

Biff

"johnjesmer" wrote in message
...
Hello,

Subj: Filling-in data based on adjacent cells.

I am using Microsoft Excel 2000. Here's my (autofill?) question...
I have data in some rows, others are vacant; e.g.,
Col 1 Col 2 Col 3

1 line two line two line two
2 line three line three line three
empty
3 line five line five line five
empty

My first question I suppose should be just how to number the lines within
a
range. Anyhoo, as you see, my question is not to number every line within
a
range* but rather to number only those lines that
have data in the next column.

Thank you, -John


*I am aware "Edit, Fill, Series" will number every line.
This is not what I am looking for. Can you help please?