SlNo.
 

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

SlNo.
 

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

--
__________________________________
HTH

Bob

"Pai" wrote in message
...
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

SlNo.
 

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

SlNo.
 

Thanks For Quick Reply

I dont Know My boss want This Format

Hardeep kanwar


"Bob Phillips" wrote:

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

--
__________________________________
HTH

Bob

"Pai" wrote in message
...
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