Hi,
I have some data in Sheet1 Col a like below
Doc Refs:
123
153
123
empty row
125
empty row
1548
3584
1658
135
1564
empty row

I want to put values 1,2,3,4,5 etc in column B based on the data above, like below
Col A Col B
123 1
153 2
123 3
empty row
125 1
empty row
1548 1
3584 2
1658 3
135 4
1564 5
empty row and so on
that is populate 1,2,3,4,5, and so on till the empty rows, and again start 1,2,3,4,5,6,7, till the next empty rows and so on.

Arvind..