SlNo.

P

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
 
B

Bob Phillips

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top