Using INDIRECT to refer to cells on Analyse-it analysis reports - Analyse-it® blog
Summary
As an example, suppose you have used Analyse-it linear regression to calculate the linear relationship between installation cost and the number of employees required, distance to the site, and the cost of machine being installed. You might setup a worksheet to predict and quote installation costs for future jobs. You could use an Excel formula to reference the coefficients directly from the Analyse-it report, for example: By directly referencing the coefficients calculated by Analyse-it in your formula, you can be sure you’re using the exact values with no chance of error. The reason the cells no longer exist is because when you click Refresh, Analyse-it repeats the analysis, creates a new report worksheet to present the statistics and charts, then finally deletes the old worksheet and replaces it with the new. The cell references are broken when Analyse-it deletes the old report worksheet.
Classifications
AskAI Classifications
LabelsLinked Companies
