?
Solved

Find Minimum Date and Max Date based on a variable

Posted on 2011-09-21
5
Medium Priority
?
215 Views
Last Modified: 2012-05-12
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
Comment
Question by:bearblack
  • 3
  • 2
5 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 2000 total points
ID: 36573827
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
 
LVL 2

Author Comment

by:bearblack
ID: 36574294
Can you do this with m,ultiple criteria?
0
 
LVL 2

Author Comment

by:bearblack
ID: 36574305
Such as cutomer and status for example
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 36574344
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
 
LVL 2

Author Comment

by:bearblack
ID: 36574405
Thanks Again
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question