+ Reply to Thread
Results 1 to 8 of 8

Better way to find date of max value between dates

  1. 07-14-2022, 10:06 AM #1
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,450

    Better way to find date of max value between dates

    Hi
    I've been trying to use some new functions.
    To find the date of the max value between two dates I built the following
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    which looks like overkill. Are there any other ways you can think of ?
    Thanks a lot
    Attached Files Attached Files
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  2. 07-14-2022, 10:28 AM #2
    AliGW
    AliGW is offline
    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
    81,223

    Re: Better way to find date of max value between dates

    You can use MAXIFS:

    =MAXIFS($B$1:$B$8,$A$1:$A$8,">"&A2,$A$1:$A$8,"<"&A7)
    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 With QuoteRegister To Reply
  3. 07-14-2022, 10:57 AM #3
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,099

    Re: Better way to find date of max value between dates

    or

    =FILTER(A1:A8,B1:B8=MAX(B1:B8))

    not sure of the purpose of >a2 and <A7...
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  4. 07-14-2022, 11:33 AM #4
    AliGW
    AliGW is offline
    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
    81,223

    Re: Better way to find date of max value between dates

    Between those dates, Glenn.
    Reply With QuoteRegister To Reply
  5. 07-14-2022, 12:41 PM #5
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,099

    Re: Better way to find date of max value between dates

    I must have fallen on my head yesterday...
    Reply With QuoteRegister To Reply
  6. 07-15-2022, 02:01 AM #6
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,450

    Re: Better way to find date of max value between dates

    Thanks to both of you
    Reply With QuoteRegister To Reply
  7. 07-15-2022, 02:04 AM #7
    AliGW
    AliGW is offline
    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
    81,223

    Re: Better way to find date of max value between dates

    No worries.
    Reply With QuoteRegister To Reply
  8. 07-17-2022, 06:46 PM #8
    wk9128
    wk9128 is offline
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,469

    Re: Better way to find date of max value between dates

    To find the date of the max value between two dates
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    To find the value of the max value between two dates
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Compare dates from strings and then find first date greater than a date
    By caabdul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2018, 11:44 PM
  2. Find out date in between other dates
    By meus in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-09-2016, 05:12 AM
  3. [SOLVED] Find most recent date from a set of dates
    By rluesc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-26-2015, 08:51 AM
  4. [SOLVED] Find date between 2 dates and place corresponding values of orginal date if between 2 date
    By pcts in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-16-2014, 11:51 AM
  5. a function to find the previous date based on a given date and a range of dates
    By scott.s.fower in forum Tips and Tutorials
    Replies: 0
    Last Post: 05-30-2013, 07:50 PM
  6. [SOLVED] Excel 2007 : How to find the latest date in a range of dates, that is before todays date
    By JohannesFust in forum Excel General
    Replies: 1
    Last Post: 04-04-2012, 08:21 AM
  7. Analyze rows of dates, find continuous dates and output 1 date range of min and max
    By dinged in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-27-2009, 06:06 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