auto numbering of data with columns in between?

  • Thread starter Thread starter sachin
  • Start date Start date
S

sachin

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
 
Assuming Row1 with headers use this formula in A2.. and copy that down...

=IF(B2="","",MAX(INDIRECT("A1:A"&ROW()-1))+1)

If this post helps click Yes
 
put this in A2 and copy down
=IF(B2="","",MAX(A$1:OFFSET(A2,-1,0))+1)
 
You must log in or register to reply here.

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

Similar Threads

Tree from Parent/Child Pairs 1
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
How to calcuate 6 variable's contribution towards a fixed sum??? 2
Exchanging data 1
Excel Subtracting multiple columns from another column 3
Excel Countifs/Sumproduct with mutil Or statement 3
SumIF based on Multiple Conditions 7
Numbers from first column 5

Back
Top