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

gkzeta

New Member
Joined
Mar 15, 2019
Messages
10
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.
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,637
Latest member
Ezio2866

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top