+ Reply to Thread
Results 1 to 2 of 2

Xlookup- Find the furthest out date based on a criteria

  1. #1
    Registered User
    Join Date
    02-22-2023
    Location
    London
    MS-Off Ver
    G-sheet
    Posts
    1

    Xlookup- Find the furthest out date based on a criteria

    Hi,

    I want to find the furthest out date from based on a criteria, after this I then want to pull the next furthest out date based on the same criteria.

    Thanks,

    It wont let me post a link

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,926

    Re: Xlookup- Find the furthest out date based on a criteria

    This should set you on the right track: https://exceljet.net/formulas/name-of-nth-largest-value.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Xlookup returning value based on date
    By nmarcon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-28-2022, 02:16 AM
  2. Replies: 3
    Last Post: 06-24-2021, 10:31 AM
  3. [SOLVED] XLOOKUP to return cell based on multiple criteria in single column
    By mikehay08 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-24-2021, 02:59 PM
  4. How to find next date based on criteria 1 and 2
    By magicianfamous6988 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-08-2020, 09:27 PM
  5. [SOLVED] Lookup value furthest to the right + criteria
    By Donald Becker in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-28-2018, 10:10 AM
  6. [SOLVED] find missing date on every group date list based on range and criteria
    By k1dr0ck in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2013, 01:26 AM
  7. Find Min Date based on criteria
    By caliskier in forum Excel General
    Replies: 8
    Last Post: 05-06-2011, 01:22 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