+ Reply to Thread
Results 1 to 3 of 3

Find the most recent date from multiple rows with same lookup Value

Hybrid View

  1. #1
    Registered User
    Join Date
    01-08-2019
    Location
    Maine, US
    MS-Off Ver
    2016
    Posts
    1

    Find the most recent date from multiple rows with same lookup Value

    I am stumped trying to figure how to accomplish the following in excel. I am looking up a value in an array that will have multiple instances but another colum has different dates. I am trying to return the most recent date and which row it is in. I can accomplish this if I sort the data and use match to find the colum in descending order. However, the data may not always be in the correct order and I am trying to make it so it does not rely of always ensuring it is in order.

    For instance, my data looks as follows:

    Name Data Date
    x Data 1/1/2018
    y Data 10/10/2018
    x Data 1/1/2019
    z Data 12/12/2018

    I want to be able to search for X and find the most recent date without sorting the data.

    If there are any solutions or recommendations to this, your assistance with be appreciated.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,789

    Re: Find the most recent date from multiple rows with same lookup Value

    Formula: copy to clipboard
    =SUMPRODUCT(MAX((A2:A10="x")*(C2:C10)))


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,290

    Re: Find the most recent date from multiple rows with same lookup Value

    Formula: copy to clipboard
    =MAX(IF($A$2:$A$10="x",$C$2:$C$10))


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find Most Recent Date corresponding to Unique ID from Multiple Workbooks
    By NATANI in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-02-2018, 06:03 AM
  2. [SOLVED] Lookup: Lookup employee id and return value in cell x basued on most recent start date
    By jekeith in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-21-2018, 12:56 PM
  3. Replies: 2
    Last Post: 01-04-2016, 03:40 AM
  4. [SOLVED] Lookup Multiple Criteria using most recent date
    By tsadams23 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-26-2015, 09:51 AM
  5. [SOLVED] formula to lookup most recent date
    By a2424 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-23-2014, 09:22 PM
  6. [SOLVED] Multiple criteria lookup including recent date.
    By Dimydom in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-29-2012, 06:43 AM

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