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

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
Asked:
bearblack
  • 3
  • 2
1 Solution
 
Rory ArchibaldCommented:
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
 
bearblackGlobal Program ManagerAuthor Commented:
Can you do this with m,ultiple criteria?
0
 
bearblackGlobal Program ManagerAuthor Commented:
Such as cutomer and status for example
0
 
Rory ArchibaldCommented:
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
 
bearblackGlobal 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.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now