Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

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
?
145 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

Question has a verified solution.

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

Outline Suppose you have some simple text based data in Excel that you would like to display as a PowerPoint presentation. Of course it would be possible to write some fairly complex VBA code that created a new slide for each line of the Excel data…
A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.

670 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