Let's say you want to find out who has the the smallest error rate in a production run at a factory or the largest salary in your department. There are several ways to calculate the smallest or largest number in a range.
If the cells are in a contiguous row or column
-
Select a cell below or to the right of the numbers for which you want to find the smallest number.
-
On the Home tab, in the Editing group, click the arrow next to AutoSum
, click Min (calculates the smallest) or Max (calculates the largest), and then press ENTER.
If the cells are not in a contiguous row or column
To do this task, use the MIN, MAX, SMALL, or LARGE functions.
Example
Copy the following data to a blank worksheet.
|
|
Need more help?
You can always ask an expert in the Excel Tech Community or get support in Communities.
