Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Finding last value in a row

  1. #11
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,653
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Finding last value in a row

    Quote Originally Posted by Curious Georgian View Post
    Rehashing an old thread here, but can this formula be altered to find the last text value in a range (similar to the cell references provided above)?
    Thanks!
    CG
    Yes, we have;

    =LOOKUP(REPT("z",255),A2:A10)

    would yield the last text value even if it's a formula generated blank (i.e., "").

    =MATCH(REPT("z",255),A2:A10)

    would yield the relative position of the last text value.

    Note. REPT("z",225) creates a lengthy string that is alphabetically last. And it's due to Mark W.
    Assuming too much and qualifying too much are two faces of the same problem.

  2. #12
    New Member
    Join Date
    Feb 2014
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Finding last value in a row

    This works perfectly, and I appreciate your providing both the Match and Lookup explanations. I've combined this with an index function and it works just as needed.
    Thanks to you and Mark W!
    CG

  3. #13
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,653
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Finding last value in a row

    Quote Originally Posted by Curious Georgian View Post
    This works perfectly, and I appreciate your providing both the Match and Lookup explanations. I've combined this with an index function and it works just as needed.
    Thanks to you and Mark W!
    CG
    That is great. Thanks for providing feedback.
    Assuming too much and qualifying too much are two faces of the same problem.

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
  •