ExcelBanter - Sequential Numbering

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

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

- - Sequential Numbering (https://www.excelbanter.com/excel-discussion-misc-queries/238161-sequential-numbering.html)

EricBB

Sequential Numbering

hi there,
i have a sequential numbering starting in A2 as below;
A2-1
A3-2
A4-3
A5-4
A6-5
so far im using the =max(A$1:offset(A2,-1,0))+1 which is working great. my
problem is if i want to hide the A3 the sequential numbering will not break.
i mean,
A1-1
A2 is hide
A3-2
A4-3
A5-4
How can I modify this formula =max(A$1:offset(A2,-1,0))+1 to work with the
above. pls. help...

adam08200

Sequential Numbering

How do you ask a question on this site?

"EricBB" wrote:

hi there,
i have a sequential numbering starting in A2 as below;
A2-1
A3-2
A4-3
A5-4
A6-5
so far im using the =max(A$1:offset(A2,-1,0))+1 which is working great. my
problem is if i want to hide the A3 the sequential numbering will not break.
i mean,
A1-1
A2 is hide
A3-2
A4-3
A5-4
How can I modify this formula =max(A$1:offset(A2,-1,0))+1 to work with the
above. pls. help...

Bob I

Sequential Numbering

You just did.

adam08200 wrote:

How do you ask a question on this site?

All times are GMT +1. The time now is 02:59 PM.