Quattro Pro Linking Formula

I would like to write a formula which would link to the last number in a 
column.  The purpose of this would be to update a graph or summary.

Can anyone help me?

Thanks.

Stu Culp 

Stuart Culp wrote:
> I would like to write a formula which would link to the last number in a 
> column.  The purpose of this would be to update a graph or summary.
> 
> Can anyone help me?

While the quick answer to your question is @LASTCELLVALUE (which returns the 
value of the last number in a column or row), this will hardly be useful for 
your stated purpose.  To keep a graph or summary in an updated status, you have

a number of options, but none of them involve an isolated link to the last 
number in a column, per se.

The most straightforward method is to design your layout with a designated empty

row at the bottom of the column, such that the last empty row is always INCLUDED

in any summary formula and graph series.  Any new data would then be added by 
inserting new rows ABOVE the designated last row, thereby insuring that any 
summary formulas and graph series are automatically updated to reflect added
data.

An alternate method involves the use of named ranges in formulas and graph 
series, which will then require a deliberate update of the extent of these 
ranges, normally executed via macro.

A third method involves using @OFFSET in conjunction with a summary formula, but

this will have no application for graph series.

Cheers,
Uli

Stuart:
> I would like to write a formula which would link to the last number in a 
> column.  The purpose of this would be to update a graph or summary.

You wish to refer to the last Cell only?
Will the contents/range of the referenced column change?
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)