Lesson 20: MIN, MAX, SMALL and LARGE Functions in Excel

	A	B	C	D
1	Month	State	Name	Amount
2	May	MI	John	2
3	Jun	NY	Peter	6
4	Mar	PA	John	8
5	Dec	NH	Peter	3
6	Nov	RI	John	4
7	Oct	FL	Peter	6

The MIN functions returns the smallest value in a data set. For example:
=MIN(D2:D7) applied to the data set above should return 2

The SMALL functions returns the first or second or third... smallest value in a data set. For example:
=SMALL(D2:D7,2) applied to the data set above should return 3

So =SMALL(D2:D7,1) will return the same result as =MIN(D2:D7) .

Clean your tool box and forget about MIN now that you know that SMALL does the same as MIN and more.

The MAX functions returns the largest value in a data set. For example:
=MAX(D2:D7) applied to the data set above should return 8

The LARGE functions returns the first or second or third... smallest value in a data set. For example:
=LARGE(D2:D7,2) applied to the data set above should return 6

So =LARGE(D2:D7,1) will return the same result as =MAX(D2:D7) .

Clean your tool box and forget about MAX now that you know that LARGE does the same as MAX and more.

SUMPRODUCT Function in Excel
Links to the Top of the Page

Excel Functions and Formulas Sitemap

Downloadable Tutorials, Examples and Templates