+ Reply to Thread
Results 1 to 3 of 3

Find maximum and minimum value for each date

  1. #1
    Registered User
    Join Date
    06-05-2012
    Location
    Moscow
    MS-Off Ver
    Excel 2003
    Posts
    2

    Find maximum and minimum value for each date

    I have data with measurements for temperature for each 6 hours per day. I want to find max and min values for each date.
    How can I do this?

    proba.xls

    Many thanks!

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Find maximum and minimum value for each date

    Hello Anna, Welcome to the forum.

    One option is Pivot Table. Click here for tutorials.

    See the attached.
    Attached Files Attached Files
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Registered User
    Join Date
    06-05-2012
    Location
    Moscow
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Find maximum and minimum value for each date

    Thank you for reply. Already fixed with arrow formula. As I need to use it in another program ) thank you anyway!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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