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).
Similar resources you may like
Tags
Excel, Excel 2007 Tutorial, excel training, excel tutorial, Free, microsoft, microsoft excel, microsoft office, resource, Tips, top Tips, Training
Share This Resource
Leave a Reply
+44 (0)1273 622272
Follow Silicon Beach Training
Categories
Upcoming courses
- 6 - 10 Sep 2010
2272 - Implementing and Supporting Microsoft Windows XP Professional - 6 - 8 Sep 2010
Lean Processes and Tools - 6 - 10 Sep 2010
Software Test Management - 6 - 8 Sep 2010
PRINCE2 Foundation - 6 Sep 2010
Project Management - 6 - 8 Sep 2010
Project Management & MS Project - 6 - 8 Sep 2010
Systems Development Essentials with Agile - 6 - 10 Sep 2010
PRINCE2 Practitioner - 6 - 8 Sep 2010
Systems Modelling Techniques with UML - 7 - 8 Sep 2010
MS Project - 9 - 10 Sep 2010
PRINCE2 Practitioner Conversion - 9 - 10 Sep 2010
2794 - Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005 - 9 - 10 Sep 2010
Lean Six Sigma Yellow Belt - 9 - 10 Sep 2010
HTML - 9 - 10 Sep 2010
Modelling Business Processes
|
|
|