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

1. 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?

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

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>

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

Try

=LOOKUP(9.999999999E+307,A1:A12)

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

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.`

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

Great, thanks for that! I went for Kevin's one in the end.

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

Great

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1