• Status: Solved
• Priority: Medium
• Security: Public
• Views: 221

# Find Minimum Date and Max Date based on a variable

I need to calculate the minimum and maximum date based on the Customer name, see attached file. The user will enter the customer name from a drop down list. Min-Max-based-on-Criteria.xlsx
0
bearblack
• 3
• 2
1 Solution

Commented:
Assuming customer name in A1:
=MIN(IF(\$G\$7:\$G\$76=\$A\$1,\$K\$7:\$K\$76,""))
and
=MAX(IF(\$G\$7:\$G\$76=\$A\$1,\$K\$7:\$K\$76,""))

both array-entered using Ctrl+Shift+Enter.

See attached file.

Regards,
Rory
Min-Max-based-on-Criteria.xlsx
0

Global Program ManagerAuthor Commented:
Can you do this with m,ultiple criteria?
0

Global Program ManagerAuthor Commented:
Such as cutomer and status for example
0

Commented:
Yes:
=MIN(IF(\$G\$7:\$G\$76=\$A\$1,IF(\$M\$7:\$M\$76=\$A\$2,\$K\$7:\$K\$76,"")))
for example. (again, array entered)
0

Global Program ManagerAuthor Commented:
Thanks Again
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.