Logical_test on Dates to get date_wise MIN and MAX values

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

Data is in below format:
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
.
.
.

Put this array* formula in B2 of the Summary sheet:

=MIN(IF(Date_wise_MIN_MAX!$A$2:$A$28516=A2,Date_wise_MIN_MAX!$C$2:$C$28516))

and this array* formula in C2:

=MAX(IF(Date_wise_MIN_MAX!$A$2:$A$28516=A2,Date_wise_MIN_MAX!$C$2:$C$28516))

then copy down.

*An array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE) instead of the usual < Enter >.

Hope this helps.

Pete

=MIN(IF(Date_wise_MIN_MAX!$A$2:$A$29000=Summary!$A2,Date_wise_MIN_MAX!$C$2:$C$29000))


=MAX(IF(Date_wise_MIN_MAX!$A$2:$A$29000=Summary!$A2,Date_wise_MIN_MAX!$C$2:$C$29000))

Enter both with Ctrl+shift+Enter

Thanks alot for your help!

Thanks alot for your help!!!