Results 1 to 7 of 7

Vlookup/lookup lastest entry excluding blanks

Threaded View

dominion Vlookup/lookup lastest entry... 09-13-2012, 01:19 AM
Ace_XL Re: Vlookup/lookup lastest... 09-13-2012, 01:25 AM
dominion Re: Vlookup/lookup lastest... 09-13-2012, 03:33 AM
Ace_XL Re: Vlookup/lookup lastest... 09-13-2012, 03:40 AM
dominion Re: Vlookup/lookup lastest... 09-18-2012, 09:48 AM
Cutter Re: Vlookup/lookup lastest... 09-18-2012, 04:39 PM
dominion Re: Vlookup/lookup lastest... 09-21-2012, 03:12 AM
  1. #1
    Registered User
    Join Date
    09-13-2012
    Location
    sg
    MS-Off Ver
    Excel 2010
    Posts
    11

    Vlookup/lookup lastest entry excluding blanks

    Hi All,

    would really appreciate help for this. I tried searching the old threads which gave me results for getting the latest entry, but i need to look up the latest entry excluding the blanks. For example


    A 12-Jan-12
    B 13-Jan-12
    A 15-Feb-12
    B 16-Feb-12
    C 16-Feb-12
    A
    B
    C

    I need to be able to get the result for A as 15-Feb-12 and B as 16-Feb-12 even though there are blank entries corresponding to A and B further down.
    The Answer is =MAX(IF(A1=$A$1:$A$8,$B$1:$B$8)) Confirm with Ctrl+Shift+Enter not just Enter


    However, I would like to know how I can do so for entries across two different spreadsheets in the same file?
    The code I'm using now is =MAX(IF("Itemname"='2012'!$B$6:$B$250,'2012'!$H$6:$H$250)), i'm looking for the entry in spreadsheet 2012, but how can i include entires in spreadsheet 2011 as well?
    Last edited by dominion; 09-21-2012 at 03:12 AM.

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