Insert two blank rows at the top of your data, and put 1 in B1. Then
put this formula in B3:

=IF(A3="","",IF(A2="",100+INT(B1/100)*100+1,B2+1))

and then copy down. It will result in something like this:

101
102
103
104
105

201
202
203
204

301
302
303
304
305
306

401
402
403
404

Hope this helps.

Also, check out your other post.

Pete

On Dec 10, 11:14*am, Pai wrote:
I have a Data in Column A

i want to Give the Number like this

1
2
3
4
5
Blank
101
102
103
104
Blank
201
202
203
204
205
Blank
301
302
303
304
305
306
And So on

Thanks in Advance

Hardeep kanwar