Ask Your Question

Getting the last Value of a dynamic column

asked 2015-10-22 02:51:01 +0100

danieloLO gravatar image

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


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 flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2015-10-23 01:57:08 +0100

Lupp gravatar image

updated 2015-10-23 02:01:36 +0100

(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

edit flag offensive delete link more

answered 2015-10-23 01:01:03 +0100

m.a.riosv gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-10-22 02:51:01 +0100

Seen: 178 times

Last updated: Oct 23 '15