+ Reply to Thread
Results 1 to 6 of 6

Locate latest cell entry in column

  1. #1
    Registered User
    Join Date
    12-08-2010
    Location
    Omaha, Nebraska USA
    MS-Off Ver
    Excel 2017
    Posts
    29

    Locate latest cell entry in column

    My brain is fried from sifting thru the vast forum trying to find a similar solution, but can't nail down a specific post to apply. Many are "close, but no cigar."

    Cells B75 and C75 need to show the latest entries from the array B2:C73, respectively.
    Cell D76 needs to show the latest entry from the D2:D73 array.
    The correct formula result will be the data in row 66.
    As game results are added in rows 67 and so forth, the results in B75, C75, and D76 will adjust to the latest entries.
    I removed the formulas in columns A:D, which refer to game results from another worksheet...I'm just looking to reference the latest win-loss steak and last 10 games.

    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    14,599

    Re: Locate latest cell entry in column

    If you delete the contents from rows 67 downwards (or get your formulae to return ""), then you can use these formulae in the cells stated:

    B76: =LOOKUP("zzz",B2:B73)

    C76: =LOOKUP(1000,C2:C73)

    D76: =LOOKUP("zzz",D2:D73)

    "zzz" is just a big text value (i.e. "larger" than those expected in your data), and 1000 is a bigger number than those in your data.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    01-08-2015
    Location
    Cali, Colombia
    MS-Off Ver
    365 with 2016
    Posts
    74

    Re: Locate latest cell entry in column

    Hi, pskwaak!

    You could try:
    [D75] : =LOOKUP(2,1/(D2:D73<>""),D2:D73)

    What is the desired result in B76 and C76? Write by hand this values, because i don't understand exactly. Blessings!

  4. #4
    Registered User
    Join Date
    12-08-2010
    Location
    Omaha, Nebraska USA
    MS-Off Ver
    Excel 2017
    Posts
    29

    Re: Locate latest cell entry in column

    The one for C76 worked, but B76 and D76 did not ... results in a blank. Is it something to do with looking up text rather than numbers?
    Thanks!

  5. #5
    Registered User
    Join Date
    12-08-2010
    Location
    Omaha, Nebraska USA
    MS-Off Ver
    Excel 2017
    Posts
    29

    Re: Locate latest cell entry in column

    The D75 formula works! The correct answer to the formulas for B76 and C76 should reference row 66 ("L" and "3"). Using the same formula you provided for D75 also works in B76 and C76! Thanks so much for the help!

  6. #6
    Registered User
    Join Date
    12-08-2010
    Location
    Omaha, Nebraska USA
    MS-Off Ver
    Excel 2017
    Posts
    29

    Re: Locate latest cell entry in column

    OK, Pete, I see the problem. It worked with my sample workbook submitted, but the original one I'm working with has formulas that produce the 0. Can you modify your formula to look at results of the data formula and not just a blank cell?

    Editing this reply: Forgot to mention that the data in column D are results of concatenate formulas and not manual entries.

    I'm self-taught in Excel basics and use this forum and other sources to learn. So your post is an alternative to what I was looking for...and helps me "see" other ways to use data. Thanks!
    Last edited by pskwaak; 01-12-2018 at 11:12 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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