• Creator
  • #2225935

    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?

All Answers

  • Author
    • #2635621


      by sa3dos ·

      In reply to Excel: Cells Update automatically from last entry


    • #2949763

      One approach

      by mmcanosa ·

      In reply to Excel: Cells Update automatically from last entry

      the following formula in cell I8


      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,

      • #2949652


        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.

Viewing 1 reply thread