Results 1 to 12 of 12

Multiple criteria find min and max date values

Threaded View

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

    Re: Multiple criteria find min and max date values

    use the AGGREGATE to return the row number of the match, and use that within an INDEX

    Formula: copy to clipboard
    =INDEX(Table8[Column1],AGGREGATE(15,6,(ROW(Table8[Date])-ROW(Table8[#Headers]))/(Table8[Build]=$A19)/(Table8[Country]=$B19)/(Table8[type]=$C19)/(Table8[year]=$D19)/(Table8[Date]=$F19),1))
    obviously, modify Column1 to be the relevant field in your table
    edit: should have added, the above returns value relevant to Min date (given F19), for the Max equivalent change F19 to E19 (nothing else)
    Last edited by XLent; 05-13-2020 at 02:36 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Referencing one name find multiple criteria multiple results within a date range
    By Flora Lastra in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-14-2018, 04:47 PM
  2. [SOLVED] Find multiple criteria and return sum of values
    By maym in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-28-2017, 05:57 AM
  3. Find count of unique values with multiple criteria inlcuding date ranges
    By jdooley in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-21-2016, 01:05 PM
  4. [SOLVED] Using Arrays To Find Values With Multiple Criteria
    By rpokorny in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2015, 12:00 PM
  5. Replies: 2
    Last Post: 05-26-2015, 07:29 PM
  6. Find multiple values with multiple criteria in vba macro
    By Jovillanueva in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 10-02-2014, 09:46 PM
  7. [SOLVED] Find Min Date from Multiple Criteria
    By STEELEMAN5000 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-19-2012, 12:13 PM

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