MAXIFS criteria1 question

Hello,

I am having issues defining the critera1 parameter for the MAXIFS function. My data is being exported from an app in the following format:

Date (MM/DD/YY HH:MM) in column A
Temperature (XX.XXX) in column B

Timestamp Temperature_Celsius
3/1/18 0:00 25.7056
3/1/18 0:01 25.7056
3/1/18 0:02 25.7056
3/1/18 0:03 25.7056
3/1/18 0:04 25.7056
3/1/18 0:05 25.7056
3/1/18 0:06 25.7056
3/1/18 0:07 25.7167

I am exporting temperature data every minute for a single month, so I have thousands of readings. My goal is to find the Max temperature over every specific 24 hour period in the month, so I am trying to use the MAXIFS function to search out the max temperature in column B for the date as defined in column A.

My issue is when I enter the following formula: MAXIFS(B2:B100, A2:A100, "3/1/18") I get a value of 25.7056 for my max range instead of 25.7167 (from the example table above). I've attempted to use "*3/1/18*" to search for partial terms but this returns a max value of 0.

Does anyone have suggestions for pulling the max range data from this kind of table?

Thank you in advance for the help.

See attached!

You can use two criteria in either date format, or numerical for the date values which should solve it.

Formula:

Please Login or Register  to view this content.

Thank you so much! Very helpful.

Hi what if my criteria isn't a date for example I work in fixed income so I want to return highest BMW but I have BMW 1, BMW 1.4.2 etc. i try to just enter BMW to the criteria but it doesn't work.