Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Dynamic line numbering formula does not reference new row after adding  a row in the table

Posted on 2015-01-06
2
Medium Priority
?
154 Views
Last Modified: 2015-01-07
Hello Experts,
Modify formula, col B, to refer to current row when a row is added to the table. The formulas in column B operate correctly until a row is added to the table using [Tab] or typing in the row below the bottom table row.  To correct the error, the formula in col B must be copied from a properly-referencing formula two rows above.  

Could a function using INDIRECT(row)-1 or similar approach work? Tried deleting the formulas, e.g.,
Col B problem formulas:
=IF([@[Action Items]]<>"",COUNTA(F$3:F15) & ".","")  <--Note there are double ending brackets  
Tried retyping them to have the same function construct as those in
col D which operate correctly after a new row is added:
=IF([@№]<>"",$H$1&"Ÿ.","")   <--Note there are single ending brackets in the OK Col D formulas.
File attached...
Thanks in advance
Berry
Action-Plan.xlsx
0
Comment
Question by:Berry Metzger
2 Comments
 
LVL 53

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 40534999
Hi,

pls try

=IF([@[Action Items]]<>"";COUNTA(INDIRECT("F$3:F"&ROW(B3)) )& ".";"")

Regards
0
 

Author Closing Comment

by:Berry Metzger
ID: 40535917
Great!  This solution works.  
Thanks a lot
Berry
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lately there has been a variety of news related to U.S. employment.  Stories about worker productivity, automobile and airline unions, low employment and foreign laborers have frequented the news.  Each story has good and bad attributes we might arg…
Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question