» Finding Minimum / Maximum Values
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
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))
Book Store:
Recommended Books:
- Now, Discover Your Strengths
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- PowerPoint® 2002 For Dummies®
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Special Edition Using Microsoft Outlook 2002
easy way
onno visser
=min($a$2:a2)
=MIN(INDIRECT("$A$2:A"&ROW())) and for the MAX
=MAX(INDIRECT("$A$2:A"&ROW()))