• Home
• Training Courses
  Design, Programming & IT Training

  • Mobile Development Training
  • Web Design Training
  • SEO Training
  • ITIL Training
  • Social Media Training
  • Internet Marketing Training
  • Photoshop Training

  • Print Design & DTP Training
  • Microsoft Office Training
  • Programming & Networking Training
  • ISEB / ISTQB Software Testing Training
  • Video & 3D Design Training
  • Microsoft Certified Training

  Business & Management Training

  • PRINCE2 Training
  • Scrum Training
  • Project Management Training
  • Agile Project Management Training
  • Six Sigma Training
  • Lean Training
  • Health and Safety Training

  • Management Training
  • Leadership Training
  • Human Resources, Training & Coaching
  • Business Skills & Personal Development Training
  • Sales and Customer Service Training
  • ISEB Business Analysis Training
  • MSP Training
• Training Dates
• Blog
• Free Resources
• Offers
• Contact
• About Us

Home » Home > Excel Training > Highest and Lowest Numbers

Highest and Lowest Numbers

Written by Alistair Wylie – 06.05.09

Excel also has functions that you can use to identify the smallest and largest numbers of any group or series of numbers. This is particularly useful if you have a very long list of data, and don’t want to have to read through the whole thing to find the biggest or smallest value.

To find the lowest number in a list, the function is =MIN(). Between the brackets I would type in the range of cells – e.g “B1:B10″ or “B1,A1,C10:C15″

If I wanted to find the highest number instead of typing MIN I would type in MAX, i.e. =MAX(B10:B15).

Related posts:

1. Auto Sum
2. Formatting Numbers
3. Changing Your Chart Style
4. Reference Operators
5. Calculating an Average

« Calculating an Average

The Count Function »

Similar resources you may like

Related posts:

1. Auto Sum
2. Formatting Numbers
3. Changing Your Chart Style
4. Reference Operators
5. Calculating an Average

Tags

Excel, excel training, excel training sussex, excel tutorial, Free, microsoft, microsoft excel, Microsoft Office, resource, sussex, Tips, top Tips, Training

Share This Resource

• Digg
• Twitter
• Stumbleupon
• Delicious
• Facebook
• Myspace
• Google
• Technorati
• Newsvine

This entry was posted by Alistair Wylie on Wednesday, May 6th, 2009 at 1:44 pm and is filed under Excel Training. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

Click here to cancel reply.

Name (required)

Mail (will not be published) (required)

Website

 

Search resources:
Search

Follow Silicon Beach Training

• RSS
• Subscribe to Silicon Beach Training - Resources by Email
• Linked In
• Twitter

Join uson

Categories

Upcoming courses

• 7 - 9 Feb 2012
  Software Testing Foundation
• 7 - 8 Feb 2012
  Dreamweaver
• 8 - 10 Feb 2012
  Benefits Management & Business Acceptance
• 9 - 10 Feb 2012
  MSP Practitioner Conversion
• 9 - 10 Feb 2012
  Assertiveness & Confidence Building
• 9 - 10 Feb 2012
  Photoshop for Web Graphics
• 13 - 14 Feb 2012
  Joomla
• 13 - 14 Feb 2012
  Facilitation Skills
• 13 Feb 2012
  Google Analytics
• 13 - 15 Feb 2012
  Foundation in IT-Enabled Business Change
• 13 - 14 Feb 2012
  Certified ScrumMaster
• 13 - 17 Feb 2012
  ITIL Intermediate - Service Offerings & Agreements
• 13 - 17 Feb 2012
  Lean Six Sigma Green Belt
• 13 - 15 Feb 2012
  ITIL Intermediate - Service Transition
• 14 - 16 Feb 2012
  Agile Project Management Foundation

See all course dates »

| | |