Results 1 to 10 of 10

Min, Max Values by Calendar Year

Threaded View

  1. #1
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2409
    Posts
    2,789

    Min, Max Values by Calendar Year

    I have a spreadsheet with data that spans from Jan. 1, 2017 to the present.
    In 1 column there is a date entry for every date since then.
    In another column I have values.
    I would like formulas to get the following.

    #1 The minimum and maximum values present for each calendar year, the dates for those values and if that value is repeated during that calendar year just the date that it last occurred.

    #2 For this year and future years I would like to be able to have a dynamic way of keeping track of the min and max to date and the last time they occurred if it's a repeated min or max value.

    And if you are wondering yes my Excel version is 2016.

    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. [SOLVED] formula calendar - loses values when year is changed
    By Josephrandall in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-18-2022, 01:09 PM
  2. [SOLVED] Return Fiscal calendar month, year and period, based on calendar date
    By losincog in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-20-2020, 09:16 AM
  3. Replies: 3
    Last Post: 01-24-2019, 11:00 AM
  4. Calendar Template Duplicating My Entries (Year On Year)
    By blarmey in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 11-10-2014, 03:14 AM
  5. [SOLVED] Need help with Calendar formula for previous year and next year
    By dcoates in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2013, 11:58 AM
  6. Transpose Quarters from Calendar Year to Fiscal Year
    By jodiander in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-25-2013, 01:00 PM
  7. Input a year to determine the start date for 4-4-5 Calendar Year.
    By mak1176 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-25-2013, 10:34 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