Search Not Just Numbers

Loading...

Tuesday, 29 October 2013

Excel Tip: Finding the maximum or minimum value in a list

Before we crack on with this week's post, just a quick little note about Mynda Treacy's Excel Dashboards course.

I know that many of you have purchased the course and taken advantage of the early bird discount. As when we offered the course last time, the course has been very popular and the feedback has been excellent.

If you haven't already done so, you can still get the course until 30th October and, although you have missed the discount, the course still represents excellent value and I will still throw in my Introduction to Pivot Tables course free of charge.

You can get the course here.

OK, on with this week's tip. We all know how to sum a list of numbers, but Excel offers a number of other functions for analysing a list, and today I want to introduce two of them that enable you to find the maximum or minimum value in a list.

This could be useful for all sorts of reasons - finding the maximum sales in any particular month, or the lowest score achieved in a test, for example.

Excel offers a simple way of doing this with the MAX and MIN functions.

Both functions have the following syntax:

=MAX(number1,number2,etc.) you can have as many numbers as you like in this list.

So, for example:

=MAX(23,45,12,65,21)  will return 65

and

=MIN(23,45,12,65,21)  will return 12

These numbers can be cell references, or ranges of cells - and this is usually of far more practical use.

So, say the cells A1 to A5 contain the numbers 23,45,12,65 and 21, then:

=MAX(A1:A5)  will return 65

and

=MIN(A1:A5)   will return 12

And that's really all you need to know.

Excel Expert Course

If you enjoyed this post, go to the top of the blog, where you can subscribe for regular updates and get two freebies "The 5 Excel features that you NEED to know" and "30 Chants for Better Charts".

3 comments:

  1. Synthetic leather replacement affordable handbags verts happen to be great for frigid, serious climatic conditions, especially when they're just well-lined motor cyclist fake handbags. Any demanding external membrane is the reason why it should face up to numerous elements together with hail and you will be terrific for dropping any cool down point due to all a blowing wind. Yet, but if the synthetic leather swiss replica watches mainly provides a rather tiny cells lining, maybe you have to the office extremely really hard to have heat during regarding very cold days or weeks which means that will also be necessary replacement affordable handbags substantial a sufficient amount of to fix a lot of cellular layers underneath it. A substitute that’s at the same time great for boisterous days or weeks may be a wax replica watches uk. An exceedingly ENGLISH sorts of replacement affordable handbags, these were first mainly damaged by just gents what person used up your spare time day fishing together with sporting, however layout eventually changed to any standard. Found in together in a straight line together with quilted varieties, together with traditionally from a moderate earth-friendly, most are favored pake panerai watches which can supply some great handy comfort when it is frigid out of doors. It’s at the same time rather very useful for those who normally offer numerous apparatus approximately on you as they definitely typically have numerous budgets, which means that you may see the spot in your mobile, an individual's ideas, a good pad together with anything different maybe you have for you. The fashion community has also possibly not not considered the additional features that your replica watches uk can perform your gear. Including a multitude of premium most women together with mens merino jumpers that will be 100% true have grown famous, to your features listed above.

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. today I want to introduce two of them that enable you to find the maximum or minimum value in a list. Get Some Dosh

    ReplyDelete