Need a formula to return the last (i.e. lowest row) value entered into a table

I have a table with twelve rows in it. The user can enter numbers into any or all of the rows in the table, and would be expected to enter the figures in a group of rows next to each other e.g.

Row 1 - £316
Row 2 - £274
Row 3 - £352

would return £352

or

Row 6 - £310
Row 7 - £220
Row 8 - £265

would return £265

I can use nested IF statements to work my way up the table from the bottom until I find a figure more than zero, but I can only use 7 nested IF statements. Is there another way I can do this?

Hi ianpwilliams,

Use below formula to fetch last value entered in column a:-

=OFFSET($A$1,COUNTA(A:A)-1,0)

Regards,
DILIPandey
<click on below * if this helps>

Hi ianpwilliams

Assuming your data table of 12 rows is in A1:A12, try the following.

Formula:

Please Login or Register  to view this content.

Great

Please mark this thread as [SOLVED].. thanks.


Regards,
DILIPandey
<click on below * if this helps>