1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Formula to read last line in column for excel?

Discussion in 'Business Applications' started by Damonc, Aug 9, 2006.

Thread Status:
Not open for further replies.
Advertisement
  1. Damonc

    Damonc Thread Starter

    Joined:
    May 9, 2001
    Messages:
    652
    First Name:
    Damon
    Hi, just wanting to know is there a formula that you can use to display the last line of data entered in a column elsewhere on the sheet?

    What I am wanting to do is on "Sheet1" have a list of dates in a coloum, I would then like to have the last date entered automatically displayed on (and updated) "Sheet2"
     
  2. OBP

    OBP Temporarily Banned

    Joined:
    Mar 8, 2005
    Messages:
    19,889
    I do not know about a formula, but you can cetainly do it quite easily with VBA.
     
  3. Damonc

    Damonc Thread Starter

    Joined:
    May 9, 2001
    Messages:
    652
    First Name:
    Damon
    Well VBA would do...
     
  4. maxflia10

    maxflia10

    Joined:
    Feb 24, 2003
    Messages:
    331
    Assuming true date values,

    =LOOKUP(9.99999999999999E+307,Sheet1!A:A)

    With the Morefunc addin

    =LASTROW(SHEET1!A:A)
     
  5. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
    The Morefunc addin is available at Laurent Longre's site:

    http://xcell05.free.fr/english/

    (Hi Brian! :) )
     
  6. Damonc

    Damonc Thread Starter

    Joined:
    May 9, 2001
    Messages:
    652
    First Name:
    Damon
    Thanks heaps guys. that has answered my question.
     
  7. maxflia10

    maxflia10

    Joined:
    Feb 24, 2003
    Messages:
    331
    Hey Andy.....:D

    I always forget to post the link for the addin....

    Hope all is well! (y)
     
  8. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/490878

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice