+ Reply to Thread
Results 1 to 4 of 4

Formula to look for the longest date of several conditions based on certain criteria

  1. #1
    Forum Contributor
    Join Date
    12-29-2014
    Location
    Indonesia
    MS-Off Ver
    Office 2010, 2013
    Posts
    125

    Formula to look for the longest date of several conditions based on certain criteria

    hi all,

    I want to find the longest date from the column K,L,M,N ("date nonacr", "date od", "date due", "date branch") based on account number and downloade date. If there is a decrease in outstanding, then the oldest date only sees from the column "date nonacr", "date due "and" date branch "only,
    but use result " (blank) " if there no date date in coloumn K,L,M,N or if there is a date in the "date od" column but there is a decrease in outstanding
    or there is a decrease in outstanding but the date in column "K" or column "M" or column "N" is younger than the date in the column "Download_Date" .

    Please provide the appropriate formula information. Thank you in advance.

    note : data sample already attached.

    regard
    dolphino
    Attached Files Attached Files

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Formula to look for the longest date of several conditions based on certain criteria

    one option which would mirror your expected results

    I4: =IFERROR(1/(1/IF(Q4,IF(L4=MIN(K4:N4),0,MIN(K4,M4:N4)),MIN(K4:N4))),"(blank)")
    copied down

  3. #3
    Forum Contributor
    Join Date
    12-29-2014
    Location
    Indonesia
    MS-Off Ver
    Office 2010, 2013
    Posts
    125

    Re: Formula to look for the longest date of several conditions based on certain criteria

    hi XLent

    thanks for your help, the formula is as I expected.


    regards

    dolphino

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Formula to look for the longest date of several conditions based on certain criteria

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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. Look for the longest date from 4 columns and certain conditions
    By dolphino in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-06-2020, 04:19 AM
  2. [SOLVED] if formula based on several criteria to extract data based on conditions
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-17-2018, 12:46 PM
  3. [SOLVED] Formula to Calculate Payment Date based on Multiple Conditions
    By NonStopLeo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-18-2018, 01:13 AM
  4. Extract orders by longest lead times based on criteria
    By HKPHOOY in forum Excel Programming / VBA / Macros
    Replies: 38
    Last Post: 06-18-2018, 01:53 PM
  5. [SOLVED] Return cell with longest character limit based on additional criteria
    By SAsplin in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-12-2018, 09:06 AM
  6. [SOLVED] Help Need formula based on two conditions - a valve and a date
    By cdwayne in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2015, 01:28 AM
  7. [SOLVED] Formula for calculating a new date based on an existing date and other cell criteria
    By scsuflyboy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2013, 09:49 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1