Tip Printed from ExcelTip.com

---

Finding Minimum / Maximum Values


Problem:

Column A contains a list of numbers.
We want to find the minimum value in the range between row 2 (first value in the list) and each row number specified in column B.

Solution:

Use the MIN and INDIRECT functions in the following formula:
=MIN(INDIRECT("$A$2:A"&B2))