+ Reply to Thread
Results 1 to 4 of 4

Return last row in a list, based on criteria

  1. 03-08-2012, 04:47 PM #1
    Test123Test
    Test123Test is offline
    Registered User
    Join Date
    02-12-2012
    Location
    Oslo, Norway
    MS-Off Ver
    Excel 2007, 2013
    Posts
    89

    Return last row in a list, based on criteria

    Was hoping someone could help me with this, I've attached a dummy workbook to explain it better...thanks guys
    Attached Files Attached Files
    Last edited by Test123Test; 03-08-2012 at 05:15 PM.
    Reply With QuoteRegister To Reply
  2. 03-08-2012, 04:59 PM #2
    tigeravatar
    tigeravatar is offline
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Return last row in a list, based on criteria

    In cell A11 and copied over:
    =INDEX(A$1:A$8,LOOKUP(2,1/($A$2:$A$8=$G11),ROW($A$2:$A$8)))
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
    Reply With QuoteRegister To Reply
  3. 03-08-2012, 05:01 PM #3
    Kelshaer
    Kelshaer is offline
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: Return last row in a list, based on criteria

    Here you Go

    Please Login or Register  to view this content.
    Regards,
    Khaled Elshaer
    www.BIMcentre.com

    Remember To Do the Following....
    1. Thank those who have helped you by clicking the Star below their post.
    2. Mark your post SOLVED if it has been answered satisfactorily:
    • Select Thread Tools (on top of your 1st post)
    • Select Mark this thread as Solved
    Reply With QuoteRegister To Reply
  4. 03-08-2012, 05:14 PM #4
    Test123Test
    Test123Test is offline
    Registered User
    Join Date
    02-12-2012
    Location
    Oslo, Norway
    MS-Off Ver
    Excel 2007, 2013
    Posts
    89

    Re: Return last row in a list, based on criteria

    Great, thanks a lot for the help guys!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1