How to Find the Smallest and Largest Number in Microsoft Excel

If you have a table with a lot of data, you probably sometimes need to find the smallest or largest number. In Microsoft Excel, you can easily do this with a formula.

Watch our video tutorial where we show you how to find the smallest and largest number in Microsoft Excel, using Windows 10.

Video Transcript:

1. How to Find the Smallest and Largest Number in Microsoft Excel
2. We will find the smallest and largest number in fields A1 to A10
3. We’ll find the smallest number first. Click the field where you want to enter the smallest number, and then click on the formula field.
4. Type the equal sign (=), then type the keyword SMALL and open the brackets. First, we enter the fields among which we are looking for the smallest number, in our case it is the fields from A1 to A10.
5. Now type the comma character (,) and the number 1, and then close the parenthesis. The whole formula looks like this: =SMALL(A1:A10,1).
6. If you want, for example, the second smallest number, instead of the number 1, enter the number 2 in the formula.
7. For the largest number, the formula is exactly the same, but instead of the SMALL keyword, we use the LARGE keyword. The formula for the largest number looks like this: =LARGE(A1:A10,1)

Rate:

(No Ratings Yet)

Loading...