MIN and MAX
Finding Extremes: MIN and MAX
Identifying the Highest and Lowest Values in Your Data
In any large list of numbers, finding the absolute highest or lowest value by eye is difficult and prone to error. The MIN and MAX functions scan your data instantly to identify these boundaries.
MIN Function
Returns the Smallest number in a set of values.
=MIN(C2:C8)
Example: Use this to find the lowest price in a vendor list.
MAX Function
Returns the Largest number in a set of values.
=MAX(C2:C8)
Example: Use this to find the highest sales record of the month.
Practical Application
These functions are vital for performance tracking. If you are managing a classroom or a sales team, these allow you to instantly identify:
- The Top Performer (MAX score).
- The Area of Concern (MIN score).
- The Price Range (MAX price - MIN price).
⚡ The Dynamic Dashboard Tip
Unlike finding values manually, these functions are dynamic. If you update the data in your list, the MIN and MAX formulas will recalculate instantly. This makes them perfect for creating summary tables at the top of your spreadsheets.
💡 Skill Eco Pro-Tip: Fast Range Check
Need a quick glance? Highlight your data range and look at the Status Bar. If you don't see Min and Max there, Right-Click the status bar and select them from the menu to see them permanently alongside your Sum and Average!