ExcelBanter - auto numbering of data with columns in between?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - auto numbering of data with columns in between? (https://www.excelbanter.com/excel-discussion-misc-queries/230085-auto-numbering-data-columns-between.html)

Sachin

auto numbering of data with columns in between?

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

Jacob Skaria

auto numbering of data with columns in between?

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
---------------
Jacob Skaria

"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

EricBB

auto numbering of data with columns in between?

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

All times are GMT +1. The time now is 01:37 AM.