Product Ideas

Share your suggestions and ideas. Vote on ideas you find valuable.

NP(Eval After)

Often it is needed to create excel formulas which are refering to areas created by NL(rows) and table builder.   But when you reenter design mode these areas disapear and your formula gets #REF.   

So if it could be possible to create en aftercalc function, which is more or less build entirely as NP(EVAL), just put after instead of first in the joblist for jet. so you could do formulas looking into for example tables which will then be created first.  then the formula from the "eval after" could calculate results from the new generated table.  or you could always look a row number X  in the output of the NL rows  etc.  

would really be nice to have

  • Mike Seisbye
  • Dec 5 2018
  • Under Consideration
  • Attach files
  • Reinder Wolting commented
    April 04, 2019 14:13

    You can use the INDIRECT function of excel to refer to those kind of locations in text.

    This prevents excel from altering the formula when the location is removed.