SlNo.

[Pai]

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

 

[Bob Phillips]

It looks like the criteria is when the number reaches a multiple of 100, is
that correct?

 

[Pete_UK]

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

 

[Pai]

Thanks For Quick Reply

I dont Know My boss want This Format

Hardeep kanwar