# Getting the last Value of a dynamic column

Here is a small example

    A     B         C           D


1 45 33 (+A1+B1) 1

2 23 12 (+A1+B1) 12

3 12 21 (+A1+B1) 76

4

Okay what I am trying to do is Get the last value of Column A and C.

Here is what I have

For the value of A I use this =INDEX(A1:A999,COUNTA(A3:A999)) And returns 12, which is right, so if I add another number in column A, that value will be returned (up to 999)

Now I can't seem to make that work for column C as it contains a function, technicaly I want it to return 33 as per that example.

edit retag close merge delete

Sort by » oldest newest most voted

(Why didn't you tell us what your formula actually returns . It mostly is useless to tell that a specific thing did not happen. If happened what you wanted to achieve you hadn't posted a question at all, I suppose.)

Suppose the formula in C1 is "=A1+B1" and filled down into the subsequent cells, thus adapted to "=A2+B2" and so on.

To get your results also for row 999 (?) as you want for some reason, there must also be the formula "=A999+B999" in C999. Since blank cells are treated with a numerical value 0 in this case, all the rows not yet filled in A and B will contain a result of 0, whether they display it or not (which an option exists for against reason).

Anyway: In your C1:C999 every cell will contain something and COUNTA will therefore return 999 for column C if used in the same way as for column A.

Solution: A row is either filled or not. Therefore find "the last filled row" only for column A and use the result for any column you want "the last value" from. To avoid complications you have to fill the rows without gaps, anyway.

The attached example should demonstrate possible solutions (and a few possible errors, too). ask59840ValuesFromBottommostRow001.ods

more I think the issue is you have enter what you call a function (+A1+B1) without a '=' or a sign '+' before it so it is taken like text not as a formula.

Enter =(+A1+B1) or +(+A1+B1) or +A1+B1 so it is taken and evaluate as a formula.

more