How to Use the MIN Function in Excel

The MIN function in Excel returns the smallest value in a dataset, making it useful for identifying the lowest numbers in your data. In this lesson, you’ll learn how the MIN function works and see how it can be applied to analyze service ticket revenue in an HVAC dataset, helping you quickly identify the smallest jobs or unusually low values.

Download the Excel file used in this tutorial:

Download

How to Use the MIN Function in Excel

1. Choose the numeric column you want to analyze

  • Identify the column that contains the values you want to evaluate.
  • In the video, the example uses a revenue column.
  • The MIN function works with any numeric field, such as:
    • Revenue
    • Service ticket amount
    • Equipment age
    • Parts cost
    • Dates

2. Use MIN on the entire column

  • Type the MIN function and select the full column.
  • This returns the smallest value in that entire column.
  • This approach is helpful when you expect to keep adding new rows to the dataset, because the result will continue updating as new data is entered.

3. Use MIN on a fixed range

  • Type the MIN function again, but this time select only the current data range.
  • In the video, the range is selected quickly using Ctrl + Shift + Down.
  • This returns the smallest value within that defined range only.

4. Compare full-column references vs. fixed ranges

  • The video shows the difference between the two approaches:
    • A full-column reference updates automatically when new data is added
    • A fixed range does not expand unless you edit the formula
  • This matters when your dataset is growing over time.

5. Test how MIN reacts to new data

  • Add a new lower value beneath the current dataset.
  • The full-column MIN updates immediately.
  • The fixed-range MIN stays the same because the new row is outside the original reference.
  • This is a simple way to confirm whether your formula is dynamic or static.

6. Use MIN when you want the lowest value in a dataset

  • This is useful for finding:
    • The smallest service ticket
    • The lowest revenue job
    • The oldest or newest date, depending on the context
    • The lowest parts cost
    • Any unusually low numerical result worth reviewing

7. Use MINIFS when you need conditions

  • The video also introduces MINIFS as the next step when you want the minimum value based on criteria.
  • For example, you could use MINIFS to return the lowest revenue for a specific system type or service category.
  • This is helpful when you want the minimum value within a filtered segment instead of across the entire dataset.

8. Choose the right setup for your reporting

  • Use a full-column MIN when your data is updated regularly and you want the formula to stay current automatically.
  • Use a fixed-range MIN when you want tighter control over exactly which rows are included.

Use MINIFS when you need the minimum value for a specific group or condition.

The MIN Function in Excel

Q1. What does the MIN function do in Excel?
 The MIN function returns the smallest numeric value in a range of cells. It’s commonly used to identify the lowest values in datasets such as revenue, costs, prices, or dates.

Q2. How is the MIN function useful for business analysis?
 Finding the smallest value in a dataset helps identify outliers or unusually low results, such as the lowest sales transaction, smallest service ticket, or the earliest date in a timeline.

Q3. Should I use a column reference or a fixed range with MIN?
 If you reference an entire column, the result will automatically update as new data is added. If you reference a fixed range, Excel will only evaluate the cells inside that defined range.

Q4. Can the MIN function be used with different types of data?
 Yes. The MIN function works with any numeric data, including revenue, costs, quantities, and dates. Since dates are stored as numbers in Excel, MIN can also identify the earliest date in a dataset.

Q5. What is the difference between MIN and MINIFS?
 The MIN function simply returns the lowest value in a range. The MINIFS function allows you to find the lowest value that meets specific conditions, such as the smallest revenue for a particular product or system type.

Q6. Where can I download the dataset used in the video?
 You can download the sample dataset linked below the video tutorial. This allows you to follow along and practice using the MIN function with the same data shown in the lesson.

Get more lessons like this
by joining our newsletter

Receive weekly Excel tutorials, tips, and KPIs straight to your inbox

Join Now

Menu

Databoards

Analysis & Development

© 2025 All Rights Reserved.

Facebook Twitter Youtube