Sequential Numbering

E

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pls. help 1
How to print an A4 document to 2 A5s 0
How to delete ALL cells containing the same data --- REVISED 0
IF Function Question 2
Search cell value in same column 3
Paragraph numbering in Word 1
Removing Sequential Numbers 5
Dynamic pointing to a cell 0

Top