pls. help

[EricBB]

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$1ffset(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$1ffset(A2,-1,0))+1 to work with the
above. pls. help...

 

[Shane Devenshire]

Suppose you enter a set of numbers (the values are unimportant) in a column
out of the way, say Z1:Z100, then in A2 you enter

=SUBTOTAL(102,Z$1:Z2)

copy this down and it will not "break" when you hide a row(s).