Let's look at some Excel Small function examples and explore how to use the Small function as a worksheet function in Microsoft Excel:

It's slightly more difficult to find the largest or smallest number in a column. =MAX() shows the largest value and =MIN shows the smallest value. But far more difficult is finding the second smallest value or fourth smallest value.

The SMALL function can be used to return the smallest, second smallest, third smallest and nth smallest values from a range.
For example, if all salespersons are given the same target, we can find out which one achieved the sales target in the shortest time for a given year.
The Small function is a built-in function in Excel that is categorized as a Statistical Function.

Get the nth smallest value.

The SMALL function returns a Smallest numeric value.

This function examines a list of values and picks the value at a user specified position in the list.

=SMALL(array,k)

array - A range from which you want to return the nth smallest value
k - The position from the smallest to return.

No special formatting is needed.

Let's look at some Excel Large function examples and explore how to use the Large function as a worksheet function in Microsoft Excel:

It's slightly more difficult to find the largest or smallest number in a column. =MAX() shows the largest value and =MIN shows the smallest value. But far more difficult is finding the second largest value and third largest value.

The LARGE function can be used to return the largest, second largest, third largest and kth largest values from a range.
The Large function is a built-in function in Excel that is categorized as a Statistical Function.

Get the nth largest value.

The LARGE function returns a largest numeric value.

This function examines a list of values and picks the value at a user specified position in the list.

=LARGE(array,k)

array - A range from which you want to return the nth largest value
k - The position from the largest to return.

No special formatting is needed.

Let's look at some Excel CountA function examples and explore how to use the CountA function as a worksheet function in Microsoft Excel:

When you enter data in Excel, you sometimes do it with a lot of cells left blank to fill them at a later stage when data is available. When you want to count the number of entries you made in a cell range, then you need a specific function in Excel to count only cells that are filled or Non-Blank. For this purpose, you need to use a special built-in function that is called the COUNTA function.
The COUNTA function in Excel counts the number, text, logical values(True or False), error values and empty text ("") of cells in a range that are not empty. COUNTA function ignores empty cells. In other words, the function counts the cells that are not empty or non-blank.
The COUNTA function is a built-in function in Excel that is categorized as a Statistical Function.
See the NOTE section below for more information.

Count the number of non-blank cells.

A number representing non-blank cells.

CountA function has two syntax and hence they can be written in two different ways:

=COUNTA(value1,value2, ...) or
=COUNTA(Range1,Range2,Range3...)

Value: A numeric value or reference.
Range: A group of cells.

No special formatting is needed.

The COUNTA function counts cells that contain numbers, text, logical values, error values, and empty text returned in formulas (""). COUNTA does not count cells that are completely empty. For example, to count non-empty cells in the range A1:A25:

Be aware that COUNTA will also count cells that visually look empty, but actually contain invisible characters or an empty string ("") returned by a formula. You can check which cells are blank using Go To > Special > Blanks:

The following spreadsheet shows six simple examples of the Excel Count function:

The above examples show that each argument to the Min function can be supplied as a single value or cell reference, or as an array of values or cells.

Let's look at some Excel Count function examples and explore how to use the Count function as a worksheet function in Microsoft Excel:

The Excel COUNT function returns the count of values that are numbers, generally cells that contain numbers. If a cell contains text, blank space or any other non-number, it is not counted.
Values can be supplied as constants, cell references, or ranges. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.
The COUNT function is a built-in function in Excel that is categorized as a Statistical Function. It function ignores empty cells, the logical values TRUE and FALSE, and text values.

Count the numbers.

A number representing a count of numbers.

Count function has two syntax and hence they can be written in two different ways:

=COUNT(value1, value2, ...) or
=COUNT(Range1,Range2,Range3...)

Value: A numeric value or reference.
Range: A group of cells.

No special formatting is needed.

The COUNT function counts the number of numbers in supplied values. Values can be items, cell references, or ranges. For example, =COUNT(1, 2, "apple") returns 2. And COUNT(A1:A10) will count the number of numeric values in the range A1:A10.

The following spreadsheet shows six simple examples of the Excel Count function:

The above examples show that each argument to the Min function can be supplied as a single value or cell reference, or as an array of values or cells.

Let's look at some Excel Max function examples and explore how to use the Max function as a worksheet function in Microsoft Excel:

The Excel MIN function returns the smallest numeric value from the numbers provided. This function helps us to locate what the minimum data is located in the spreadsheet or selected range.
The MIN function is a built-in function in Excel that is categorized as a Statistical Function. It function ignores empty cells, the logical values TRUE and FALSE, and text values.
In financial analysis, MIN can be useful in calculating the lowest score, the Minimum time, the lowest expense or revenue amount, minimum salary of the employee, etc.

Get the smallest value.

The smallest value in the array.

Min function has two syntax and hence they can be written in two different ways:

=MIN(Num1,Num2,...) or
=MIN(Range1,Range2,Range3... through to Range30)

Num: A numeric value or reference.
Range: A group of cells.

No special formatting is needed.

The MIN function can be used to return the smallest value from a set of data. For example, the fastest time in a race, the lowest temperature, or the smallest sales number. Arguments can be provided as constants, or as cell references or ranges, for example:

The following spreadsheet shows three simple examples of the Excel Min function:

The above examples show that each argument to the Min function can be supplied as a single value or cell reference, or as an array of values or cells.

Let's look at some Excel Max function examples and explore how to use the Max function as a worksheet function in Microsoft Excel:

The Excel MAX function returns the largest numeric value from the numbers provided. This function helps us to locate what the maximum data is located in the spreadsheet or selected range.
The MAX function is a built-in function in Excel that is categorized as a Statistical Function. It function ignores empty cells, the logical values TRUE and FALSE, and text values.
In financial analysis, MAX can be useful in calculating the highest score, the fastest time, the highest expense or revenue amount, etc.

Get the largest value.

The largest value in the array.

Max function has two syntax and hence they can be written in two different ways:

=MAX(Num1,Num2,...) or
=MAX(Range1,Range2,Range3... through to Range30)

Num: A numeric value or reference.
Range: A group of cells.

No special formatting is needed.

The MAX function can be used to return the largest value from a set of data. For example, the slowest time in a race, the highest temperature, or the top sales number. Arguments can be provided as constants, or as cell references or ranges, for example:

The following spreadsheet shows three simple examples of the Excel Max function:

The above examples show that each argument to the Max function can be supplied as a single value or cell reference, or as an array of values or cells.