|
PureBytes Links
Trading Reference Links
|
I wish to use the last value in a column as a divisor in a formula. I have a
column of 900 cells. Not all of them always contain values, and the values
change (given another event), although there aren't any nulls between
values. For example:
A1 value1
A2 value2
A3 null
A... null
A900 null
My formula is x/A2. How do I discover that A2 contains the last value in the
column?
Another example:
A1 value1
A2 value2
A3 value3
A4 null
A... null
A900 null
How do I discover that A3 contains the last value in the column?
I looked at Kim's and Alex's suggestions, but couldn't get them to work.
Also couldn't find reference to some of the components in help.
Thanks
Colin
|