[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
Solved

# Find Minimum Date and Max Date based on a variable

Posted on 2011-09-21
Medium Priority
213 Views
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
Question by:bearblack
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 3
• 2

LVL 85

Accepted Solution

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

ID: 36574294
Can you do this with m,ultiple criteria?
0

LVL 2

Author Comment

ID: 36574305
Such as cutomer and status for example
0

LVL 85

Expert Comment

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

ID: 36574405
Thanks Again
0

## Featured Post

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
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…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
###### Suggested Courses
Course of the Month15 days, left to enroll