put this in A2 and copy down
=IF(B2="","",MAX(A$1:OFFSET(A2,-1,0))+1)

"sachin" wrote:

Pls. help me in lenier numbering of data where there are discontinuities in
between...

Store No. Store Grade

A

B
B
B

C
C
C
C
C

D
D
D
D
D

E
E
E
E
E