Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Daily Dose of Excel » Maxif and Minif with Multiple Variables

Maxif and Minif with Multiple Variables

In Maxif, Minif Functions, I discussed finding the maximum or minimum for a subset of data based on certain criteria. If you have more than one criterion, the formulas are roughly the same. In this example, I have three items in four different PriceZones. I want to find the most expensive and least expensive [...] Read More...

Read the complete post at http://www.dailydoseofexcel.com/archives/2010/03/23/maxif-and-minif-with-multiple-variables/

Posted Mar 23 2010, 07:57 PM by Daily Dose of Excel
Filed under:
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.