Logical_test on Dates to get date_wise MIN and MAX values

[rajahamza9780]

NEED HELP!!!

I want to find the MIN and MAX from column 'values' with respect to dates.

Data is in below format (each date has corresponding 1440 minutes and each minute has a specific value):
Dates (several months; daily_basis) | Time (minute by minute) | Values (data)

Required Result format:
Date-1 (e.g. 02-Apr-16) | MIN_value | MAX_value
Date-2 (e.g. 03-Apr-16) | MIN_value | MAX_value
Date-3 (e.g. 03-Apr-16) | MIN_value | MAX_value
.
.
.

 

[Aladin Akyurek]

That doesn't reveal the lay-out of your data. But something like below should work:

Control+shift+enter, not just enter...

=MIN(IF(DataRange=date,TimeRange))

=MAX(IF(DataRange=date,TimeRange))

If you are on a 2016 system, try the MINIFS and MAXIFS functions which do not require control+shift+enter.

 

[jasonb75]

Cross posted at Logical_test on Dates to get date_wise MIN and MAX values

Aladin, I have 2016 and I don't see either of those functions available.

 

[AliGW]

They are available if you are on Office 365, Jason. They have been added very recently.