| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sequential Numbering
You just did.
adam08200 wrote: How do you ask a question on this site? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sequential numbering | Excel Worksheet Functions | |||
| Sequential numbering by 6 | Excel Discussion (Misc queries) | |||
| Sequential numbering | Excel Discussion (Misc queries) | |||
| PO with sequential numbering with start / end numbering | Excel Discussion (Misc queries) | |||
| Sequential numbering | Excel Worksheet Functions | |||
Linear Mode
