Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: In-cell function that finds last value in another column

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Since the subject header sounds too convoluted, here's what I'd like to do, using an in-cell function. In column A is a date; in column B is data that I have entered; and in column C will be a formula that performs a calcultion on the previous two columns:

    A B C
    1/1/01 10
    1/8/01
    1/15/01 38 2

    The formula in C would find the last data point in column B, and say (Bx-B1)/(Ax-A1). In this case, x=3. I can do this using a macro with out a problem, however, I'd like to be able to use an in-cell formula if possible. The time period between data points varies, as does the number blank lines.

    Any help would be appreciated. Thanks!

    [ This Message was edited by: j3rseyBoy on 2002-03-09 20:04 ]

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    If you entries are numeric use:

    =INDEX($B$1:$B$1000,MATCH(-9E+306,$B$1:$B$1000,-1),1)

    To return the value of last cell (will look past blanks)



Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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