Microsoft Excel Functions & Formulas

Use the ADDRESS, MATCH, and MIN functions

to find the smallest number

Similar to the previous tip, we can find the cell address for the

smallest value in a list. We will again use the ADDRESS and

MATCH functions but this time in combination with MIN.

The MIN function finds the smallest value in a list. MATCH

returns the relative position of 2, which will be transferred to the

ADDRESS function to determine the cell address as seen in the fol-

lowing figure.

4

To search for the smallest number:

1. In cells A2:A10 list some numbers.

2. Select cell C2 and type the following formula:

=ADDRESS(MATCH(MIN(A1:A10),A1:A10,0),1).

3. Press <Enter>.

214

Chapter 9

Figure ...