+ Reply to Thread
Results 1 to 4 of 4

Finding the Latest Date Based on Conditions

  1. 08-01-2021, 11:19 AM #1
    bafi
    bafi is offline
    Registered User
    Join Date
    08-01-2021
    Location
    UK
    MS-Off Ver
    365
    Posts
    2

    Question Finding the Latest Date Based on Conditions

    Hello all,

    I'm stuck with a formula that I can not solve. Please see the attached excel sample file.

    Basically I would like to see the latest order date show up on Sheet 1 - Column B for each product based on the data on Sheet 2.
    On Sheet 2 you will see a table with products & order dates & quantity ordered.
    I have tried MAXIFS formula but got so confused and had no success.

    Your help would be greatly appreciated!

    Thank you.
    Attached Files Attached Files
    Last edited by bafi; 08-01-2021 at 11:56 AM.
    Reply With QuoteRegister To Reply
  2. 08-01-2021, 11:31 AM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,363

    Re: Finding the Latest Date Based on Conditions

    Try

    in B2

    =LOOKUP(2,1/(INDEX(Sheet2!$B$2:$M$20,MATCH($A2,Sheet2!$A$2:$A$20,0),0)),Sheet2!$B$1:$M$1)
    Reply With QuoteRegister To Reply
  3. 08-01-2021, 11:56 AM #3
    bafi
    bafi is offline
    Registered User
    Join Date
    08-01-2021
    Location
    UK
    MS-Off Ver
    365
    Posts
    2

    Re: Finding the Latest Date Based on Conditions

    Thank you so so much JohnTopley! Amazing job!
    Reply With QuoteRegister To Reply
  4. 08-01-2021, 02:03 PM #4
    CARACALLA
    CARACALLA is offline
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,790

    Re: Finding the Latest Date Based on Conditions

    Sheet1


    B2=IF(Sheet1!$A2<>"",AGGREGATE(14,6,Sheet2!$B$1:$M$1/(Sheet2!$A$2:$A$20=Sheet1!$A2)/(Sheet2!$B$2:$M$20>0),1),"")


    Copy down
    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] Finding Latest Date
    By chandraganji in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-19-2020, 09:43 AM
  2. VBA- Filter Pivot table based on latest and 2nd latest date in column
    By ziyan89 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 12-29-2015, 11:18 AM
  3. Powerpivot - Returning latest update based on latest date
    By Kehjz in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-22-2013, 02:45 PM
  4. [SOLVED] Finding latest date
    By tbaskar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-08-2013, 11:37 PM
  5. Finding latest date
    By tbaskar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-08-2013, 02:36 AM
  6. Finding latest date with query
    By sumdumgai in forum Access Tables & Databases
    Replies: 1
    Last Post: 10-03-2010, 12:59 PM
  7. Finding latest date
    By SilverHeli2000 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-22-2009, 02:13 PM

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