find the value of the last non-empty cell in a column

[gkzeta]

hi
I try to update the last cell from column A. In the cell A1 I type the number 100, in the A5 number 200, a 25 150, a 80 number 29 and in cell A3 number 50. In A3 I made the last update and I want to show me in cell B1 the value 50 , where is the last updated cell.
I tried with the = VLOOKUP (1E + 99? A: A; 1) but it gives me the value from the last cell of the column.
with = INDEX (A:A; MATCH (TRUE; INDEX ((A:A < 0); 0); 0)) gives me the first cell of the column.
I don't want that. I want to find the last non-blank cell so that the B1 is updated automatically.

 

[Fluff]

If you want the last cell that data was entered into, you will need to have a time stamp in another cell.
Then you can use a formula to find the most recent time & pull the value from col A on that row.

 

[gkzeta]

thank you

 

[gkzeta]

A B C F
[TABLE="width: 539"]
<colgroup><col><col><col><col span="2"><col></colgroup><tbody>[TR]
[TD]15[/TD]
[TD]30[/TD]
[TD="align: right"]10:37:02 πμ[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]33[/TD]
[TD]=15+42[/TD]
[TD="align: right"]10:37:03 πμ[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]=57+33[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]64=44+20[/TD]
[TD="align: right"]10:37:06 πμ[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


i find the last cell from column a in the f1 cell =INDEX(A:A;MATCH(MAX(C:C);C:C;0))
now i want to sum the cell f1 with last cell not previous, in column b. when changes f1, then automatically sum with last cell in column b.
any suggestions?

 

[Fluff]

I'm afraid I don't understand what you are asking for. Nor do I understand where some of your numbers are coming from.

 

[gkzeta]

A B
5 11
10
30 15
40
I want when I type in column B the number to sum with the last cell in the first column.

A B
5 11
21 (10+11) the last number I typed was 10 in column A and made sum with last number in column B 11
30 15
55 (40+15) the last number I typed was 15 in column A and made sum with last number in column B 40

 

[Fluff]

Still don't understand, but this will add the bottom most value in col B with the last entry in based based on a time stamp in col C
=INDEX(A:A,MATCH(MAX(C:C),C:C,0))+LOOKUP(2,1/(B:B<>""),B:B)

 

[gkzeta]

Suppose in cell A1 I have a value of 10, in cell A2 I have a value of 20.
In cell B1 when I type the value 5 then in cell A2 which has the value 20 and it is the last cell in column A, and it sums the value 5 with 20 and display the result 25 in cell A2.
Then in cell A3 I have the value 15, in cell B2 when I type the number 4, and it sums with the cell A3, the last cell in column A (15+4=19), the result is in cell A3(19).
In cell A4 the value 18, in cell A5 the value 8, in cell A6 the value 19 (last cell in column A), when I type the value 12 in cell B4 then in cell A6 which has the value 19, it sums the value 12 with 19 and display the result 31 in cell A6 and then, i type in cell B5 the value 2, in cell A6 which has the value 31, it sums the value 2 and display the result 33 in cell A6.

 

[Fluff]

A cell can have either a value or a formula, but not both.
So it is not possible to do what you are asking.

 

[gkzeta]

O.K. thanks