Question

Locked

Excel: Cells Update automatically from last entry

By sa3dos ·
I have a large spread sheet with two tables, one table is for "summary" and the second table is for "data entry". I want one of the cells (in the summary table) to be able to read the last value entered in the "data entry table". For example: Cell I8 currently display the same entry as U37 (using the simple equation of =U37) when I input an entry to U38, I want I8 to automatically take it rather than me having to go back and change the equation of I8 cell to "=U38"

Any suggestions to how to code I8 cell to do that?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

One approach

by mmcanosa In reply to Excel: Cells Update autom ...

the following formula in cell I8

=INDEX(A:A;COUNTA(A:A);1)

will count the number of items in column A and passes it as an argument to the index function (assuming you always want to show the last cell of column A). remember that COUNTA counts all items, so if you asdd something in column A accidentally, the formula won't work.
Hope it helps,
Mart?

Collapse -

Clarification

by clifforde In reply to One approach

Mart, I changed the ; to commas in Excel 2007 and it works. Fantastic! Change it to COUNT to exclude the non-numbers during a sort, with numbers on top in resultant sort.

Anybody need a Formula to find the Smallest number in a range that does not return 0 let me know. Uses the COUNT and LARGE function. Counts the number of values (non 0) and then returns the xth largest, which is the smallest number.

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums