Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pls. help
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... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pls. help
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). -- If this helps, please click the Yes button. Cheers, Shane Devenshire "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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|