Results 1 to 4 of 4

Finding the Latest Date Based on Conditions

Threaded View

  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
« 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