Numbering column A

[Noir]

On my spreadsheet Column B has a series of data and every so often there is a blank row (to separate the data). I would like to use column A to place a number next to each data row in column B but, do not want the blank rows to be numbered. I tried to use "FILL" but, it numbered the blank rows.

Please advise.

Thx,
Noir

[Audiojoe]

How big do the gaps get? One cell? Two cells? More?

[Aladin Akyurek]

On 2002-04-03 08:27, Noir wrote:
On my spreadsheet Column B has a series of data and every so often there is a blank row (to separate the data). I would like to use column A to place a number next to each data row in column B but, do not want the blank rows to be numbered. I tried to use "FILL" but, it numbered the blank rows.

Please advise.

Thx,
Noir

In A2 enter and copy down:

=IF(LEN(B2),MAX($A$1:A1)+1,"")

where A1 is an empty cell.

[Noir]

Thanks Aladin. Worked perfectly!!

Noir

[AJ]

Or, if you prefer a VBA approach...

Sub test()

Lastrow = Range("B65536").End(xlUp).Row
Range("A1").Select
MyRow = ActiveCell.Row

MyCounter = 1

While MyRow <= Lastrow

Range("A" & MyRow).Select
If ActiveCell.Offset(0, 1).Value <> "" Then
ActiveCell.Value = MyCounter
MyCounter = MyCounter + 1
End If
MyRow = MyRow + 1

Wend

Rgds
AJ

[Noir]

AJ how do you initiate your solution?

Noir