Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Min & Max formulas

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Min & Max formulas

Resolved · High Priority · Version 2003

Reply Tue 22 Feb 2011, 16:26Delegate Christina said...

Christina has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Min & Max formulas

Hello,

I wonder if you can help me?
I am trying to find (seperately) both the minimum and maximum values from a data sheet to put on my summary sheet. The data sheet contains Job titles and budget hours:

EG:
Partner 400
Partner 500
Partner 600
Associate 200
Associate 300
Trainee 150
Trainee 250

The summary sheet is as follows:
Min Max
Patner
Associate
Trainee

Therefore I am trying to write a formula to say if the data sheet matches one of the job titles on the summary sheet (eg: Partner) then find the minimum value.

I hope this makes sense and you will be able to help me.

Kind regards,
C Christoforou

For upcoming training course dates see: Pricing & availability

Reply Thu 24 Feb 2011, 20:49Trainer Rodney said...

RE: Min & Max formulas

Hello Christina,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding maximum and minimum values in a spread sheet. I have created a small file which has a couple of solutions. I would have tried an IF function, however, since they are limited to 7 instances and I don't know how many job titles you have in your organisation, I have chosen the solutions which I think may help you.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Attached files...

SubTotals.xls

Excel articles

· Differences In Excel 2003, 2007 And 2010
· The Importance of Data Backups
· Using Dates Within Excel
· Using The Excel Forms Toolbar To Spruce Up A Workbook
· Interesting Lifestyle Applications for Microsoft Excel

Please browse our web site to find out more about
excel consulting and other Microsoft training courses.

Excel tip:

New to Excel 2010 - Sparklines!

Excel 2010 includes a new feature called Sparklines which are tiny charts that fit into a single cell and plot data in cells from the worksheet. There are a host of formatting and styles that can be applied to them and they are really quite interesting.

>insert
>sparklines
>Choose any style you want

You will be asked for the range and it will automatically select the cell your in to insert the sparklines.

View all Excel hints and tips