Results 1 to 4 of 4

Determine the last "value" in a column of formulas

Threaded View

  1. #1
    Registered User
    Join Date
    09-01-2015
    Location
    Port Elizabeth, South Africa
    MS-Off Ver
    Pro Plus 2010
    Posts
    33

    Determine the last "value" in a column of formulas

    Good afternoon again,

    I have 3 columns, A, B, & C.
    Columns A & B have input values. Column C is a calculation.
    I need to determine the last "Value" displayed in Column C.

    A | B | C
    1 | 2 | -1
    3 | 0 | 2
    1 | 1 | 2
    2 | 1 | 3
    1 | 2 | 2
    0 | 2 | 0
    0 | 3 | -3

    As mentioned, A & B are data entry values.
    Cell C1 is calculated with IF(A1="","",(A1-B1))
    From Cell C2 onwards, the formula is IF(A2="","",(A2-B2+A1))

    In a different cell (say F1) I would like to display the last displayed value, that is in this case -3.
    The range of data would be A1:C25 - but cells A8:B25 are empty (for now), and obviously [because of the IF(A?="","") string] cells C8:C25 "appear" blank, but contain a formula.

    Thanks for any assistance.
    HGL
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Short "Basic" Macro to copy and paste formulas "N" times.
    By gradyhawks in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-09-2014, 02:34 PM
  2. [SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2013, 08:28 PM
  3. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  4. Delete rows in the result of formulas "OK" n column "J"
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-29-2012, 10:08 AM
  5. Replies: 1
    Last Post: 07-16-2010, 02:44 AM
  6. Replies: 0
    Last Post: 07-09-2009, 04:07 PM
  7. Recognize "formulas "result" as "typed data", through and through.
    By gandolff in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-13-2009, 01:30 PM

Bookmarks

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