+ Reply to Thread
Results 1 to 6 of 6

MAX date match

  1. 02-06-2014, 06:04 PM #1
    jyothijayanna is offline
    Registered User
    Join Date
    08-17-2012
    Location
    Atlanta
    MS-Off Ver
    Excel 2003
    Posts
    34

    MAX date match

    Hello everyone,

    Can someone help me with the attached spreadsheet? I am using an array formula in Column CA. I am trying to match entries from Column BZ with similar entries in Column GP and the array pulls dates from the subsequent GU Column. The array should only pull max date from column GU.

    I highlighted only RoladerConnieKCRA for this example. My question is why does the array pull 12/3/13 instead of 1/14/14 as the max date. The baffling thing is that I have the same array on other spreadsheets which works properly.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-06-2014, 06:24 PM #2
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: MAX date match

    are they supposed to reference different cells?
    the result is for $BS370 which is equal to
    RoladerConnieKCAG which is 03/12/2013
    Attached Files Attached Files
    Last edited by martindwilson; 02-06-2014 at 06:36 PM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
  3. 02-06-2014, 06:48 PM #3
    jyothijayanna is offline
    Registered User
    Join Date
    08-17-2012
    Location
    Atlanta
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: MAX date match

    Cell CA370 should return 1/14/14 but it returns 12/3/13. This is for RoladerConnieKCRA.....not for RoladerConnieKCAG.
    Reply With QuoteRegister To Reply
  4. 02-06-2014, 06:58 PM #4
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: MAX date match

    i cant change what it says $BS370 is RoladerConnieKCAG thats whats being looked up. look at the file i attached red shaded cell is what is being looked up
    red text is where its getting the result from

    =IF(MAX(IF($DJ$2:$DJ$524=BZ370,$GU$2:$GV$524,""))=0,"0",MAX(IF($DJ$2:$DJ$524=$BS370,$GU$2:$GV$524,"")))
    Reply With QuoteRegister To Reply
  5. 02-07-2014, 08:56 AM #5
    jyothijayanna is offline
    Registered User
    Join Date
    08-17-2012
    Location
    Atlanta
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: MAX date match

    ......and there is the problem. I should have written $BZ370.

    Thanks Martin. Sometimes it talks just another set of eyes to see the obvious.
    Reply With QuoteRegister To Reply
  6. 02-07-2014, 09:12 AM #6
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: MAX date match

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    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)

Similar Threads

  1. [SOLVED] INDEX date that MATCH on date range, MATCH code(string)
    By Dahlia in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2014, 03:33 AM
  2. Index and Match with Two Criteria, and date Match Type is Less Than
    By ExcelQuestion in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-11-2013, 08:57 AM
  3. [SOLVED] VBA worksheetfunction.match doesn't match DATE. Userform
    By stevnb in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-05-2012, 09:08 AM
  4. Date Match in all worksheets according to Main Sheet if not match insert row adjust
    By farrukh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-07-2012, 10:17 AM
  5. Date change & TBA when match cancelled. Try Match and index didn't work
    By micope21 in forum Excel General
    Replies: 5
    Last Post: 01-06-2012, 08:00 PM

Tags for this Thread

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