MIN, MAX, SMALL & LARGE

Excel functions                              Microsoft Excel Examples

 

 

Excel tips on functions and formulas

Excel Functions and Formulas

Excel examples

Excel and VBA Expert

Excel fonctions et formules

Special

Excel Functions

2003-2010

 

sumproduct

index-match

subtotal

iserror

countif

sumif

hlookup

lookup

vlookup

 

 

Special

Excel Functions

2007-2010

 

averageif

averageifs

countifs

sumifs

iferror

 

 

 

 

 

 

 

Excel Functions and Formulas

 

Excel Macros and VBA

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.


Excel Functions and Formulas Sitemap


Go to the next lesson:
Lesson 21: AVERAGEIF (Excel 2007)

 

 

 

Excel tips on functions and formulas

Excel Functions and Formulas

Excel examples

Excel and VBA Expert

Excel fonctions et formules

SUMPRODUCT  ¦  INDEX/MATCH  ¦  SUBTOTAL  ¦  ISERROR  ¦  COUNTIF  ¦  SUMIF  ¦  HLOOKUP  ¦  LOOKUP  ¦  VLOOKUP
AVERAGEIF  ¦  AVERAGEIFS  ¦  COUNTIFS  ¦  SUMIFS  ¦  IFERROR