Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2005
    Posts
    183

    Unanswered: Last cell with entry

    This ought to be pretty simple, and worse still, I have done a few spreadsheets with similar functions creating sums.

    Nevertheless, I have the following problem, that I just can't seem to solve.

    On the left-most sheet, labelled "main sheet" I have a column A containing rows with labels for a series of tasks.

    Next to each task there is a cells that ought to contain their respective latest entry in a subsheets.

    Each task has a subsheet that contains 2 columns.

    A, contains a date, DD:MM
    B, contains a variable text, referring to what was done on that dae

    My problem is, on the main sheet I can't get the cell related to task to show the latest column B entry.

    What function should I use? I try to build an IF statement, but it just doesn't work.

    Cheers, and thanks in advance,

    Trin
    IT squid: networks, servers, firewalls, routers and I dabble a little with SQL-server and Access as well....

  2. #2
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Hi Trin,

    It sounds like you'll need to use an INDEX() MATCH() combination in your formula such as this:
    Code:
    =INDEX('Task a'!B:B,MATCH(MAX('Task a'!A:A),'Task a'!A:A,0))
    I've attached an example. Is that what you are looking for?
    Attached Files Attached Files

  3. #3
    Join Date
    Oct 2005
    Posts
    183
    It looks EXACTLY like what I'm looking for!

    Brilliant.. hadn't thought of using index for that.

    Thank you very much for your time.

    Cheers, Trin
    IT squid: networks, servers, firewalls, routers and I dabble a little with SQL-server and Access as well....

Posting Permissions

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