Results 1 to 5 of 5

Lookup for the succeeding dates after the earliest date

Threaded View

  1. #1
    Registered User
    Join Date
    06-23-2013
    Location
    dubai
    MS-Off Ver
    Excel 2003
    Posts
    2

    Lookup for the succeeding dates after the earliest date

    Hi everyone,

    On the attached sample file, I used this array formula to lookup fo the "First purchase date" - {=MIN(IF((Sheet2!A:A=Sheet1!A2),Sheet2!B:B))}

    However, for the "Second purchase" and "Third purchase", i'm stuck and can't think on how to return the dates.

    Can anyone help me on this?

    Thank you in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Getting rid of duplicates with the earliest dates
    By sabbur in forum Excel General
    Replies: 1
    Last Post: 05-09-2012, 12:27 AM
  2. LookUp based earliest date (2007)
    By D_N_L in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-15-2012, 08:19 AM
  3. Pick the earliest date from a selection of dates...
    By -emma- in forum Excel General
    Replies: 9
    Last Post: 01-24-2007, 08:16 PM
  4. How do I find the earliest dates in a range of dates?
    By JJ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-16-2006, 04:45 AM
  5. [SOLVED] Find the earliest date in a range of dates?
    By Rachel Williams in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2006, 11:55 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