# Logical_test on Dates to get date_wise MIN and MAX values

1. ## 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
.
.
.

2. ## Re: Logical_test on Dates to get date_wise MIN and MAX values

with a pivot table.

see the attached file.

3. ## Re: Logical_test on Dates to get date_wise MIN and MAX values

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

4. ## Re: Logical_test on Dates to get date_wise MIN and MAX values

=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

5. ## Re: Logical_test on Dates to get date_wise MIN and MAX values

http://www.mrexcel.com/forum/excel-q...ax-values.html

6. ## Re: Logical_test on Dates to get date_wise MIN and MAX values

Thanks alot for your help!

7. ## Re: Logical_test on Dates to get date_wise MIN and MAX values

Thanks alot for your help!!!

8. ## Re: Logical_test on Dates to get date_wise MIN and MAX values

You're welcome. We appreciate the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

##### Users Browsing this Thread

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

#### 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