Solved

Max, Min, Average (excel 2003)

Posted on 2011-03-22
7
361 Views
Last Modified: 2012-05-11
Please see attached.  Have column A with Product Type and Column B with Cost.  Need to obtain max, min, average per product.  Need to present it in cells E5:G6.

Thanks,
JP Max-min-avg.xls a
0
Comment
Question by:easycapital
  • 3
  • 2
  • 2
7 Comments
 
LVL 33

Accepted Solution

by:
jppinto earned 250 total points
Comment Utility
Here you go...please check the attached solution...

jppinto
Max-min-avg-1-.xls
0
 
LVL 33

Expert Comment

by:jppinto
Comment Utility
Please note that I've used array formulas that need to be entered by using Ctrl+Shift+Enter (the brackets should appear after the enter).
0
 
LVL 50

Assisted Solution

by:barry houdini
barry houdini earned 250 total points
Comment Utility
Hello JP,

You can use "array formulas" for this, e.g. in E5 use this formula

=MAX(IF($A$3:$A$9=$D5,$B$3:$B$9))

confirmed with CTRL+SHIFT+ENTER and copied to E6

Then identical in F5:G6 but with MIN/AVERAGE instead of MAX

see attached

regards, barry
26903135.xls
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 50

Expert Comment

by:barry houdini
Comment Utility
....sorry JP, didn't see your reply......
0
 
LVL 33

Expert Comment

by:jppinto
Comment Utility
No problem Barry, it happens to all of us... :)
0
 

Author Closing Comment

by:easycapital
Comment Utility
Excellent!
One comment though. When I used the "IF" formula and used 0 for the false, the results were not always right.  Any thoughts.
Thanks,
JP
0
 

Author Comment

by:easycapital
Comment Utility
So I used the formula just as indicated without the zero, but I just thought it was good to point out the results.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now